SAP ACDOCC Consolidation Journal Table

Overview

ACDOCC is a standard SAP S/4HANA table that stores Consolidation Journal data. There are total 162 fields in the ACDOCC table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ACDOCC belongs to Real-Time Consolidation (FIN-RTC) module and is located in the package Real-Time Consolidation: Common Reusable Objects (FINS_RTC_COMM).

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

Techincal Settings of ACDOCC

Below are technical details of the table ACDOCC

Buffering not allowed
No buffering
Storage type is Column Store

List of ACDOCC Fields

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

Field	Description	Data Element	Check Table	Data Type	Length
RCLNT	Client	MANDT		CLNT	3
MODEL	Model	RTC_CON_MODEL		CHAR	6
RYEAR	Fiscal year	RYEAR		NUMC	4
BELNR	Accounting Document Number	BELNR_D		CHAR	10
DOCLN	Line Item	RTC_DOCLN10		INT4	10
DELFLG	Transaction marked for deletion?	RTC_DEL_FLAG		CHAR	1
TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TIMESTAMP		DEC	15
USNAM	User Name	USNAM		CHAR	12
RLDNR	Real-Time Consolidation Ledger	RTC_RLDNR		CHAR	2
MODEL_VER	Model Version Number	RTC_VERN		CHAR	6
VERID	Version ID	RTC_VERID		CHAR	5
RBUKRS	Company Code	BUKRS		CHAR	4
PBUKRS	Company Code of Partner	PBUKRS	*	CHAR	4
RCOMP	Company	RCOMP_D	*	CHAR	6
RVERS	Variant	RTC_RVERS	*	CHAR	3
BPC_CATG	Plan Category	FCOM_CATEGORY	*	CHAR	10
RTC_CATG	Real-Time Consolidation Data Category	RTC_DCAT		CHAR	10
KTOPL	Group Chart of Accounts	RTC_KKTPL	*	CHAR	4
RACCT	Group Account Number	BILKT	*	CHAR	10
PR_UUID	Data Submit Request UUID	RTC_PR_UUID		RAW	16
PKOKRS	Partner Controlling Area	RTC_PKOKRS	*	CHAR	4
PLEVL	Real-Time Consolidation Posting Level	RTC_PLEVEL		CHAR	2
RCNTR	Cost Center	KOSTL	CSKS	CHAR	10
PRCTR	Profit Center	PRCTR	CEPC	CHAR	10
RFAREA	Functional Area	FKBER	TFKB	CHAR	16
RBUSA	Business Area	GSBER	TGSB	CHAR	4
KOKRS	Controlling Area	KOKRS	TKA01	CHAR	4
SEGMENT	Segment for Segmental Reporting	FB_SEGMENT	FAGL_SEGM	CHAR	10
SCNTR	Sender cost center	SKOST	CSKS	CHAR	10
PPRCTR	Partner Profit Center	PPRCTR	CEPC	CHAR	10
SFAREA	Partner Functional Area	SFKBER	TFKB	CHAR	16
SBUSA	Trading partner's business area	PARGB	TGSB	CHAR	4
RASSC	Company ID of Trading Partner	RASSC	T880	CHAR	6
PSEGMENT	Partner Segment for Segmental Reporting	FB_PSEGMENT	FAGL_SEGM	CHAR	10
RMVCT	Transaction type	RMVCT	T856	CHAR	3
AUDIT_TRA	Audit Trail	RTC_AUDIT_TRAIL		CHAR	20
BTTYPE	Business Transaction Type	RTC_BTTYPE		CHAR	4
DOCAUTO	Line Item: Automatic Posting	RTC_DOCAUTO		NUMC	1
REF_BELNR	Reference Accounting Document Number	RTC_REF_BELNR		CHAR	10
REF_DOCLN	Reference Line Item	RTC_REF_DOCLN		INT4	10
RWCUR	Transaction Currency	FINS_CURRW	*	CUKY	5
RHCUR	Company Code Currency	FINS_CURRH	*	CUKY	5
RKCUR	Global Currency	FINS_CURRK	*	CUKY	5
RCO_OCUR	CO Object Currency	FINS_CO_OCUR	*	CUKY	5
CONS_CUR	Group Currency	RTC_CURR	*	CUKY	5
RUNIT	Base Unit of Measure	MEINS	T006	UNIT	3
RVUNIT	Unit of Measure for Valuation Quantity	RVUNIT	T006	UNIT	3
RRUNIT	Unit of Measure for Reference Quantity	RRUNIT	T006	UNIT	3
RMSL_TYPE	Quantity Type Code of the Reference Quantity	FINS_RMSL_QTY_TYPE_CODE		CHAR	1
RIUNIT	Unit of Measure for Inventory Quantity	FINS_RIUNIT	T006	UNIT	3
QUNIT1	Additional Unit of Measure 1	FCO_QUNIT1	T006	UNIT	3
QUNIT2	Additional Unit of Measure 2	FCO_QUNIT2	T006	UNIT	3
QUNIT3	Additional Unit of Measure 3	FCO_QUNIT3	T006	UNIT	3
CO_MEINH	Unit of Measure for CO Valuation Quantity	FCO_MEINH	*	UNIT	3
WSL	Amount in Transaction Currency	FINS_VWCUR12		CURR	23
HSL	Amount in Company Code Currency	FINS_VHCUR12		CURR	23
KSL	Amount in Global Currency	FINS_VKCUR12		CURR	23
CONS_SL	Amount in Group Currency	RTC_CUR_AMT		CURR	23
MSL	Quantity	QUAN1_12		QUAN	23
MFSL	Fixed quantity	QUAN1_12_FIX		QUAN	23
VMSL	Valuation quantity	VQUAN1_12		QUAN	23
VMFSL	Fixed valuation quantity	VQUAN1_12_FIX		QUAN	23
RMSL	Reference quantity	RQUAN1_12		QUAN	23
QUANT1	Additional Quantity 1	FCO_QUAN1_L		QUAN	23
QUANT2	Additional Quantity 2	FCO_QUAN2_L		QUAN	23
QUANT3	Additional Quantity 3	FCO_QUAN3_L		QUAN	23
DRCRK	Debit/Credit Indicator	SHKZG		CHAR	1
POPER	Posting period	POPER		NUMC	3
PERIV	Fiscal Year Variant	PERIV	*	CHAR	2
FISCYEARPER	Period/Year	JAHRPER		NUMC	7
BUDAT	Posting Date in the Document	BUDAT		DATS	8
BLDAT	Document Date in Document	BLDAT		DATS	8
BLART	Consolidation Document Type	RTC_BLART		CHAR	2
BUZEI	Number of Line Item Within Accounting Document	BUZEI		NUMC	3
BSCHL	Posting Key	BSCHL	*	CHAR	2
BSTAT	Document Status	RTC_BSTAT		CHAR	1
GLACCOUNT_TYPE	Type of a General Ledger Account	GLACCOUNT_TYPE		CHAR	1
MATNR	Material Number	MATNR		CHAR	40
WERKS	Plant	WERKS_D		CHAR	4
LIFNR	Account Number of Vendor or Creditor	LIFNR		CHAR	10
KUNNR	Customer Number	KUNNR		CHAR	10
MWSKZ	Tax on sales/purchases code	MWSKZ	*	CHAR	2
ANLN1	Main Asset Number	ANLN1	*	CHAR	12
ANLN2	Asset Subnumber	ANLN2	*	CHAR	4
ANBWA	Asset Transaction Type	ANBWA	*	CHAR	3
MOVCAT	Transaction Type Category	FAA_MOVCAT	FAAI_MOVCAT	CHAR	2
ANLGR	Group Asset	ANLGR	*	CHAR	12
ANLGR2	Subnumber of Group Asset	ANLGR2	*	CHAR	4
SETTLEMENT_RULE	Distribution Rule Group	BUREG		NUMC	3
PS_POSID	Work Breakdown Structure Element (WBS Element)	PS_POSID		CHAR	24
PS_PSPID	Project definition	PS_PSPID		CHAR	24
ZTEST98765	ABCDEFG - Change	ZTEST98765		CHAR	80
ZDIRECT	Test 456	ZTEST456		CHAR	2
FKART	Billing Type	FKART	TVFK	CHAR	4
VKORG	Sales Organization	VKORG	TVKO	CHAR	4
VTWEG	Distribution Channel	VTWEG	TVTW	CHAR	2
SPART	Division	SPART	TSPA	CHAR	2
MATNR_COPA	Product Sold	FINS_MATNR_PA	MARA	CHAR	40
MATKL	Product Sold Group	FINS_MATKL_PA	T023	CHAR	9
KDGRP	Customer Group	KDGRP	T151	CHAR	2
LAND1	Country Key	LAND1_GP	T005	CHAR	3
BRSCH	Industry key	BRSCH	T016	CHAR	4
BZIRK	Sales District	BZIRK	T171	CHAR	6
KUNRE	Bill-to party	KUNRE	KNA1	CHAR	10
KUNWE	Ship-to party	KUNWE	KNA1	CHAR	10
KONZS	Group key	KONZS		CHAR	10
ACDOC_COPA_EEW_DUMMY_PA	Dummy function in length 1	DUMMY		CHAR	1
VKGRP_PA	Sales group	VKGRP	TVKGR	CHAR	3
MAABC_PA	ABC Indicator	MAABC	TMABC	CHAR	1
BONUS_PA	Volume rebate group	BONUS	TVBO	CHAR	2
VKBUR_PA	Sales office	VKBUR	TVBUR	CHAR	4
EFORM_PA	Form of manufacture	RKEG_EFORM	T2513	CHAR	5
GEBIE_PA	Area	RKEG_GEBIE	T2538	CHAR	4
KMVKBU_PA	Sales office	VKBUR	TVBUR	CHAR	4
KMVKGR_PA	Sales group	VKGRP	TVKGR	CHAR	3
KMBRND_PA	Brand	RKESKMBRND	T2249	NUMC	2
CRMELEM_PA	CRM Marketing Element	RKECRMELEM	PRPS	NUMC	8
KMKDGR_PA	Customer Group	KDGRP	T151	CHAR	2
KMLAND_PA	Country Key	LAND1_GP	T005	CHAR	3
KMMAKL_PA	Material Group	MATKL	T023	CHAR	9
KMVTNR_PA	Sales employee	VRTNR		NUMC	8
WWTES_PA	Test Partner	RKEG_WWTES		CHAR	10
KMHI01_PA	Customer hierarchy Level 1	HIEZU01	KNA1	CHAR	10
KMHI02_PA	Customer hierarchy Level 2	HIEZU02	KNA1	CHAR	10
KMHI03_PA	Customer hierarchy Level 3	HIEZU03	KNA1	CHAR	10
CRMCSTY_PA	CRM Cost Element	RKECRMCSTY	*	CHAR	10
KMATYP_PA	Aircraft Type	RKESKMATYP	T2209	NUMC	2
KMDEST_PA	Destination	RKESKMDEST	T2211	CHAR	5
KMFLTN_PA	Flight Number	RKESKMFLTN	T2215	CHAR	6
KMFLTY_PA	Flight Type	RKESKMFLTY	T2216	CHAR	4
KMIATA_PA	IATA Season	RKESKMIATA	T2207	CHAR	5
KMLEGS_PA	Route Segment	RKESKMLEGS	T2213	CHAR	7
KMOPDY_PA	Day of Operation	RKESKMOPDY	T2208	CHAR	2
KMORIG_PA	Departure Location	RKESKMORIG	T2212	CHAR	5
KMROUT_PA	Rotation	RKESKMROUT	T2210	CHAR	5
KMSTGE_PA	Strategic Business Unit	RKESKMSTGE	T2247	NUMC	2
KMWNHG_PA	Main Material Group	RKESKMWNHG	T2246	NUMC	2
KMZONE_PA	Zone	RKESKMZONE	T2214	CHAR	5
PAPH1_PA	Prod.hierarchy01-1	RKEG_PAPH1		CHAR	5
PRODH_PA	Product hierarchy	PRODH_D	T179	CHAR	18
WWACT_PA	Activity	RKEG_WWACT	T2500	CHAR	2
WWERM_PA	Shipping Point / Receiving Point	VSTEL	TVST	CHAR	4
PAPH2_PA	Prod.hierarchy01-2	RKEG_PAPH2		CHAR	10
PAPH3_PA	Prod.hierarchy01-3	RKEG_PAPH3		CHAR	18
COLLE_PA	Fashion Collection	FSH_COLLECTION	FSH_COLLECTIONS	CHAR	10
CRMFIGR_PA	CRM Key Figure	RKECRMFIGR	TKECRMFIGR	CHAR	16
KMCATG_PA	Business field	RKESKMCATG	T2248	NUMC	2
KMNIEL_PA	Nielsen ID	NIELS	TNLS	CHAR	2
SAISJ_PA	Season Year	FSH_SAISJ		CHAR	4
SAISO_PA	Season	FSH_SAISO	FSH_SEASONS	CHAR	10
ARTNRG_PA	Generic Article	FSH_ARTNRG	MARA	CHAR	40
MATNR_PA	Material Number	MATNR	MARA	CHAR	40
PARTNER_PA	CO-PA Partner	RKEPARTNER	TKEPARTNER	CHAR	10
REGIO_PA	Region (State, Province, County)	REGIO	T005S	CHAR	3
WW001_PA	BRAND Reporting	RKEG_WW001	T2501	CHAR	5
WW100_PA	Country/Region Key	LAND1	T005	CHAR	3
WW101_PA	Country/Region Key	LAND1	T005	CHAR	3
WWBU1_PA	Test Business Unit	RKEG_WWBU1	T2508	CHAR	10
RCONGR1	Consolidation Group (1)	RTC_CONGR1		CHAR	20
RCONGR2	Consolidation Group (2)	RTC_CONGR2		CHAR	20
RCONGR3	Consolidation Group (3)	RTC_CONGR3		CHAR	20
RTFLG	Translation Indicator for ACDOCC	RTC_TRANS_IND		CHAR	2

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 ACDOCC

Table Name	Field	Cardinality	Check Table
ACDOCC	ARTNRG_PA	C: CN	MARA
ACDOCC	BONUS_PA	C: CN	TVBO
ACDOCC	BRSCH	C: CN	T016
ACDOCC	BZIRK	C: CN	T171
ACDOCC	COLLE_PA	C: CN	FSH_COLLECTIONS
ACDOCC	CRMELEM_PA	C: CN	PRPS
ACDOCC	CRMFIGR_PA	C: CN	TKECRMFIGR
ACDOCC	EFORM_PA	C: CN	T2513
ACDOCC	FKART	C: CN	TVFK
ACDOCC	GEBIE_PA	C: CN	T2538
ACDOCC	KDGRP	C: CN	T151
ACDOCC	KMATYP_PA	C: CN	T2209
ACDOCC	KMBRND_PA	C: CN	T2249
ACDOCC	KMCATG_PA	C: CN	T2248
ACDOCC	KMDEST_PA	C: CN	T2211
ACDOCC	KMFLTN_PA	C: CN	T2215
ACDOCC	KMFLTY_PA	C: CN	T2216
ACDOCC	KMHI01_PA	C: CN	KNA1
ACDOCC	KMHI02_PA	C: CN	KNA1
ACDOCC	KMHI03_PA	C: CN	KNA1
ACDOCC	KMIATA_PA	C: CN	T2207
ACDOCC	KMKDGR_PA	C: CN	T151
ACDOCC	KMLAND_PA	C: CN	T005
ACDOCC	KMLEGS_PA	C: CN	T2213
ACDOCC	KMMAKL_PA	C: CN	T023
ACDOCC	KMNIEL_PA	C: CN	TNLS
ACDOCC	KMOPDY_PA	C: CN	T2208
ACDOCC	KMORIG_PA	C: CN	T2212
ACDOCC	KMROUT_PA	C: CN	T2210
ACDOCC	KMSTGE_PA	C: CN	T2247
ACDOCC	KMVKBU_PA	C: CN	TVBUR
ACDOCC	KMVKGR_PA	C: CN	TVKGR
ACDOCC	KMWNHG_PA	C: CN	T2246
ACDOCC	KMZONE_PA	C: CN	T2214
ACDOCC	KOKRS	:	TKA01
ACDOCC	KUNRE	C: CN	KNA1
ACDOCC	KUNWE	C: CN	KNA1
ACDOCC	LAND1	C: CN	T005
ACDOCC	MAABC_PA	C: CN	TMABC
ACDOCC	MATKL	C: CN	T023
ACDOCC	MATNR_COPA	C: CN	MARA
ACDOCC	MATNR_PA	C: CN	MARA
ACDOCC	MOVCAT	:	FAAI_MOVCAT
ACDOCC	PARTNER_PA	C: CN	TKEPARTNER
ACDOCC	PPRCTR	:	CEPC
ACDOCC	PRCTR	:	CEPC
ACDOCC	PRODH_PA	C: CN	T179
ACDOCC	PSEGMENT	:	FAGL_SEGM
ACDOCC	QUNIT1	C: CN	T006
ACDOCC	QUNIT2	C: CN	T006
ACDOCC	QUNIT3	C: CN	T006
ACDOCC	RASSC	:	T880
ACDOCC	RBUSA	:	TGSB
ACDOCC	RCNTR	:	CSKS
ACDOCC	REGIO_PA	C: CN	T005S
ACDOCC	RFAREA	:	TFKB
ACDOCC	RIUNIT	C: CN	T006
ACDOCC	RMVCT	:	T856
ACDOCC	RRUNIT	C: CN	T006
ACDOCC	RUNIT	C: CN	T006
ACDOCC	RVUNIT	C: CN	T006
ACDOCC	SAISO_PA	C: CN	FSH_SEASONS
ACDOCC	SBUSA	:	TGSB
ACDOCC	SCNTR	:	CSKS
ACDOCC	SEGMENT	:	FAGL_SEGM
ACDOCC	SFAREA	:	TFKB
ACDOCC	SPART	C: CN	TSPA
ACDOCC	VKBUR_PA	C: CN	TVBUR
ACDOCC	VKGRP_PA	C: CN	TVKGR
ACDOCC	VKORG	C: CN	TVKO
ACDOCC	VTWEG	C: CN	TVTW
ACDOCC	WW001_PA	C: CN	T2501
ACDOCC	WW100_PA	C: CN	T005
ACDOCC	WW101_PA	C: CN	T005
ACDOCC	WWACT_PA	C: CN	T2500
ACDOCC	WWBU1_PA	C: CN	T2508
ACDOCC	WWERM_PA	C: CN	TVST
ACDOCC	ZZBRAND1	:	ZTBRAND
ACDOCC	ZZCHECK1	:	YTESTV1

SAP ACDOCC Consolidation Journal Table

Overview

Techincal Settings of ACDOCC

List of ACDOCC Fields

Foreign Key Relationships

Other References