Follow us on LinkedIn for your next SAP project
← Back to Search

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 Possible values
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
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
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
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
HRKFT
Origin Group as Subdivision of Cost Element
 HRKFT
CHAR
 4 0
HKMAT
Material-related origin
 HKMAT
CHAR
 1 0
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
KZBWS
Valuation of Special Stock
 KZBWS
CHAR
 1 0
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
XUMSW
Indicator: Sales-related item ?
 XUMSW
CHAR
 1 0
KZBEW
Movement Indicator
 KZBEW
CHAR
 1 0
TBTKZ
Indicator: subsequent debit/credit
 TBTKZ
CHAR
 1 0
XUMBW
Revaluation
 XUMBW
CHAR
 1 0
SCOPE
Object Class
 SCOPE_CV
CHAR
 2 0
AUTYP
Order category
 AUFTYP
NUMC
 2 0
XMFRW
Indicator: Update quantity in RW
 XMFRW
CHAR
 1 0
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
XPKON
Check account assignment
 XPKON
CHAR
 1 0
KOAID
Condition class
 KOAID
CHAR
 1 0
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
CO_KAAUF
Account assignment type: Order
 CO_KAAUF
NUMC
 1 0
CO_KAPRO
Project account assignment type
 CO_KAPRO
NUMC
 1 0
CO_KAKTR
Account Assignment Type: Cost Object
 CO_KAKTR
NUMC
 1 0
CO_KANPL
Account Assignment Type: Network
 CO_KANPL
NUMC
 1 0
CO_KAIMO
Account Assignment Type: Real Estate Object
 CO_KAIMO
NUMC
 1 0
CO_KAKDA
Account Assignment Type: Sales Order
 CO_KAKDA
NUMC
 1 0
CO_KAERG
Business segment account assignment type
 CO_KAERG
NUMC
 1 0
CO_KAABS
Account assignment type: reconciliation object
 CO_KAABS
NUMC
 1 0
CO_KAPRZ
Account Assignment Type: Business Process
 CO_KAPRZ
NUMC
 1 0
CO_KASAT
Account Assignment Type Not Used
 CO_KASAT
NUMC
 1 0
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
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
TPKNZ
Transfer Price Indicator
 TPKNZ
NUMC
 1 0
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
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
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
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
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
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
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
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 ANL01 ANLH
Main asset number
 ANLN1
ACCTIT ANL01 ACCTIT MANDT ANLH
Main asset number
 MANDT
ACCTIT ANL01 ACCTIT BUKRS ANLH
Main asset number
 BUKRS
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 SY MANDT OIHL
License Master Data
 MANDT
ACCTIT OIH_LICIN ACCTIT OIH_LICIN OIHL
License Master Data
 LICIN
ACCTIT OIH_LICIN ACCTIT OIH_LICTP OIHL
License Master Data
 LICTP
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 SY MANDT OIH2
Excise duty tax group (IS-Oil TDP standard/core object)
 MANDT
ACCTIT OITAXGRP2 ACCTIT OITAXGRP2 OIH2
Excise duty tax group (IS-Oil TDP standard/core object)
 TAXGRP
ACCTIT OITAXTO ACCTIT OITAXTO OIH4
Excise duty tax status (IS-Oil TDP standard/core object)
 TAXKEY
ACCTIT OITAXTO SY MANDT OIH4
Excise duty tax status (IS-Oil TDP standard/core object)
 MANDT
ACCTIT OIUOMQT SY MANDT T006
Units of Measurement
 MANDT
ACCTIT OIUOMQT ACCTIT OIUOMQT T006
Units of Measurement
 MSEHI
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 SYST MANDT ZFU1
Check Table for User Field 1
 MANDT
ACCTIT ZZUSERFLD1 ACCTIT ZZUSERFLD1 ZFU1
Check Table for User Field 1
 ZZUSERFLD1