SAP Table ACCTIT

Compressed Data from FI/CO Document

ACCTIT (Compressed Data from FI/CO Document) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ACCTIT to other SAP tables.

ACCTIT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
AWTYP Reference Transaction AWTYP CHAR 5 0
AWREF Reference Document Number AWREF CHAR 10 0
AWORG Reference Organizational Units AWORG CHAR 10 0
POSNR Accounting Document Line Item Number POSNR_ACC NUMC 10 0
KSTAT Indicator for Statistical Line Items KSTAZ CHAR 1 0
NULL Not statistical
X Statistical condition
U Non-valuated goods receipt
A FI document header without real line item
AWREF_REV Reversal: Reverse Document Reference Document Number AWREF_REV CHAR 10 0
AWORG_REV Reversal: Reverse Document Reference Organization AWORG_REV CHAR 10 0
BUKRS Company Code BUKRS CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BLDAT Document Date in Document BLDAT DATS 8 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
WWERT Translation Date WWERT_D DATS 8 0
VALUT Value date VALUT DATS 8 0
MONAT Fiscal Period MONAT NUMC 2 0
BLART Document Type BLART CHAR 2 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
VORGN Transaction Type for General Ledger VORGN CHAR 4 0
PRVRG Business transaction for validations PRVRG CHAR 4 0
PRVRG_SV Business transaction for status management PRVRG_SV CHAR 4 0
KTOSL Transaction Key KTOSL CHAR 3 0
UMSKZ Special G/L Indicator UMSKZ CHAR 1 0
BSCHL Posting Key BSCHL CHAR 2 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
PSWSL Update Currency for General Ledger Transaction Figures PSWSL CUKY 5 0
PSWBT Amount for Updating in General Ledger PSWBT CURR 13 2
KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
KUNNR Customer Number KUNNR CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
SAKNR G/L Account Number SAKNR CHAR 10 0
HKONT General Ledger Account HKONT CHAR 10 0
ALTKT Account Number in Group ALTKT CHAR 10 0
GVTYP P&L statement account type GVTYP CHAR 2 0
SGTXT Item Text SGTXT CHAR 50 0
GSBER Business Area GSBER CHAR 4 0
KOSTL Cost Center KOSTL CHAR 10 0
KOKRS Controlling Area KOKRS CHAR 4 0
PERNR Personnel Number PERNR_D NUMC 8 0
BPMNG Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
BPRME Order Price Unit (Purchasing) BPRME UNIT 3 0
AUFNR Order Number AUFNR CHAR 12 0
ANLN1 Main Asset Number ANLN1 CHAR 12 0
ANLN2 Asset Subnumber ANLN2 CHAR 4 0
ANBWA Asset Transaction Type ANBWA CHAR 3 0
RMVCT Transaction Type RMVCT CHAR 3 0
ABUKR Company Code which will be Cleared Against ABUKR CHAR 4 0
AIBN1 Original asset that was transferred AIBN1 CHAR 12 0
AIBN2 Original asset that was transferred AIBN2 CHAR 4 0
MATNR Material Number MATNR CHAR 18 0
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
WERKS Plant WERKS_D CHAR 4 0
BWART Movement Type (Inventory Management) BWART CHAR 3 0
PARGB Trading partner's business area PARGB CHAR 4 0
GSBER_GP Business area reported to the partner GSBER_GP CHAR 4 0
BUZID Identification of the Line Item BUZID CHAR 1 0
HOART Type of origin object (EC-PCA) HOART NUMC 2 0
01 Profit Center
02 Cost Center
03 Overhead Cost Order
04 Production Order
05 Billing Document
06 Sales Order
07 WBS Element
08 Network
09 Network Activity
10 Profitability Segment in Account-Based CO-PA
11 Cost Object
12 Business Process
13 Fixed Asset
14 Material
15 Maintenance Order
16 Maintenance Plan
17 SOP Order
18 G/L Account
19 Material Stocks
20 Investment Order
21 Sales Order
22 Asset Portfolios
23 Work in Process
24 Receivables
25 Payables
26 Assets under Construction
27 Cash Discount
28 Credit Valuation Difference
29 Debit Valuation Difference
31 Net Cash Discounts
32 Tax
33 Planned Orders
34 Profitability Segment in Costing-Based CO-PA
35 Additional Balance Sheet Accounts and P&L Accounts
36 Order Items
38 Settlement Unit
39 Buildings
40 Management Contract
41 Real Estate
42 Rental Unit
43 Lease-Out
44 Business Entity
45 Reconciliation Object
88 Profit Center Costing
98 Reconciliation of Differences
99 Legacy Data from a 2.x Release
46 Real Estate General Contract
HRKFT Origin Group as Subdivision of Cost Element HRKFT CHAR 4 0
HKMAT Material-related origin HKMAT CHAR 1 0
NULL No material-related origin
X Keep costs/quantities under material number
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
KSTRG Cost Object KSTRG CHAR 12 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PRCTR Profit Center PRCTR CHAR 10 0
PPRCTR Partner Profit Center PPRCTR CHAR 10 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
NPLNR Network Number for Account Assignment NPLNR CHAR 12 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
VBUND Company ID of trading partner RASSC CHAR 6 0
BWKEY Valuation Area BWKEY CHAR 4 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
VNAME Joint Venture JV_NAME CHAR 6 0
EGRUP Equity group JV_EGROUP CHAR 3 0
BTYPE Payroll Type JV_BILIND CHAR 2 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2 0
RECID Recovery Indicator JV_RECIND CHAR 2 0
VPTNR Partner account number JV_PART CHAR 10 0
XBILK Indicator: Account is a balance sheet account? XBILK CHAR 1 0
X Yes
NULL No
XUMSW Indicator: Sales-related item ? XUMSW CHAR 1 0
X Yes
NULL No
KZBEW Movement Indicator KZBEW CHAR 1 0
NULL Goods movement w/o reference
B Goods movement for purchase order
F Goods movement for production order
L Goods movement for delivery note
K Goods movement for kanban requirement (WM - internal only)
O Subsequent adjustment of "material-provided" consumption
W Subsequent adjustment of proportion/product unit material
TBTKZ Indicator: subsequent debit/credit TBTKZ CHAR 1 0
XUMBW Revaluation XUMBW CHAR 1 0
X Yes
NULL No
SCOPE Object Class SCOPE_CV CHAR 2 0
OC Overhead costs
IV Investment
PR Production
PA Profit analysis
AUTYP Order category AUFTYP NUMC 2 0
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
XMFRW Indicator: Update quantity in RW XMFRW CHAR 1 0
X Yes
NULL No
BKLAS Valuation Class BKLAS CHAR 4 0
BWMOD Valuation Grouping Code BWMOD CHAR 4 0
MTART Material Type MTART CHAR 4 0
KZUML Stock transfer/transfer posting KZUML CHAR 1 0
X Yes
NULL No
XPKON Check account assignment XPKON CHAR 1 0
KOAID Condition class KOAID CHAR 1 0
A Discount or surcharge
B Prices
C Expense reimbursement
D Taxes
E Extra pay
F Fees or differential (only IS-OIL)
G Tax Classification
H Determining sales deal
Q Totals record for fees (only IS-OIL)
W Wage Withholding Tax
EPRCTR Partner profit center for elimination of internal business EPRCTR CHAR 10 0
FIKRS Financial Management Area FIKRS CHAR 4 0
FIPOS Commitment Item FIPOS CHAR 14 0
FISTL Funds Center FISTL CHAR 16 0
GEBER Fund BP_GEBER CHAR 10 0
KBLNR Document Number for Earmarked Funds KBLNR CHAR 10 0
KBLPOS Earmarked Funds: Document Item KBLPOS NUMC 3 0
LOTKZ Lot Number for Documents LOTKZ CHAR 10 0
STTAX Tax amount as statistical information in document currency STTAX CURR 13 2
BEMOT Accounting Indicator BEMOT CHAR 2 0
CO_KAKST Account Assignment Type: Cost Center CO_KAKST NUMC 1 0
0 Not assigned
1 Assigned with real values
2 Assigned with stat. values
CO_KAAUF Account assignment type: Order CO_KAAUF NUMC 1 0
0 Not assigned
1 Assigned with real values
2 Assigned with stat. values
CO_KAPRO Project account assignment type CO_KAPRO NUMC 1 0
0 Not assigned
1 Assigned with real values
2 Assigned with stat. values
CO_KAKTR Account Assignment Type: Cost Object CO_KAKTR NUMC 1 0
0 Not assigned
1 Assigned with real values
2 Assigned with stat. values
CO_KANPL Account Assignment Type: Network CO_KANPL NUMC 1 0
0 Not assigned
1 Assigned with real values
2 Assigned with stat. values
CO_KAIMO Account Assignment Type: Real Estate Object CO_KAIMO NUMC 1 0
0 Not assigned
1 Assigned with real values
2 Assigned with stat. values
CO_KAKDA Account Assignment Type: Sales Order CO_KAKDA NUMC 1 0
0 Not assigned
1 Assigned with real values
2 Assigned with stat. values
CO_KAERG Business segment account assignment type CO_KAERG NUMC 1 0
0 Not assigned
1 Assigned with real values
2 Assigned with stat. values
CO_KAABS Account assignment type: reconciliation object CO_KAABS NUMC 1 0
0 Not assigned
1 Assigned with real values
2 Assigned with stat. values
CO_KAPRZ Account Assignment Type: Business Process CO_KAPRZ NUMC 1 0
0 Not assigned
1 Assigned with real values
2 Assigned with stat. values
CO_KASAT Account Assignment Type Not Used CO_KASAT NUMC 1 0
0 Not assigned
1 Assigned with real values
2 Assigned with stat. values
BUSTW Posting string for values BUSTW CHAR 4 0
ZEILE Item in material or invoice verification document CK_ZEILE NUMC 6 0
URZEILE Original item in material or invoice document CK_URZEILE NUMC 6 0
PSTYP Item Category in Purchasing Document PSTYP CHAR 1 0
FKBER Functional Area FKBER CHAR 16 0
ERFMG Quantity in Unit of Entry ERFMG QUAN 13 3
ERFME Unit of Entry ERFME UNIT 3 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
APLZL Internal counter CIM_COUNT NUMC 8 0
BUPLA Business Place BUPLA CHAR 4 0
SECCO Section Code SECCO CHAR 4 0
LOKKT Account Number in the Local Chart of Accounts LOKKT CHAR 10 0
LSTAR Activity Type LSTAR CHAR 6 0
PRZNR Business Process CO_PRZNR CHAR 12 0
XNEGP Indicator: Negative posting XNEGP CHAR 1 0
X Yes
NULL No
MAT_KDAUF Sales Order Number of Valuated Sales Order Stock MAT_KDAUF CHAR 10 0
MAT_KDPOS Sales Order Item of Valuated Sales Order Stock MAT_KDPOS NUMC 6 0
MAT_PSPNR Valuated Sales Order Stock WBS Element MAT_PSPNR NUMC 8 0
LOGVO Logical Transaction LOGVO CHAR 6 0
XBGBB Posting for offsetting entry XBGBB CHAR 1 0
X Yes
NULL No
TPKNZ Transfer Price Indicator TPKNZ NUMC 1 0
1 Internal revenues
2 Internal stock changes: Sender
3 Internal stock changes: Receiver
4 Internal deliveries from other profit centers
5 Valuation transfer line
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
AUFPS Order Item Number CO_POSNR NUMC 4 0
SEGMENT Segment for Segmental Reporting FB_SEGMENT CHAR 10 0
PSEGMENT Partner Segment for Segmental Reporting FB_PSEGMENT CHAR 10 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
AUBEL Sales Document VBELN_VA CHAR 10 0
AUPOS Sales Document Item POSNR_VA NUMC 6 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
MEASURE Funded Program FM_MEASURE CHAR 24 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
POSN2 Sales Document Item POSNR_VA NUMC 6 0
POSNR_SD Item number of the SD document POSNR NUMC 6 0
PSOBT Posting Day PSOBT DATS 8 0
PSOZL Checkbox XFELD CHAR 1 0
X Yes
NULL No
REBZG Number of the Invoice the Transaction Belongs to REBZG CHAR 10 0
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) REBZJ NUMC 4 0
REBZT Follow-On Document Type REBZT CHAR 1 0
REBZZ Line Item in the Relevant Invoice REBZZ NUMC 3 0
SHKZG_VA Returns Item SHKZG_VA CHAR 1 0
X Yes
NULL No
STHTX Tax Amount as Statistical Information in Co. Code Currency STHTX CURR 13 2
TAXIT Indicator: Tax Item TAXIT CHAR 1 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
VBEL2 Sales Document VBELN_VA CHAR 10 0
XAUTO Indicator: Line item automatically created XAUTO CHAR 1 0
X Yes
NULL No
XREF2 Business partner reference key XREF2 CHAR 12 0
XREF3 Reference key for line item XREF3 CHAR 20 0
ZBD1P Cash Discount Percentage 1 DZBD1P DEC 5 3
ZBD1T Cash discount days 1 DZBD1T DEC 3 0
ZBD2T Cash discount days 2 DZBD2T DEC 3 0
ZBD3T Net Payment Terms Period DZBD3T DEC 3 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
ZUONR Assignment Number DZUONR CHAR 18 0
FMXDOCNR FM Reference Document Number FM_XDOCNR CHAR 10 0
FMXYEAR FM Reference Year FM_XYEAR NUMC 4 0
FMXDOCLN FM Reference Line Item FM_XDOCLN NUMC 6 0
FMXZEKKN FM Reference Sequence Account Assignment FM_XZEKKN NUMC 5 0
ANL01 Main Asset Number ANLN1 ANLH CHAR 12 0
ANL02 Asset Subnumber ANLN2 ANLA CHAR 4 0
HBKID Short Key for a House Bank HBKID T012 CHAR 5 0
PRODPER Production Month (Date to find period and year) JV_PRODPER DATS 8 0
OITAXGRP Excise Duty Group OIH_TAXGRP OIH2 CHAR 2 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP OIH5 CHAR 2 0
OITAXFROM Excise duty tax key for 'from' location OIH_TAXFRO OIH4 CHAR 2 0
OITAXTO Excise duty tax key for 'to' location OIH_TAXTO OIH4 CHAR 2 0
OIPRICIE ED pricing: external (indicator) OIH_PRICIE CHAR 1 0
X Yes
NULL No
OIFULTAX Excise duty tax value at the full rate OIH_FULTAX CURR 13 2
OITXVAL0 Excise duty tax value 0 OIH_TXVAL0 CURR 13 2
OITXVAL1 Excise duty tax value 1 OIH_TXVAL1 CURR 13 2
OITXVAL2 Excise duty tax value 2 OIH_TXVAL2 CURR 13 2
OITXVAL3 Excise duty tax value 3 OIH_TXVAL3 CURR 13 2
OITXVAL4 Excise duty tax value 4 OIH_TXVAL4 CURR 13 2
OITXVAL5 Excise duty tax value 5 OIH_TXVAL5 CURR 13 2
OITXVAL6 Excise duty tax value 6 OIH_TXVAL6 CURR 13 2
OIOILCON Oil content in a material as a percentage OIH_OILCON DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OITAXCON Excise duty tax from pricing conditions OIH_TAXCON CURR 13 2
OITAXVAL Excise duty value in material inventory account OIH_TAXVAL CURR 13 2
OIOILCON2 Oil content of a material as a percentage (2) OIH_OILCN2 DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OIUOMQT Base quantity for excise duty rate (e.g.per 1 or 100 UoM) OIH_UOMQT T006 UNIT 3 0
OITAXQT Excise duty tax quantity in STBME OIH_TAXQT QUAN 13 3
OIFUTQT Future tax quantity OIH_FUTQT QUAN 13 3
OIFUTTX Future tax value OIH_FUTTX CURR 13 2
OIFUTDT Future tax date OIH_FUTDT DATS 8 0
OIFUTQT2 Future tax quantity 2 OIH_FUTQT2 QUAN 13 3
OIFUTTX2 Future tax value 2 OIH_FUTTX2 CURR 13 2
OIFUTDT2 Future tax date 2 OIH_FUTDT2 DATS 8 0
OITAXGRP2 Excise Duty Group OIH_TAXGRP OIH2 CHAR 2 0
OIPOSTZERO Post zero amounts OIH_PSTZRO CHAR 1 0
X Yes
NULL No
OIH_LICTP License type OIH_LICTP OIH20 CHAR 4 0
OIH_LICIN Excise tax internal license number OIH_LICIN OIHL CHAR 10 0
OICERTF1 Excise tax external license number OIH_CERTF1 CHAR 15 0

