ACCTIT SAP (Compressed Data from FI/CO Document) Table details
Dictionary Type: Table
Description: Compressed Data from FI/CO Document
Description: Compressed Data from FI/CO Document
Table field list including key, data, relationships and ABAP select examples
ACCTIT is a standard SAP Table which is used to store Compressed Data from FI/CO Document data and is available within R/3 SAP systems depending on the version and release level.
The ACCTIT table consists of various fields, each holding specific information or linking keys about Compressed Data from FI/CO Document data available in SAP. These include MANDT (Client), AWTYP (Reference Transaction), AWREF (Reference Document Number), AWORG (Reference Organizational Units).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ACCTIT table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
AWTYP | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
AWREF | Reference Document Number | AWREF | CHAR | 10 | ALPHA | AWREF | |||
AWORG | Reference Organizational Units | AWORG | CHAR | 10 | AWORG | ||||
POSNR | Accounting Document Line Item Number | POSNR_ACC | NUMC | 10 | POSNR_ACC | ||||
KSTAT | Indicator for Statistical Line Items | KSTAZ | CHAR | 1 | KSTAZ | ||||
AWREF_REV | Reversal: Reverse Document Reference Document Number | AWREF_REV | CHAR | 10 | ALPHA | AWREF | |||
AWORG_REV | Reversal: Reverse Document Reference Organization | AWORG_REV | CHAR | 10 | AWORG | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
WWERT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
MONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
BLART | Document Type | BLART | CHAR | 2 | Assigned to domain | BLART | BAR | ||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
VORGN | Transaction Type for General Ledger | VORGN | CHAR | 4 | VORGN | ||||
PRVRG | Business transaction for validations | PRVRG | CHAR | 4 | Assigned to domain | J_VORGANG | |||
PRVRG_SV | Business transaction for status management | PRVRG_SV | CHAR | 4 | Assigned to domain | J_VORGANG | |||
KTOSL | Transaction Key | KTOSL | CHAR | 3 | CHAR3 | ||||
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | Assigned to domain | UMSKZ | |||
BSCHL | Posting Key | BSCHL | CHAR | 2 | Assigned to domain | BSCHL | |||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
PSWSL | Update Currency for General Ledger Transaction Figures | PSWSL | CUKY | 5 | Assigned to domain | WAERS | |||
PSWBT | Amount for Updating in General Ledger | PSWBT | CURR | 13(2) | WERT7 | ||||
KOART | Account Type | KOART | CHAR | 1 | KOART | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
SAKNR | G/L Account Number | SAKNR | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAK | C_SAKNR |
HKONT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
ALTKT | Account Number in Group | ALTKT | CHAR | 10 | ALPHA | ALTKT | |||
GVTYP | P&L statement account type | GVTYP | CHAR | 2 | CHAR2 | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
BPMNG | Quantity in Purchase Order Price Unit | BPMNG | QUAN | 13(3) | MENG13 | ||||
BPRME | Order Price Unit (Purchasing) | BPRME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | AN1 | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | Assigned to domain | ALPHA | ANLN2 | AN2 | |
ANBWA | Asset Transaction Type | ANBWA | CHAR | 3 | Assigned to domain | BWASL | |||
RMVCT | Transaction Type | RMVCT | CHAR | 3 | Assigned to domain | RMVCT | |||
ABUKR | Company Code which will be Cleared Against | ABUKR | CHAR | 4 | Assigned to domain | BUKRS | |||
AIBN1 | Original asset that was transferred | AIBN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | ||
AIBN2 | Original asset that was transferred | AIBN2 | CHAR | 4 | Assigned to domain | ALPHA | ANLN2 | ||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
BWART | Movement Type (Inventory Management) | BWART | CHAR | 3 | Assigned to domain | BWART | BWA | ||
PARGB | Trading partner's business area | PARGB | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
GSBER_GP | Business area reported to the partner | GSBER_GP | CHAR | 4 | Assigned to domain | GSBER | |||
BUZID | Identification of the Line Item | BUZID | CHAR | 1 | CHAR1 | ||||
HOART | Type of origin object (EC-PCA) | HOART | NUMC | 2 | HOART | PCH | |||
HRKFT | Origin Group as Subdivision of Cost Element | HRKFT | CHAR | 4 | Assigned to domain | HRKFT | |||
HKMAT | Material-related origin | HKMAT | CHAR | 1 | HKMAT | ||||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
KSTRG | Cost Object | KSTRG | CHAR | 12 | Assigned to domain | KSTRG | KTR | ||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PPRCTR | Partner Profit Center | PPRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PPC | |
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | NET | |
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
KZVBR | Consumption Posting | KZVBR | CHAR | 1 | KZVBR | ||||
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | KZBWS | ||||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | Assigned to domain | SOBKZ | |||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
BWKEY | Valuation Area | BWKEY | CHAR | 4 | Assigned to domain | BWKEY | BWK | ||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | Assigned to domain | BWTAR | BWT | ||
VNAME | Joint Venture | JV_NAME | CHAR | 6 | Assigned to domain | ALPHA | JV_NAME | JVV | |
EGRUP | Equity group | JV_EGROUP | CHAR | 3 | Assigned to domain | ALPHA | JV_EGROUP | GJE | |
BTYPE | Payroll Type | JV_BILIND | CHAR | 2 | Assigned to domain | ALPHA | JV_BILIND | ||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
ZEKKN | Sequential Number of Account Assignment | DZEKKN | NUMC | 2 | NUM02 | ||||
RECID | Recovery Indicator | JV_RECIND | CHAR | 2 | Assigned to domain | ALPHA | JV_RECIND | ||
VPTNR | Partner account number | JV_PART | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
XBILK | Indicator: Account is a balance sheet account? | XBILK | CHAR | 1 | XFELD | ||||
XUMSW | Indicator: Sales-related item ? | XUMSW | CHAR | 1 | XFELD | ||||
KZBEW | Movement Indicator | KZBEW | CHAR | 1 | KZBEW | ||||
TBTKZ | Indicator: subsequent debit/credit | TBTKZ | CHAR | 1 | TBTKZ | ||||
XUMBW | Revaluation | XUMBW | CHAR | 1 | XFELD | ||||
SCOPE | Object Class | SCOPE_CV | CHAR | 2 | SCOPE | SCOPE_CV | PCO | ||
AUTYP | Order category | AUFTYP | NUMC | 2 | AUFTYP | ||||
XMFRW | Indicator: Update quantity in RW | XMFRW | CHAR | 1 | XFELD | ||||
BKLAS | Valuation Class | BKLAS | CHAR | 4 | Assigned to domain | BKLAS | |||
BWMOD | Valuation Grouping Code | BWMOD | CHAR | 4 | CHAR4 | ||||
MTART | Material Type | MTART | CHAR | 4 | Assigned to domain | MTART | MTA | ||
KZUML | Stock transfer/transfer posting | KZUML | CHAR | 1 | XFELD | ||||
XPKON | Check account assignment | XPKON | CHAR | 1 | XPKON | ||||
KOAID | Condition class | KOAID | CHAR | 1 | KOAID | ||||
EPRCTR | Partner profit center for elimination of internal business | EPRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | ||
FIKRS | Financial Management Area | FIKRS | CHAR | 4 | Assigned to domain | FIKRS | FIK | ||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | Assigned to domain | FIPOS | FIP | ||
FISTL | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
GEBER | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
KBLNR | Document Number for Earmarked Funds | KBLNR | CHAR | 10 | Assigned to domain | ALPHA | KBLNR | KBL | |
KBLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | Assigned to domain | KBLPOS | KBP | ||
LOTKZ | Lot Number for Documents | LOTKZ | CHAR | 10 | ALPHA | LOTKZ | LOT | ||
STTAX | Tax amount as statistical information in document currency | STTAX | CURR | 13(2) | WERT7 | ||||
BEMOT | Accounting Indicator | BEMOT | CHAR | 2 | Assigned to domain | BEMOT | |||
CO_KAKST | Account Assignment Type: Cost Center | CO_KAKST | NUMC | 1 | CO_KONTKZ | ||||
CO_KAAUF | Account assignment type: Order | CO_KAAUF | NUMC | 1 | CO_KONTKZ | ||||
CO_KAPRO | Project account assignment type | CO_KAPRO | NUMC | 1 | CO_KONTKZ | ||||
CO_KAKTR | Account Assignment Type: Cost Object | CO_KAKTR | NUMC | 1 | CO_KONTKZ | ||||
CO_KANPL | Account Assignment Type: Network | CO_KANPL | NUMC | 1 | CO_KONTKZ | ||||
CO_KAIMO | Account Assignment Type: Real Estate Object | CO_KAIMO | NUMC | 1 | CO_KONTKZ | ||||
CO_KAKDA | Account Assignment Type: Sales Order | CO_KAKDA | NUMC | 1 | CO_KONTKZ | ||||
CO_KAERG | Business segment account assignment type | CO_KAERG | NUMC | 1 | CO_KONTKZ | ||||
CO_KAABS | Account assignment type: reconciliation object | CO_KAABS | NUMC | 1 | CO_KONTKZ | ||||
CO_KAPRZ | Account Assignment Type: Business Process | CO_KAPRZ | NUMC | 1 | CO_KONTKZ | ||||
CO_KASAT | Account Assignment Type Not Used | CO_KASAT | NUMC | 1 | CO_KONTKZ | ||||
BUSTW | Posting string for values | BUSTW | CHAR | 4 | BUSTW | ||||
ZEILE | Item in material or invoice verification document | CK_ZEILE | NUMC | 6 | NUMC6 | ||||
URZEILE | Original item in material or invoice document | CK_URZEILE | NUMC | 6 | NUMC6 | ||||
PSTYP | Item Category in Purchasing Document | PSTYP | CHAR | 1 | Assigned to domain | PSTYP | |||
FKBER | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
ERFMG | Quantity in Unit of Entry | ERFMG | QUAN | 13(3) | MENG13 | ||||
ERFME | Unit of Entry | ERFME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DABRZ | Reference Date for Settlement | DABRBEZ | DATS | 8 | DDAT | ||||
APLZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | Assigned to domain | J_1BBRANCH | |||
SECCO | Section Code | SECCO | CHAR | 4 | Assigned to domain | SECCO | SECCO_ABA | ||
LOKKT | Account Number in the Local Chart of Accounts | LOKKT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
LSTAR | Activity Type | LSTAR | CHAR | 6 | Assigned to domain | LSTAR | LAR | LART_EMPTY | |
PRZNR | Business Process | CO_PRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | KWP | |
XNEGP | Indicator: Negative posting | XNEGP | CHAR | 1 | XFELD | ||||
MAT_KDAUF | Sales Order Number of Valuated Sales Order Stock | MAT_KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
MAT_KDPOS | Sales Order Item of Valuated Sales Order Stock | MAT_KDPOS | NUMC | 6 | NUM06 | KPO | |||
MAT_PSPNR | Valuated Sales Order Stock WBS Element | MAT_PSPNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
LOGVO | Logical Transaction | LOGVO | CHAR | 6 | LOGVO | ||||
XBGBB | Posting for offsetting entry | XBGBB | CHAR | 1 | XFELD | ||||
TPKNZ | Transfer Price Indicator | TPKNZ | NUMC | 1 | TPKNZ | ||||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
AUFPS | Order Item Number | CO_POSNR | NUMC | 4 | CO_POSNR | ||||
SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
PSEGMENT | Partner Segment for Segmental Reporting | FB_PSEGMENT | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
AUBEL | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
AUPOS | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
MEASURE | Funded Program | FM_MEASURE | CHAR | 24 | Assigned to domain | FM_MEASURE | FM_MEASURE | ||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
POSN2 | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
POSNR_SD | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
PSOBT | Posting Day | PSOBT | DATS | 8 | DATUM | ||||
PSOZL | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | GJAHR | GJAHR | |||
REBZT | Follow-On Document Type | REBZT | CHAR | 1 | REBZT | ||||
REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 3 | BUZEI | ||||
SHKZG_VA | Returns Item | SHKZG_VA | CHAR | 1 | XFELD | ||||
STHTX | Tax Amount as Statistical Information in Co. Code Currency | STHTX | CURR | 13(2) | WERT7 | ||||
TAXIT | Indicator: Tax Item | TAXIT | CHAR | 1 | CHAR1 | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
VBEL2 | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
XAUTO | Indicator: Line item automatically created | XAUTO | CHAR | 1 | XFELD | ||||
XREF2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 | ||||
ZBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
ZBD1T | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
FMXDOCNR | FM Reference Document Number | FM_XDOCNR | CHAR | 10 | ALPHA | BELNR | |||
FMXYEAR | FM Reference Year | FM_XYEAR | NUMC | 4 | GJAHR | GJAHR | |||
FMXDOCLN | FM Reference Line Item | FM_XDOCLN | NUMC | 6 | NUMC6 | ||||
FMXZEKKN | FM Reference Sequence Account Assignment | FM_XZEKKN | NUMC | 5 | NUMC5 | ||||
.INCLU--AP | 0 | ||||||||
ANL01 | Main Asset Number | ANLN1 | CHAR | 12 | ANLH | ALPHA | ANLN1 | AN1 | |
ANL02 | Asset Subnumber | ANLN2 | CHAR | 4 | ANLA | ALPHA | ANLN2 | AN2 | |
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | HBKID | |||
PRODPER | Production Month (Date to find period and year) | JV_PRODPER | DATS | 8 | JV_PRODPER |
Key field | Non-key field |
How do I retrieve data from SAP table ACCTIT using ABAP code
The following ABAP code Example will allow you to do a basic selection on ACCTIT to SELECT all data from the tableDATA: WA_ACCTIT TYPE ACCTIT.
SELECT SINGLE *
FROM ACCTIT
INTO CORRESPONDING FIELDS OF WA_ACCTIT
WHERE...
How to access SAP table ACCTIT
Within an ECC or HANA version of SAP you can also view further information about ACCTIT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects