SAP ACCTIT Compressed Data from FI/CO Document Table

Overview

ACCTIT is a standard SAP S/4HANA table that stores Compressed Data from FI/CO Document data. There are total 184 fields in the ACCTIT table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ACCTIT belongs to Financial Accounting (FI) module and is located in the package Financial Accounting "Basis" (FBAS).

In addition, following links provide an overview of foreign key relationships, if any, that link ACCTIT to other SAP tables and standard CDS views available based on ACCTIT table in S/4HANA 2020.

Techincal Settings of ACCTIT

Below are technical details of the table ACCTIT

Buffering not allowed
No buffering
Storage type is Column Store

List of ACCTIT Fields

The following table gives you an overview of the fields available in ACCTIT

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT	*	CLNT	3
AWTYP	Reference procedure	AWTYP	*	CHAR	5
AWREF	Reference document number	AWREF		CHAR	10
AWORG	Reference Organizational Units	AWORG		CHAR	10
POSNR	Accounting Document Line Item Number	POSNR_ACC		NUMC	10
KSTAT	Indicator for Statistical Line Items	KSTAZ		CHAR	1
AWREF_REV	Reversal: Reference Document No. of Document to Be Reversed	AWREF_REV		CHAR	10
AWORG_REV	Reversal: Reference Organizations of Document to Be Reversed	AWORG_REV		CHAR	10
BUKRS	Company Code	BUKRS		CHAR	4
BELNR	Accounting Document Number	BELNR_D		CHAR	10
GJAHR	Fiscal Year	GJAHR		NUMC	4
BLDAT	Document Date in Document	BLDAT		DATS	8
BUDAT	Posting Date in the Document	BUDAT		DATS	8
WWERT	Translation date	WWERT_D		DATS	8
VALUT	Value date	VALUT		DATS	8
MONAT	Fiscal period	MONAT		NUMC	2
BLART	Document Type	BLART		CHAR	2
XBLNR	Reference Document Number	XBLNR1		CHAR	16
VORGN	Transaction Type for General Ledger	VORGN		CHAR	4
PRVRG	Business Transaction for Validations	PRVRG		CHAR	4
PRVRG_SV	Business transaction for status management	PRVRG_SV		CHAR	4
KTOSL	Transaction Key	KTOSL		CHAR	3
UMSKZ	Special G/L Indicator	UMSKZ		CHAR	1
BSCHL	Posting Key	BSCHL		CHAR	2
SHKZG	Debit/Credit Indicator	SHKZG		CHAR	1
PSWSL	Update Currency for General Ledger Transaction Figures	PSWSL		CUKY	5
PSWBT	Amount for Updating in General Ledger	PSWBT		CURR	23
KOART	Account type	KOART		CHAR	1
KUNNR	Customer Number	KUNNR		CHAR	10
LIFNR	Account Number of Vendor or Creditor	LIFNR		CHAR	10
SAKNR	G/L Account Number	SAKNR		CHAR	10
HKONT	General Ledger Account	HKONT		CHAR	10
ALTKT	Account Number in Group	ALTKT		CHAR	10
GVTYP	P&L statement account type	GVTYP		CHAR	2
SGTXT	Item Text	SGTXT		CHAR	50
GSBER	Business Area	GSBER		CHAR	4
KOSTL	Cost Center	KOSTL		CHAR	10
KOKRS	Controlling Area	KOKRS		CHAR	4
PERNR	Personnel Number	PERNR_D		NUMC	8
BPMNG	Quantity in Purchase Order Price Unit	BPMNG		QUAN	13
BPRME	Order Price Unit (Purchasing)	BPRME		UNIT	3
AUFNR	Order Number	AUFNR		CHAR	12
ANLN1	Main Asset Number	ANLN1		CHAR	12
ANLN2	Asset Subnumber	ANLN2		CHAR	4
ANBWA	Asset Transaction Type	ANBWA		CHAR	3
RMVCT	Transaction type	RMVCT		CHAR	3
ABUKR	Company Code Which Will Be Cleared Against	ABUKR		CHAR	4
AIBN1	Original Asset That Was Transferred	AIBN1		CHAR	12
AIBN2	Original Asset That Was Transferred	AIBN2		CHAR	4
MATNR	Material Number	MATNR		CHAR	40
MENGE	Quantity	MENGE_D		QUAN	13
MEINS	Base Unit of Measure	MEINS		UNIT	3
WERKS	Plant	WERKS_D		CHAR	4
BWART	Movement type (inventory management)	BWART		CHAR	3
PARGB	Trading partner's business area	PARGB		CHAR	4
GSBER_GP	Business area reported to the partner	GSBER_GP		CHAR	4
BUZID	Identification of the Line Item	BUZID		CHAR	1
HOART	Type of origin object (EC-PCA)	HOART		NUMC	2
HRKFT	Origin Group as Subdivision of Cost Element	HRKFT		CHAR	4
HKMAT	Material-related origin	HKMAT		CHAR	1
IMKEY	Internal Key for Real Estate Object	IMKEY		CHAR	8
KSTRG	Cost Object	KSTRG		CHAR	12
PAOBJNR	Profitability Segment Number (CO-PA)	RKEOBJNR		NUMC	10
PRCTR	Profit Center	PRCTR		CHAR	10
PPRCTR	Partner Profit Center	PPRCTR		CHAR	10
PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	PS_PSP_PNR		NUMC	8
NPLNR	Network Number for Account Assignment	NPLNR		CHAR	12
AUFPL	Routing number of operations in the order	CO_AUFPL		NUMC	10
VBELN	Sales and Distribution Document Number	VBELN		CHAR	10
KDAUF	Sales Order Number	KDAUF		CHAR	10
KDPOS	Item number in Sales Order	KDPOS		NUMC	6
KZVBR	Consumption posting	KZVBR		CHAR	1
KZBWS	Valuation of Special Stock	KZBWS		CHAR	1
SOBKZ	Special Stock Indicator	SOBKZ		CHAR	1
VBUND	Company ID of Trading Partner	RASSC		CHAR	6
BWKEY	Valuation area	BWKEY		CHAR	4
BWTAR	Valuation Type	BWTAR_D		CHAR	10
VNAME	Joint venture	JV_NAME		CHAR	6
EGRUP	Equity group	JV_EGROUP		CHAR	3
BTYPE	Payroll Type	JV_BILIND		CHAR	2
EBELN	Purchasing Document Number	EBELN		CHAR	10
EBELP	Item Number of Purchasing Document	EBELP		NUMC	5
ZEKKN	Sequential Number of Account Assignment	DZEKKN		NUMC	2
RECID	Recovery Indicator	JV_RECIND		CHAR	2
VPTNR	Partner account number	JV_PART		CHAR	10
XBILK	Indicator: Account is a balance sheet account?	XBILK		CHAR	1
XUMSW	Indicator: Sales-Related Item ?	XUMSW		CHAR	1
KZBEW	Movement Indicator	KZBEW		CHAR	1
TBTKZ	Indicator: Subsequent Debit/Credit	TBTKZ		CHAR	1
XUMBW	Revaluation	XUMBW		CHAR	1
SCOPE	Object Class	SCOPE_CV		CHAR	2
AUTYP	Order category	AUFTYP		NUMC	2
XMFRW	Indicator: Update Quantity in Accounting	XMFRW		CHAR	1
BKLAS	Valuation Class	BKLAS		CHAR	4
BWMOD	Valuation Grouping Code	BWMOD		CHAR	4
MTART	Material type	MTART		CHAR	4
KZUML	Stock transfer/transfer posting	KZUML		CHAR	1
XPKON	Check account assignment	XPKON		CHAR	1
KOAID	Condition Class	KOAID		CHAR	1
EPRCTR	Partner profit center for elimination of internal business	EPRCTR		CHAR	10
FIKRS	Financial Management Area	FIKRS		CHAR	4
FIPOS	Commitment Item	FIPOS		CHAR	14
FISTL	Funds Center	FISTL		CHAR	16
GEBER	Fund	BP_GEBER		CHAR	10
KBLNR	Document Number for Earmarked Funds	KBLNR		CHAR	10
KBLPOS	Earmarked Funds: Document Item	KBLPOS		NUMC	3
LOTKZ	Lot Number for Documents	LOTKZ		CHAR	10
STTAX	Tax Amount as Statistical Information in Document Currency	STTAX		CURR	13
BEMOT	Accounting Indicator	BEMOT		CHAR	2
CO_KAKST	Account Assignment Type: Cost Center	CO_KAKST		NUMC	1
CO_KAAUF	Account Assignment Type: Order	CO_KAAUF		NUMC	1
CO_KAPRO	Project Account Assignment Type	CO_KAPRO		NUMC	1
CO_KAKTR	Account Assignment Type: Cost Object	CO_KAKTR		NUMC	1
CO_KANPL	Account Assignment Type: Network	CO_KANPL		NUMC	1
CO_KAIMO	Account Assignment Type: Real Estate Object	CO_KAIMO		NUMC	1
CO_KAKDA	Account Assignment Type: Sales Order	CO_KAKDA		NUMC	1
CO_KAERG	Business Segment Account Assignment Type	CO_KAERG		NUMC	1
CO_KAABS	Account Assignment Type: Reconciliation Object	CO_KAABS		NUMC	1
CO_KAPRZ	Account Assignment Type: Business Process	CO_KAPRZ		NUMC	1
CO_KASVD	Account Assignment Type: Service Document	CO_KASVD		NUMC	1
CO_KASAT	Account Assignment Type Not Used	CO_KASAT		NUMC	1
ZTEST98765	ABCDEFG - Change	ZTEST98765		CHAR	80
ZDIRECT	Test 456	ZTEST456		CHAR	2
BUSTW	Posting String for Values	BUSTW		CHAR	4
ZEILE	Item in Material or Invoice Verification Document	CK_ZEILE		NUMC	6
URZEILE	Original Item in Material or Invoice Document	CK_URZEILE		NUMC	6
PSTYP	Item category in purchasing document	PSTYP		CHAR	1
FKBER	Functional Area	FKBER		CHAR	16
ERFMG	Quantity in unit of entry	ERFMG		QUAN	13
ERFME	Unit of entry	ERFME		UNIT	3
DABRZ	Reference date for settlement	DABRBEZ		DATS	8
APLZL	Internal counter	CIM_COUNT		NUMC	8
BUPLA	Business Place	BUPLA		CHAR	4
SECCO	Section Code	SECCO		CHAR	4
LOKKT	Account Number in the Local Chart of Accounts	LOKKT		CHAR	10
LSTAR	Activity Type	LSTAR		CHAR	6
PRZNR	Business Process	CO_PRZNR		CHAR	12
XNEGP	Indicator: Negative Posting	XNEGP		CHAR	1
MAT_KDAUF	Sales order number of valuated sales order stock	MAT_KDAUF		CHAR	10
MAT_KDPOS	Sales Order Item of Valuated Sales Order Stock	MAT_KDPOS		NUMC	6
MAT_PSPNR	Valuated Sales Order Stock WBS Element	MAT_PSPNR		NUMC	8
LOGVO	Logical Transaction	LOGVO		CHAR	6
XBGBB	Posting for offsetting entry	XBGBB		CHAR	1
TPKNZ	Transfer Price Indicator	TPKNZ		NUMC	1
GRANT_NBR	Grant	GM_GRANT_NBR		CHAR	20
AUFPS	Order item number	CO_POSNR		NUMC	4
SEGMENT	Segment for Segmental Reporting	FB_SEGMENT		CHAR	10
PSEGMENT	Partner Segment for Segmental Reporting	FB_PSEGMENT		CHAR	10
BUDGET_PD	Budget Period	FM_BUDGET_PERIOD		CHAR	10
AUBEL	Sales Document	VBELN_VA		CHAR	10
AUPOS	Sales Document Item	POSNR_VA		NUMC	6
BUZEI	Number of Line Item Within Accounting Document	BUZEI		NUMC	3
MEASURE	Funded Program	FM_MEASURE		CHAR	24
MWSKZ	Tax on sales/purchases code	MWSKZ		CHAR	2
POSN2	Sales Document Item	POSNR_VA		NUMC	6
POSNR_SD	Item number of the SD document	POSNR		NUMC	6
PSOBT	Posting Day	PSOBT		DATS	8
PSOZL	Checkbox	XFELD		CHAR	1
REBZG	Document No. of the Invoice to Which the Transaction Belongs	REBZG		CHAR	10
REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	REBZJ		NUMC	4
REBZT	Follow-On Document Type	REBZT		CHAR	1
REBZZ	Line Item in the Relevant Invoice	REBZZ		NUMC	3
SHKZG_VA	Returns Item	SHKZG_VA		CHAR	1
STHTX	Tax Amount as Statistical Information in Co. Code Currency	STHTX		CURR	23
TAXIT	Indicator: Tax Item	TAXIT		CHAR	1
TXJCD	Tax Jurisdiction	TXJCD		CHAR	15
VBEL2	Sales Document	VBELN_VA		CHAR	10
XAUTO	Indicator: Line item automatically created	XAUTO		CHAR	1
XREF2	Business Partner Reference Key	XREF2		CHAR	12
XREF3	Reference key for line item	XREF3		CHAR	20
ZBD1P	Cash discount percentage 1	DZBD1P		DEC	5
ZBD1T	Cash discount days 1	DZBD1T		DEC	3
ZBD2T	Cash discount days 2	DZBD2T		DEC	3
ZBD3T	Net Payment Terms Period	DZBD3T		DEC	3
ZFBDT	Baseline Date for Due Date Calculation	DZFBDT		DATS	8
ZUONR	Assignment number	DZUONR		CHAR	18
FMXDOCNR	FM Reference Document Number	FM_XDOCNR		CHAR	10
FMXYEAR	FM Reference Year	FM_XYEAR		NUMC	4
FMXDOCLN	FM Reference Line Item	FM_XDOCLN		NUMC	6
FMXZEKKN	FM Reference Sequence Account Assignment	FM_XZEKKN		NUMC	5
ANL01	Main Asset Number	ANLN1	ANLH	CHAR	12
ANL02	Asset Subnumber	ANLN2	ANLA	CHAR	4
HBKID	Short Key for a House Bank	HBKID	T012	CHAR	5
PRODPER	Production Month (Date to find period and year)	JV_PRODPER		DATS	8

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ACCTIT

Table Name	Field	Cardinality	Check Table
ACCTIT	ANL01	C: CN	ANLH
ACCTIT	ANL02	C: CN	ANLA
ACCTIT	HBKID	C: CN	T012
ACCTIT	ZZBRAND1	:	ZTBRAND
ACCTIT	ZZCHECK1	:	YTESTV1

SAP ACCTIT Compressed Data from FI/CO Document Table

Overview

Techincal Settings of ACCTIT

List of ACCTIT Fields

Foreign Key Relationships

Other References