SAP table ACCIT (Accounting Interface: Item Information)
SAP table ACCIT has 5 primary key fields being MANDT,AWTYP,AWREF,AWORG,POSNR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
MANDT
Client
CLNT
3
0
*
MANDT
AWTYP
Reference procedure
CHAR
5
0
*
AWTYP
AWREF
Reference document number
CHAR
10
0
AWREF
AWORG
Reference Organizational Units
CHAR
10
0
AWORG
POSNR
Accounting Document Line Item Number
NUMC
10
0
POSNR_ACC
LOGVO
Logical Transaction
CHAR
6
0
LOGVO
ISTAT
Item History
CHAR
1
0
ISTAT_ACC
KSTAT
Indicator for Statistical Line Items
CHAR
1
0
KSTAZ
Not statistical
A
FI document header without real line item
T
Lines in a Technical Ledger
U
Non-valuated goods receipt
X
Statistical condition
Z
Non-statistical zero lines from Asset Accounting FI-AA
AWREF_REV
Reversal: Reference Document No. of Document to Be Reversed
CHAR
10
0
AWREF_REV
AWORG_REV
Reversal: Reference Organizations of Document to Be Reversed
CHAR
10
0
AWORG_REV
AWITEM_REV
Reversal: Reference Doc. Line Itm of Document to Be Reversed
NUMC
6
0
AWITEM_REV
AWREF_REB
Invoice reference: Document number for invoice reference
CHAR
10
0
AWREF_REB
AWORG_REB
Invoice reference: Reference organization for inv. reference
CHAR
10
0
AWORG_REB
BUKRS
Company Code
CHAR
4
0
BUKRS
BELNR
Document Number of an Accounting Document
CHAR
10
0
BELNR_D
GJAHR
Fiscal Year
NUMC
4
0
GJAHR
BUZEI
Number of Line Item Within Accounting Document
NUMC
3
0
BUZEI
OBZEI
Number of Line Item in Original Document
NUMC
3
0
OBZEI
DOCLN
Six-Character Posting Item for Ledger
CHAR
6
0
DOCLN6
BLDAT
Document Date in Document
DATS
8
0
BLDAT
BUDAT
Posting Date in the Document
DATS
8
0
BUDAT
WWERT
Translation date
DATS
8
0
WWERT_D
VALUT
Value date
DATS
8
0
VALUT
MONAT
Fiscal period
NUMC
2
0
MONAT
BLART
Document Type
CHAR
2
0
BLART
XBLNR
Reference Document Number
CHAR
16
0
XBLNR1
XREF1
Business Partner Reference Key
CHAR
12
0
XREF1
XREF2
Business Partner Reference Key
CHAR
12
0
XREF2
XREF3
Reference key for line item
CHAR
20
0
XREF3
XREF1_HD
Reference Key 1 Internal for Document Header
CHAR
20
0
XREF1_HD
XREF2_HD
Reference Key 2 Internal for Document Header
CHAR
20
0
XREF2_HD
VORGN
Transaction Type for General Ledger
CHAR
4
0
VORGN
PRVRG
Business Transaction for Validations
CHAR
4
0
PRVRG
PRVRG_SV
Business transaction for status management
CHAR
4
0
PRVRG_SV
STBUK
Tax Company Code
CHAR
4
0
STBUK
XSNET
G/L Account Amounts Entered Exclude Tax
CHAR
1
0
XSNET
XMWST
Calculate Tax Automatically
CHAR
1
0
XMWST
TAX_COUNTRY
Tax Reporting Country/Region
CHAR
3
0
FOT_TAX_COUNTRY
MWSKZ
Tax on sales/purchases code
CHAR
2
0
MWSKZ
KTOSL
Transaction Key
CHAR
3
0
KTOSL
KNUMH
Number of the Condition Record
CHAR
10
0
KNUMH
TXJCD
Tax Jurisdiction
CHAR
15
0
TXJCD
TXDAT
Date for Determining Tax Rates
DATS
8
0
TXDAT
TXDAT_FROM
Valid-From Date of the Tax Rate
DATS
8
0
FOT_TXDAT_FROM
TXDAT_FROM1
Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack)
DATS
8
0
FOT_TXDAT_FROMX
TXDAT_FROM2
Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack)
DATS
8
0
FOT_TXDAT_FROMX
TXDAT_FROM3
Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack)
DATS
8
0
FOT_TXDAT_FROMX
KBETR
Condition Amount or Percentage
CURR
11
2
KBETR
TXJDP
Tax Jurisdiction Code - Jurisdiction for Lowest Level Tax
CHAR
15
0
TXJCD_DEEP
TXJLV
Tax jurisdiction code level
CHAR
1
0
TXJCD_LEVEL
TAXPS
Tax document item number
NUMC
6
0
TAX_POSNR
TXGRP
Group Indicator for Tax Line Items
NUMC
3
0
TXGRP
HIST_TAX_FACTOR
Historical Factor for calculating Tax Amount
D34R
34
0
FOT_HIST_FACTOR_FOR_TAX_AMOUNT
T2CCODE_CRCY_CONV_FACTOR
Factor for calculating Amount in company code currency
DEC
31
14
FINS_T2CCODE_CRCY_CONV_FACTOR
T2CNTRY_CRCY_CONV_FACTOR
Factor for calculating Tax Amount in reporting currency
DEC
31
14
FINS_T2CNTRY_CRCY_CONV_FACTOR
OLD_DOC_NUMBER
Temporary document number when calculating taxes
CHAR
10
0
OLD_DOC_NUMBER
BUPLA
Business Place
CHAR
4
0
BUPLA
SECCO
Section Code
CHAR
4
0
SECCO
XSKRL
Indicator: Line Item Not Liable to Cash Discount?
CHAR
1
0
XSKRL
ZUMSK
Target Special G/L Indicator
CHAR
1
0
DZUMSK
UMSKZ
Special G/L Indicator
CHAR
1
0
UMSKZ
BSTAT
Document Status
CHAR
1
0
BSTAT_D
BSCHL
Posting Key
CHAR
2
0
BSCHL
SHKZG
Debit/Credit Indicator
CHAR
1
0
SHKZG
H
Credit
S
Debit
PSWSL
Update Currency for General Ledger Transaction Figures
CUKY
5
0
PSWSL
PSWBT
Amount for Updating in General Ledger
CURR
23
2
PSWBT_RW
PYCUR
Currency for Automatic Payment
CUKY
5
0
PYCUR
PYAMT
Amount in Payment Currency
CURR
23
2
PYAMT_RW
KOART
Account type
CHAR
1
0
KOART
A
Assets
D
Customers
K
Vendors
M
Material
S
G/L accounts
KUNNR
Customer Number
CHAR
10
0
KUNNR
LIFNR
Account Number of Supplier
CHAR
10
0
LIFNR
SAKNR
G/L Account Number
CHAR
10
0
SAKNR
HKONT
General Ledger Account
CHAR
10
0
HKONT
ALTKT
Account Number in Group
CHAR
10
0
ALTKT
FILKD
Account Number of the Branch
CHAR
10
0
FILKD
XFILKD
Indicator: Break Off Branch/Head Office Relationship
CHAR
1
0
XFILKD
LOKKT
Account Number in the Local Chart of Accounts
CHAR
10
0
LOKKT
GVTYP
P&L statement account type
CHAR
2
0
GVTYP
GKOAR
Offsetting Account Type
CHAR
1
0
GKOAR
GKONT
Offsetting Account Number
CHAR
10
0
GKONT
CACCT
G/L offsetting acct number
CHAR
10
0
CACCT
LINETYPE
Item Category
CHAR
5
0
LINETYPE
XSPLITMOD
Item Changed by Document Splitting
CHAR
1
0
XSPLITMOD
ZTERM
Terms of payment key
CHAR
4
0
DZTERM
ZFBDT
Baseline Date for Due Date Calculation
DATS
8
0
DZFBDT
ZBD1T
Cash discount days 1
DEC
3
0
DZBD1T
ZBD2T
Cash discount days 2
DEC
3
0
DZBD2T
ZBD3T
Net Payment Terms Period
DEC
3
0
DZBD3T
ZBD1P
Cash discount percentage 1
DEC
5
3
DZBD1P
ZBD2P
Cash Discount Percentage 2
DEC
5
3
DZBD2P
ZBFIX
Fixed Payment Terms
CHAR
1
0
DZBFIX
UZAWE
Payment method supplement
CHAR
2
0
UZAWE
ZLSCH
Payment Method
CHAR
1
0
DZLSCH
EMPFB
Payee/Payer
CHAR
10
0
EMPFB
RSTGR
Reason Code for Payments
CHAR
3
0
RSTGR
REBZG
Document No. of the Invoice to Which the Transaction Belongs
CHAR
10
0
REBZG
REBZJ
Fiscal Year of the Relevant Invoice (for Credit Memo)
NUMC
4
0
REBZJ
REBZZ
Line Item in the Relevant Invoice
NUMC
3
0
REBZZ
REBZT
Follow-On Document Type
CHAR
1
0
REBZT
REBZG_CHECK
Check Indicator for REBZG Checks in ACC Interface
CHAR
1
0
REBZG_CHECK
Standard Treatment
N
No Check/Transfer
MABER
Dunning Area
CHAR
2
0
MABER
MSCHL
Dunning Key
CHAR
1
0
MSCHL
MADAT
Date of Last Dunning Notice
DATS
8
0
MADAT
MANST
Dunning Level
NUMC
1
0
MAHNS_D
MANSP
Dunning Block
CHAR
1
0
MANSP
ZLSPR
Payment Block Key
CHAR
1
0
DZLSPR
ADRNR
Address
CHAR
10
0
ADRNR
STCEG
VAT Registration Number
CHAR
20
0
STCEG
EGLLD
Supplying Country/Region for Delivery of Goods
CHAR
3
0
EGLLD
EGBLD
Country/Region of Destination for Delivery of Goods
CHAR
3
0
EGBLD
EGMLD
Reporting Country/Region for Delivery of Goods Within the EU
CHAR
3
0
EGMLD_BSEZ
XEGDR
Indicator: Triangular Deal Within the EU
CHAR
1
0
XEGDR
LZBKZ
State Central Bank Indicator
CHAR
3
0
LZBKZ
LANDL
Supplying Country/Region
CHAR
3
0
LANDL
LAND1_ACNT
Customer/Vendor Country/Region
CHAR
3
0
LAND1_ACNT
DIEKZ
Service Indicator (Foreign Payment)
CHAR
1
0
DIEKZ
SAMNR
Invoice List Number
NUMC
8
0
SAMNR
ABPER
Settlement Period
ACCP
6
0
ABPER_RF
ZUONR
Assignment number
CHAR
18
0
DZUONR
DTWS1
Instruction Key 1
NUMC
2
0
DTAT16
DTWS2
Instruction Key 2
NUMC
2
0
DTAT17
DTWS3
Instruction key 3
NUMC
2
0
DTAT18
DTWS4
Instruction key 4
NUMC
2
0
DTAT19
SGTXT
Item Text
CHAR
50
0
SGTXT
GSBER
Business Area
CHAR
4
0
GSBER
KOSTL
Cost Center
CHAR
10
0
KOSTL
LSTAR
Activity Type
CHAR
6
0
LSTAR
KOKRS
Controlling Area
CHAR
4
0
KOKRS
PERNR
Personnel Number
NUMC
8
0
PERNR_D
BPMNG
Quantity in Purchase Order Price Unit
QUAN
13
3
BPMNG
BPRME
Order Price Unit (Purchasing)
UNIT
3
0
BPRME
AUFNR
Order Number
CHAR
12
0
AUFNR
ANLN1
Main Asset Number
CHAR
12
0
ANLN1
ANLN2
Asset Subnumber
CHAR
4
0
ANLN2
BZDAT
Asset Value Date
DATS
8
0
BZDAT
ANBWA
Asset Transaction Type
CHAR
3
0
ANBWA
WEBUD
Goods Receipt Posting Date
DATS
8
0
WEBUD
RMVCT
Transaction type
CHAR
3
0
RMVCT
ABUKR
Company Code Which Will Be Cleared Against
CHAR
4
0
ABUKR
ANLGR
Group Asset
CHAR
12
0
ANLGR
ANLGR2
Subnumber of Group Asset
CHAR
4
0
ANLGR2
MATNR
Material Number
CHAR
40
0
MATNR
SQUAN
Quantity +/- Sign
CHAR
1
0
SIGN_QUANTITY
Not Defined/Not Yet Set
+
Plus Sign
-
Minus Sign
0
Not Relevant for Quantity Updates
MENGE
Quantity
QUAN
13
3
MENGE_D
MEINS
Base Unit of Measure
UNIT
3
0
MEINS
WERKS
Plant
CHAR
4
0
WERKS_D
BWART
Movement type (inventory management)
CHAR
3
0
BWART
PARGB
Trading partner's business area
CHAR
4
0
PARGB
GSBER_GP
Business area reported to the partner
CHAR
4
0
GSBER_GP
BUZID
Identification of the Line Item
CHAR
1
0
BUZID
HOART
Type of origin object (EC-PCA)
NUMC
2
0
HOART
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
46
Real Estate General Contract
47
Service Order
48
Service Contract
88
Profit Center Costing
98
Reconciliation of Differences
99
Legacy Data from a 2.x Release
HRKFT
Origin Group as Subdivision of Cost Element
CHAR
4
0
HRKFT
HKMAT
Material-related origin
CHAR
1
0
HKMAT
No material-related origin
X
Keep costs/quantities under material number
IMKEY
Internal Key for Real Estate Object
CHAR
8
0
IMKEY
KSTRG
Cost Object
CHAR
12
0
KSTRG
PAOBJNR
Profitability Segment Number (CO-PA)
NUMC
10
0
RKEOBJNR
PRZNR
Business Process
CHAR
12
0
CO_PRZNR
PRCTR
Profit Center
CHAR
10
0
PRCTR
PPRCTR
Partner Profit Center
CHAR
10
0
PPRCTR
PS_PSP_PNR
Work Breakdown Structure Element (WBS Element)
NUMC
8
0
PS_PSP_PNR
MAT_PSPNR
Valuated Sales Order Stock WBS Element
NUMC
8
0
MAT_PSPNR
NPLNR
Network Number for Account Assignment
CHAR
12
0
NPLNR
AUFPL
Routing number of operations in the order
NUMC
10
0
CO_AUFPL
APLZL
Internal counter
NUMC
8
0
CIM_COUNT
AUFPS
Order item number
NUMC
4
0
CO_POSNR
WORK_ITEM_ID
Work Item ID
CHAR
10
0
/CPD/PFP_WORKITEM_ID
FIKRS
Financial Management Area
CHAR
4
0
FIKRS
FIPOS
Commitment Item
CHAR
14
0
FIPOS
FISTL
Funds Center
CHAR
16
0
FISTL
GEBER
Fund
CHAR
10
0
BP_GEBER
KBLNR
Document Number for Earmarked Funds
CHAR
10
0
KBLNR
KBLPOS
Earmarked Funds: Document Item
NUMC
3
0
KBLPOS
KBLTYP_EXT
Earmarked Funds: Reference Object Type
CHAR
5
0
KBL_AWTYP
KBLREF_EXT
Earmarked Funds: Reference Document Number
CHAR
10
0
KBL_AWREF
KBLORG_EXT
Earmarked Funds: Reference Organization Units
CHAR
10
0
KBL_AWORG
KBLPOS_EXT
Earmarked Funds: Reference Line Item
CHAR
10
0
KBL_AWPOS
ERLKZ
Completion Indicator for Line Item
CHAR
1
0
KBLERLKZ
LOTKZ
Lot Number for Documents
CHAR
10
0
LOTKZ
STTAX
Tax Amount as Statistical Information in Document Currency
CURR
13
2
STTAX
STHTX
Tax Amount as Statistical Information in Co. Code Currency
CURR
23
2
STHTX_RW
VBELN
Sales and Distribution Document Number
CHAR
10
0
VBELN
KDAUF
Sales Order Number
CHAR
10
0
KDAUF
KDPOS
Item number in Sales Order
NUMC
6
0
KDPOS
SERVICE_DOC_TYPE
Service Document Type
CHAR
4
0
FCO_SRVDOC_TYPE
SERVICE_DOC_ID
Service Document ID
CHAR
10
0
FCO_SRVDOC_ID
SERVICE_DOC_ITEM_ID
Service Document Item ID
NUMC
6
0
FCO_SRVDOC_ITEM_ID
VTKEY
Identification of a Provider Contract
CHAR
20
0
VTKEY_KK
VTPOS
Contract: Item Number
NUMC
6
0
VTPOS_KK
RA_CONTRACT_ID
Revenue Accounting Contract ID
CHAR
14
0
FARR_CONTRACT_ID
RA_POB_ID
Performance Obligation ID
CHAR
16
0
FARR_POB_ID
MAT_KDAUF
Sales order number of valuated sales order stock
CHAR
10
0
MAT_KDAUF
MAT_KDPOS
Sales Order Item of Valuated Sales Order Stock
NUMC
6
0
MAT_KDPOS
KZVBR
Consumption posting
CHAR
1
0
KZVBR
No consumption
A
Asset
E
Sales order
P
Project
V
Consumption
KZBWS
Valuation of Special Stock
CHAR
1
0
KZBWS
No stock valuation
A
Valuation without reference to sales document
M
Separate valuation with ref. to sales document/project
SOBKZ
Special Stock Indicator
CHAR
1
0
SOBKZ
ZINKZ
Exempted from Interest Calculation
CHAR
2
0
DZINKZ
VBUND
Company ID of Trading Partner
CHAR
6
0
RASSC
BWKEY
Valuation area
CHAR
4
0
BWKEY
BWTAR
Valuation Type
CHAR
10
0
BWTAR_D
VNAME
Joint venture
CHAR
6
0
JV_NAME
EGRUP
Equity group
CHAR
3
0
JV_EGROUP
BTYPE
Billing Indicator
CHAR
2
0
JV_BILIND
EBELN_LOGSYS
Logical System of Purchasing Document
CHAR
10
0
EBELN_LOGSYS
EBELN
Purchasing Document Number
CHAR
10
0
EBELN
EBELP
Item Number of Purchasing Document
NUMC
5
0
EBELP
ZEKKN
Sequential Number of Account Assignment
NUMC
2
0
DZEKKN
VPRSV
Price control indicator
CHAR
1
0
VPRSV
S
Standard price
V
Moving average price/periodic unit price
RECID
Recovery Indicator
CHAR
2
0
JV_RECIND
RECID_MAN
Indicator: Recovery Indicator Set Manually.
CHAR
1
0
JV_RECID_M
ETYPE
Equity type
CHAR
3
0
JV_ETYPE
VPTNR
Partner account number
CHAR
10
0
JV_PART
XBILK
Indicator: Account is a balance sheet account?
CHAR
1
0
XBILK
XUMSW
Indicator: Sales-Related Item ?
CHAR
1
0
XUMSW
TAXIT
Indicator: Tax Item
CHAR
1
0
TAXIT
XAUTO
Indicator: Line item automatically created
CHAR
1
0
XAUTO
FCVAL
Indicator: Line Item Contains Foreign Currency Valuation
CHAR
1
0
FCVAL
BEKNZ
Debit/credit indicator
CHAR
1
0
BEKNZ
A
Special: Sender credit from settlement
H
Credit posting or sender credit posting
L
Special: Sender credit from delivery to inventory
S
Debit posting or receiver debit posting
KZBEW
Movement Indicator
CHAR
1
0
KZBEW
Goods movement w/o reference
B
Goods movement for purchase order
F
Goods movement for production order
K
Goods movement for kanban requirement (WM - internal only)
L
Goods movement for delivery note
O
Subsequent adjustment of "material-provided" consumption
W
Subsequent adjustment of proportion/product unit material
PSTYP
Item category in purchasing document
CHAR
1
0
PSTYP
BUSTW
Posting String for Values
CHAR
4
0
BUSTW
TBTKZ
Indicator: Subsequent Debit/Credit
CHAR
1
0
TBTKZ
XUMBW
Revaluation
CHAR
1
0
XUMBW
SCOPE
Object Class
CHAR
2
0
SCOPE_CV
IV
Investment
OC
Overhead costs
PA
Profit analysis
PR
Production
AUTYP
Order category
NUMC
2
0
AUFTYP
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
99
Master Planned order
XMFRW
Indicator: Update Quantity in Accounting
CHAR
1
0
XMFRW
ESRNR
ISR subscriber number
CHAR
11
0
ESRNR
ESRPZ
POR check digit
CHAR
2
0
ESRPZ
ESRRE
ISR/QR Reference Number
CHAR
27
0
ESRRE
QSSKZ
Withholding Tax Code
CHAR
2
0
QSSKZ
BKLAS
Valuation Class
CHAR
4
0
BKLAS
BWMOD
Valuation Grouping Code
CHAR
4
0
BWMOD
MTART
Material type
CHAR
4
0
MTART
EPRCTR
Partner profit center for elimination of internal business
CHAR
10
0
EPRCTR
POSNR_SD
Item number of the SD document
NUMC
6
0
POSNR
KSCHL
Condition Type
CHAR
4
0
KSCHA
STUNR
Step Number
NUMC
3
0
STUNR
ZAEHK
Condition Counter
NUMC
3
0
DZAEHK
FKART
Billing Type
CHAR
4
0
FKART
VTWEG
Distribution Channel
CHAR
2
0
VTWEG
KUNAG
Sold-to Party
CHAR
10
0
KUNAG
SPART
Division
CHAR
2
0
SPART
VKORG
Sales Organization
CHAR
4
0
VKORG
VKBUR
Sales office
CHAR
4
0
VKBUR
VKGRP
Sales group
CHAR
3
0
VKGRP
FKDAT
Billing Date
DATS
8
0
FKDAT
FKTYP
Billing Category
CHAR
1
0
FKTYP
A
Order-related billing document
B
Order-related billing document for rebate settlement
C
Order-related billing document for partial rebate settlement
D
Periodic billing document
E
Periodic billing with active invoice accrual
F
Accrual
I
Delivery-related billing document for inter-company billing
K
Order-related billing document for rebate correction