ACCTIT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ACCTIT ANL01 ACCTIT MANDT ANLH Main asset number MANDT
ACCTIT ANL01 ACCTIT BUKRS ANLH Main asset number BUKRS
ACCTIT ANL01 ACCTIT ANL01 ANLH Main asset number ANLN1
ACCTIT ANL02 ACCTIT MANDT ANLA Asset Master Record Segment MANDT
ACCTIT ANL02 ACCTIT BUKRS ANLA Asset Master Record Segment BUKRS
ACCTIT ANL02 ACCTIT ANL01 ANLA Asset Master Record Segment ANLN1
ACCTIT ANL02 ACCTIT ANL02 ANLA Asset Master Record Segment ANLN2
ACCTIT HBKID ACCTIT MANDT T012 House Banks MANDT
ACCTIT HBKID ACCTIT BUKRS T012 House Banks BUKRS
ACCTIT HBKID ACCTIT HBKID T012 House Banks HBKID
ACCTIT OIHANTYP SY MANDT OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) MANDT
ACCTIT OIHANTYP ACCTIT OIHANTYP OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) HANTYP
ACCTIT OIH_LICIN ACCTIT OIH_LICIN OIHL License Master Data LICIN
ACCTIT OIH_LICIN ACCTIT OIH_LICTP OIHL License Master Data LICTP
ACCTIT OIH_LICIN SY MANDT OIHL License Master Data MANDT
ACCTIT OIH_LICTP SY MANDT OIH20 License types MANDT
ACCTIT OIH_LICTP ACCTIT OIH_LICTP OIH20 License types LICTP
ACCTIT OITAXFROM SY MANDT OIH4 Excise duty tax status (IS-Oil TDP standard/core object) MANDT
ACCTIT OITAXFROM ACCTIT OITAXFROM OIH4 Excise duty tax status (IS-Oil TDP standard/core object) TAXKEY
ACCTIT OITAXGRP SY MANDT OIH2 Excise duty tax group (IS-Oil TDP standard/core object) MANDT
ACCTIT OITAXGRP ACCTIT OITAXGRP OIH2 Excise duty tax group (IS-Oil TDP standard/core object) TAXGRP
ACCTIT OITAXGRP2 ACCTIT OITAXGRP2 OIH2 Excise duty tax group (IS-Oil TDP standard/core object) TAXGRP
ACCTIT OITAXGRP2 SY MANDT OIH2 Excise duty tax group (IS-Oil TDP standard/core object) MANDT
ACCTIT OITAXTO SY MANDT OIH4 Excise duty tax status (IS-Oil TDP standard/core object) MANDT
ACCTIT OITAXTO ACCTIT OITAXTO OIH4 Excise duty tax status (IS-Oil TDP standard/core object) TAXKEY
ACCTIT OIUOMQT ACCTIT OIUOMQT T006 Units of Measurement MSEHI
ACCTIT OIUOMQT SY MANDT T006 Units of Measurement MANDT
ACCTIT ZZREGION SYST MANDT ZREG User Defined Regions MANDT
ACCTIT ZZREGION ACCTIT ZZREGION ZREG User Defined Regions ZZREGION
ACCTIT ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
ACCTIT ZZSPREG ACCTIT ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
ACCTIT ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
ACCTIT ZZSTATE * T005S Taxes: Region (Province) Key LAND1
ACCTIT ZZSTATE ACCTIT ZZSTATE T005S Taxes: Region (Province) Key BLAND
ACCTIT ZZUSERFLD1 ACCTIT ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1
ACCTIT ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT