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.