Saturday, May 18, 2024

SAP Table ACCTIT – Compressed Data from FI/CO Document

ACCTIT is a standard SAP table in SAP ECC (or) S/4HANA which stores Compressed Data from FI/CO Document data. There are total 182 fields in ACCTIT table.This blog post provides key technical details of SAP table ACCTIT, including its availability across SAP S/4HANA versions and the list of CDS views for ACCTIT table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package Financial Accounting “Basis” (FBAS)
Technical Component Financial Accounting (FI)

SAP ACCTIT Table Fields

The following is the list of fields that are available in SAP ACCTIT table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
MANDT Client MANDT MANDT * CLNT (3)
AWTYP Reference procedure AWTYP AWTYP * CHAR (5)
AWREF Reference document number AWREF AWREF CHAR (10)
AWORG Reference Organizational Units AWORG AWORG CHAR (10)
POSNR Accounting Document Line Item Number POSNR_ACC POSNR_ACC NUMC (10)
KSTAT Indicator for Statistical Line Items KSTAZ KSTAZ CHAR (1)
AWREF_REV Reversal: Reference Document No. of Document to Be Reversed AWREF_REV AWREF CHAR (10)
AWORG_REV Reversal: Reference Organizations of Document to Be Reversed AWORG_REV AWORG CHAR (10)
BUKRS Company Code BUKRS BUKRS CHAR (4)
BELNR Accounting Document Number BELNR_D BELNR CHAR (10)
GJAHR Fiscal Year GJAHR GJAHR NUMC (4)
BLDAT Document Date in Document BLDAT DATUM DATS (8)
BUDAT Posting Date in the Document BUDAT DATUM DATS (8)
WWERT Translation date WWERT_D DATUM DATS (8)
VALUT Value date VALUT DATUM DATS (8)
MONAT Fiscal period MONAT MONAT NUMC (2)
BLART Document Type BLART BLART CHAR (2)
XBLNR Reference Document Number XBLNR1 XBLNR1 CHAR (16)
VORGN Transaction Type for General Ledger VORGN VORGN CHAR (4)
PRVRG Business Transaction for Validations PRVRG J_VORGANG CHAR (4)
PRVRG_SV Business transaction for status management PRVRG_SV J_VORGANG CHAR (4)
KTOSL Transaction Key KTOSL CHAR3 CHAR (3)
UMSKZ Special G/L Indicator UMSKZ UMSKZ CHAR (1)
BSCHL Posting Key BSCHL BSCHL CHAR (2)
SHKZG Debit/Credit Indicator SHKZG SHKZG CHAR (1)
PSWSL Update Currency for General Ledger Transaction Figures PSWSL WAERS CUKY (5)
PSWBT Amount for Updating in General Ledger PSWBT AFLE13D2O16N_TO_23D2O30N CURR (23)
KOART Account type KOART KOART CHAR (1)
KUNNR Customer Number KUNNR KUNNR CHAR (10)
LIFNR Account Number of Vendor or Creditor LIFNR LIFNR CHAR (10)
SAKNR G/L Account Number SAKNR SAKNR CHAR (10)
HKONT General Ledger Account HKONT SAKNR CHAR (10)
ALTKT Account Number in Group ALTKT ALTKT CHAR (10)
GVTYP P&L statement account type GVTYP CHAR2 CHAR (2)
SGTXT Item Text SGTXT TEXT50 CHAR (50)
GSBER Business Area GSBER GSBER CHAR (4)
KOSTL Cost Center KOSTL KOSTL CHAR (10)
KOKRS Controlling Area KOKRS CACCD CHAR (4)
PERNR Personnel Number PERNR_D PERNR NUMC (8)
BPMNG Quantity in Purchase Order Price Unit BPMNG MENG13 QUAN (13)
BPRME Order Price Unit (Purchasing) BPRME MEINS UNIT (3)
AUFNR Order Number AUFNR AUFNR CHAR (12)
ANLN1 Main Asset Number ANLN1 ANLN1 CHAR (12)
ANLN2 Asset Subnumber ANLN2 ANLN2 CHAR (4)
ANBWA Asset Transaction Type ANBWA BWASL CHAR (3)
RMVCT Transaction type RMVCT RMVCT CHAR (3)
ABUKR Company Code Which Will Be Cleared Against ABUKR BUKRS CHAR (4)
AIBN1 Original Asset That Was Transferred AIBN1 ANLN1 CHAR (12)
AIBN2 Original Asset That Was Transferred AIBN2 ANLN2 CHAR (4)
MATNR Material Number MATNR MATNR CHAR (40)
MENGE Quantity MENGE_D MENG13 QUAN (13)
MEINS Base Unit of Measure MEINS MEINS UNIT (3)
WERKS Plant WERKS_D WERKS CHAR (4)
BWART Movement type (inventory management) BWART BWART CHAR (3)
PARGB Trading partner’s business area PARGB GSBER CHAR (4)
GSBER_GP Business area reported to the partner GSBER_GP GSBER CHAR (4)
BUZID Identification of the Line Item BUZID CHAR1 CHAR (1)
HOART Type of origin object (EC-PCA) HOART HOART NUMC (2)
HRKFT Origin Group as Subdivision of Cost Element HRKFT HRKFT CHAR (4)
HKMAT Material-related origin HKMAT HKMAT CHAR (1)
IMKEY Internal Key for Real Estate Object IMKEY IMKEY CHAR (8)
KSTRG Cost Object KSTRG KSTRG CHAR (12)
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR RKEOBJNR NUMC (10)
PRCTR Profit Center PRCTR PRCTR CHAR (10)
PPRCTR Partner Profit Center PPRCTR PRCTR CHAR (10)
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PS_POSNR NUMC (8)
NPLNR Network Number for Account Assignment NPLNR AUFNR CHAR (12)
AUFPL Routing number of operations in the order CO_AUFPL AUFPL NUMC (10)
VBELN Sales and Distribution Document Number VBELN VBELN CHAR (10)
KDAUF Sales Order Number KDAUF VBELN CHAR (10)
KDPOS Item number in Sales Order KDPOS NUM06 NUMC (6)
KZVBR Consumption posting KZVBR KZVBR CHAR (1)
KZBWS Valuation of Special Stock KZBWS KZBWS CHAR (1)
SOBKZ Special Stock Indicator SOBKZ SOBKZ CHAR (1)
VBUND Company ID of Trading Partner RASSC RCOMP CHAR (6)
BWKEY Valuation area BWKEY BWKEY CHAR (4)
BWTAR Valuation Type BWTAR_D BWTAR CHAR (10)
VNAME Joint venture JV_NAME JV_NAME CHAR (6)
EGRUP Equity group JV_EGROUP JV_EGROUP CHAR (3)
BTYPE Payroll Type JV_BILIND JV_BILIND CHAR (2)
EBELN Purchasing Document Number EBELN EBELN CHAR (10)
EBELP Item Number of Purchasing Document EBELP EBELP NUMC (5)
ZEKKN Sequential Number of Account Assignment DZEKKN NUM02 NUMC (2)
RECID Recovery Indicator JV_RECIND JV_RECIND CHAR (2)
VPTNR Partner account number JV_PART KUNNR CHAR (10)
XBILK Indicator: Account is a balance sheet account? XBILK XFELD CHAR (1)
XUMSW Indicator: Sales-Related Item ? XUMSW XFELD CHAR (1)
KZBEW Movement Indicator KZBEW KZBEW CHAR (1)
TBTKZ Indicator: Subsequent Debit/Credit TBTKZ TBTKZ CHAR (1)
XUMBW Revaluation XUMBW XFELD CHAR (1)
SCOPE Object Class SCOPE_CV SCOPE_CV CHAR (2)
AUTYP Order category AUFTYP AUFTYP NUMC (2)
XMFRW Indicator: Update Quantity in Accounting XMFRW XFELD CHAR (1)
BKLAS Valuation Class BKLAS BKLAS CHAR (4)
BWMOD Valuation Grouping Code BWMOD CHAR4 CHAR (4)
MTART Material type MTART MTART CHAR (4)
KZUML Stock transfer/transfer posting KZUML XFELD CHAR (1)
XPKON Check account assignment XPKON XPKON CHAR (1)
KOAID Condition Class KOAID KOAID CHAR (1)
EPRCTR Partner profit center for elimination of internal business EPRCTR PRCTR CHAR (10)
FIKRS Financial Management Area FIKRS FIKRS CHAR (4)
FIPOS Commitment Item FIPOS FIPOS CHAR (14)
FISTL Funds Center FISTL FISTL CHAR (16)
GEBER Fund BP_GEBER BP_GEBER CHAR (10)
KBLNR Document Number for Earmarked Funds KBLNR KBLNR CHAR (10)
KBLPOS Earmarked Funds: Document Item KBLPOS KBLPOS NUMC (3)
LOTKZ Lot Number for Documents LOTKZ LOTKZ CHAR (10)
STTAX Tax Amount as Statistical Information in Document Currency STTAX WERT7 CURR (13)
BEMOT Accounting Indicator BEMOT BEMOT CHAR (2)
CO_KAKST Account Assignment Type: Cost Center CO_KAKST CO_KONTKZ NUMC (1)
CO_KAAUF Account Assignment Type: Order CO_KAAUF CO_KONTKZ NUMC (1)
CO_KAPRO Project Account Assignment Type CO_KAPRO CO_KONTKZ NUMC (1)
CO_KAKTR Account Assignment Type: Cost Object CO_KAKTR CO_KONTKZ NUMC (1)
CO_KANPL Account Assignment Type: Network CO_KANPL CO_KONTKZ NUMC (1)
CO_KAIMO Account Assignment Type: Real Estate Object CO_KAIMO CO_KONTKZ NUMC (1)
CO_KAKDA Account Assignment Type: Sales Order CO_KAKDA CO_KONTKZ NUMC (1)
CO_KAERG Business Segment Account Assignment Type CO_KAERG CO_KONTKZ NUMC (1)
CO_KAABS Account Assignment Type: Reconciliation Object CO_KAABS CO_KONTKZ NUMC (1)
CO_KAPRZ Account Assignment Type: Business Process CO_KAPRZ CO_KONTKZ NUMC (1)
CO_KASVD Account Assignment Type: Service Document CO_KASVD CO_KONTKZ NUMC (1)
CO_KASAT Account Assignment Type Not Used CO_KASAT CO_KONTKZ NUMC (1)
BUSTW Posting String for Values BUSTW BUSTW CHAR (4)
ZEILE Item in Material or Invoice Verification Document CK_ZEILE NUMC6 NUMC (6)
URZEILE Original Item in Material or Invoice Document CK_URZEILE NUMC6 NUMC (6)
PSTYP Item category in purchasing document PSTYP PSTYP CHAR (1)
FKBER Functional Area FKBER FKBER CHAR (16)
ERFMG Quantity in unit of entry ERFMG MENG13 QUAN (13)
ERFME Unit of entry ERFME MEINS UNIT (3)
DABRZ Reference date for settlement DABRBEZ DDAT DATS (8)
APLZL Internal counter CIM_COUNT CIM_COUNT NUMC (8)
BUPLA Business Place BUPLA J_1BBRANCH CHAR (4)
SECCO Section Code SECCO SECCO CHAR (4)
LOKKT Account Number in the Local Chart of Accounts LOKKT SAKNR CHAR (10)
LSTAR Activity Type LSTAR LSTAR CHAR (6)
PRZNR Business Process CO_PRZNR CO_PRZNR CHAR (12)
XNEGP Indicator: Negative Posting XNEGP XFELD CHAR (1)
MAT_KDAUF Sales order number of valuated sales order stock MAT_KDAUF VBELN CHAR (10)
MAT_KDPOS Sales Order Item of Valuated Sales Order Stock MAT_KDPOS NUM06 NUMC (6)
MAT_PSPNR Valuated Sales Order Stock WBS Element MAT_PSPNR PS_POSNR NUMC (8)
LOGVO Logical Transaction LOGVO LOGVO CHAR (6)
XBGBB Posting for offsetting entry XBGBB XFELD CHAR (1)
TPKNZ Transfer Price Indicator TPKNZ TPKNZ NUMC (1)
GRANT_NBR Grant GM_GRANT_NBR GM_GRANT_NBR CHAR (20)
AUFPS Order item number CO_POSNR CO_POSNR NUMC (4)
SEGMENT Segment for Segmental Reporting FB_SEGMENT FB_SEGMENT CHAR (10)
PSEGMENT Partner Segment for Segmental Reporting FB_PSEGMENT FB_SEGMENT CHAR (10)
BUDGET_PD Budget Period FM_BUDGET_PERIOD FM_BUDGET_PERIOD CHAR (10)
AUBEL Sales Document VBELN_VA VBELN CHAR (10)
AUPOS Sales Document Item POSNR_VA POSNR NUMC (6)
BUZEI Number of Line Item Within Accounting Document BUZEI BUZEI NUMC (3)
MEASURE Funded Program FM_MEASURE FM_MEASURE CHAR (24)
MWSKZ Tax on sales/purchases code MWSKZ MWSKZ CHAR (2)
POSN2 Sales Document Item POSNR_VA POSNR NUMC (6)
POSNR_SD Item number of the SD document POSNR POSNR NUMC (6)
PSOBT Posting Day PSOBT DATUM DATS (8)
PSOZL Checkbox XFELD XFELD CHAR (1)
REBZG Document No. of the Invoice to Which the Transaction Belongs REBZG BELNR CHAR (10)
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) REBZJ GJAHR NUMC (4)
REBZT Follow-On Document Type REBZT REBZT CHAR (1)
REBZZ Line Item in the Relevant Invoice REBZZ BUZEI NUMC (3)
SHKZG_VA Returns Item SHKZG_VA XFELD CHAR (1)
STHTX Tax Amount as Statistical Information in Co. Code Currency STHTX AFLE13D2O16N_TO_23D2O30N CURR (23)
TAXIT Indicator: Tax Item TAXIT CHAR1 CHAR (1)
TXJCD Tax Jurisdiction TXJCD TXJCD CHAR (15)
VBEL2 Sales Document VBELN_VA VBELN CHAR (10)
XAUTO Indicator: Line item automatically created XAUTO XFELD CHAR (1)
XREF2 Business Partner Reference Key XREF2 CHAR12 CHAR (12)
XREF3 Reference key for line item XREF3 CHAR20 CHAR (20)
ZBD1P Cash discount percentage 1 DZBD1P PRZ23 DEC (5)
ZBD1T Cash discount days 1 DZBD1T ZBDXT DEC (3)
ZBD2T Cash discount days 2 DZBD2T ZBDXT DEC (3)
ZBD3T Net Payment Terms Period DZBD3T ZBDXT DEC (3)
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATUM DATS (8)
ZUONR Assignment number DZUONR ZUONR CHAR (18)
FMXDOCNR FM Reference Document Number FM_XDOCNR BELNR CHAR (10)
FMXYEAR FM Reference Year FM_XYEAR GJAHR NUMC (4)
FMXDOCLN FM Reference Line Item FM_XDOCLN NUMC6 NUMC (6)
FMXZEKKN FM Reference Sequence Account Assignment FM_XZEKKN NUMC5 NUMC (5)
ANL01 Main Asset Number ANLN1 ANLN1 ANLH CHAR (12)
ANL02 Asset Subnumber ANLN2 ANLN2 ANLA CHAR (4)
HBKID Short Key for a House Bank HBKID HBKID T012 CHAR (5)
PRODPER Production Month (Date to find period and year) JV_PRODPER JV_PRODPER DATS (8)

Availability

The SAP table ACCTIT is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for ACCTIT table

There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.