SAP ACDOCU Group Journal Entries Table

Overview

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

The table ACDOCU belongs to Consolidation (EC-CS) module and is located in the package Cons: Reporting (FC07_UC).

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

Techincal Settings of ACDOCU

Below are technical details of the table ACDOCU

Buffering not allowed
No buffering
Storage type is Column Store

List of ACDOCU Fields

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

Field	Description	Data Element	Check Table	Data Type	Length
RCLNT	Client	MANDT	T000	CLNT	3
RLDNR	Ledger	RLDNR	T881	CHAR	2
RDIMEN	Dimension	FC_DIMEN	TF150	CHAR	2
RYEAR	Fiscal Year	GJAHR		NUMC	4
DOCNR	Accounting Document Number	BELNR_D		CHAR	10
DOCLN	Six-Character Posting Item for Ledger	DOCLN6		CHAR	6
RRCTY	Record Type	FC_RRCTY		CHAR	1
RVERS	Consolidation (end-result) version	FC_RVERS	TF200	CHAR	3
RTCUR	Currency Key	RTCUR	TCURC	CUKY	5
RHCUR	Currency key of the local currency	LCURR		CUKY	5
RKCUR	Currency key of the ledger currency	GCURR		CUKY	5
RUNIT	Base Unit of Measure	MEINS	T006	UNIT	3
POPER	Posting period	POPER		NUMC	3
FISCYEARPER	Fiscal Year/Period	FINCS_FISCYEARPER		NUMC	7
DOCCT	Document Category	DOCCT		CHAR	1
RCOMP	Company	RCOMP_D	T880	CHAR	6
RBUNIT	Consolidation Unit	FC_BUNIT	TF160	CHAR	18
RITCLG	Consolidation Chart of Accounts	FC_ITCLG	TF120	CHAR	2
RITEM	Financial Statement Item	FC_ITEM	TF100	CHAR	10
RBUPTR	Partner Unit	FC_BUPTR	TF160	CHAR	18
RCONGR	Consolidation Group	FC_CONGR	TF180	CHAR	18
ROBUKRS	Original company code	OBUKR	T001	CHAR	4
SITYP	Subitem Category	FC_SITYP	TF110	CHAR	3
SUBIT	Subitem	FC_SITEM	TF115	CHAR	10
PLEVL	Posting Level	FC_PLEVL		CHAR	2
RPFLG	Apportionment	FC_RPFLG		NUMC	1
RTFLG	Currency Translation	FC_RTFLG		NUMC	1
DOCTY	Document Type	FC_DOCTY	TF500	CHAR	2
YRACQ	Year of Acquisition	FC_RYACQ		NUMC	4
PRACQ	Period of Acquisition	RPACQ		NUMC	3
COICU	Investee Unit	FC_COICU	TF160	CHAR	18
UPPCU	Investor Unit	FC_UPPCU	TF160	CHAR	18
TSL	Value in Transaction Currency	VTCUR12		CURR	23
HSL	Value in Local Currency	VLCUR12		CURR	23
KSL	Value in Group Currency	VGCUR12		CURR	23
MSL	Quantity	FINCS_QUAN		QUAN	29
SGTXT	Item Text	SGTXT		CHAR	50
AUTOM	Indicator: Automatic posting lines	AUTOM		CHAR	1
ACTIV	Business Transaction	GLVOR		CHAR	4
BVORG	Number of Cross-Company Code Posting Transaction	BVORG		CHAR	16
BUDAT	Posting Date in the Document	BUDAT		DATS	8
WSDAT	Value Date for Currency Translation	WSDAT		DATS	8
REFDOCNR	Accounting Document Number	BELNR_D		CHAR	10
REFRYEAR	Original Fiscal Year	FC_OYEAR		NUMC	4
REFDOCLN	Six-figure number of line item	BUZEI6		NUMC	6
REFDOCCT	Document Category	DOCCT		CHAR	1
REFACTIV	Business Transaction	GLVOR		CHAR	4
TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TIMESTAMP		DEC	15
CPUDT	Day On Which Accounting Document Was Entered	CPUDT		DATS	8
CPUTM	Time of Entry	CPUTM		TIMS	6
USNAM	User Name	USNAM	USR02	CHAR	12
RVSDOCNR	Reverse Document Number	STBLG		CHAR	10
ORNDOCNR	Number of Reversed Document	STBLN		CHAR	10
BUNNR	Document Bundle Number	FINCS_BUNNR		CHAR	13
COIAC	Consolidation of Investments Activity	FC_COIAC		CHAR	2
COINR	Consolidation of Investments Activity Number	FC_COINR		CHAR	10
REVYEAR	Year of reversal document or reversed document	FC_REVYEAR		NUMC	4
AWTYP	Reference procedure	AWTYP		CHAR	5
AWORG	Reference Organizational Units	AWORG		CHAR	10
LOGSYS	Logical system	LOGSYS		CHAR	10
KTOPL	Chart of Accounts	KTOPL	T004	CHAR	4
RACCT	Account Number	RACCT	SKB1	CHAR	10
XBLNR	Reference Document Number	XBLNR1		CHAR	16
ZUONR	Assignment number	DZUONR		CHAR	18
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
AUFNR	Order Number	AUFNR	AUFK	CHAR	12
KUNNR	Customer Number	KUNNR	KNA1	CHAR	10
LIFNR	Account Number of Vendor or Creditor	LIFNR	LFA1	CHAR	10
MATNR	Material Number	MATNR	MARA	CHAR	40
MATKL_MM	Material Group	FINS_MATKL_MM	T023	CHAR	9
WERKS	Plant	WERKS_D	T001W	CHAR	4
RMVCT	Transaction type	RMVCT	T856	CHAR	3
PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	PS_PSP_PNR	*	NUMC	8
PS_POSID	Work Breakdown Structure Element (WBS Element)	PS_POSID		CHAR	24
PS_PSPID	Project definition	PS_PSPID		CHAR	24
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
_DATAAGING	Data Filter Value for Data Aging	DATA_TEMPERATURE		DATS	8
ADHOCITEM	Ad Hoc Item	FINCS_ADHOCITEM	FINCS_ADHITM	CHAR	30
ADHOCSET	Ad Hoc Set	FINCS_ADHOCSET	FINCS_ADHSET	CHAR	30
ADHOCSETITEM	Ad Hoc Set Item	FINCS_ADHOCSETITEM	FINCS_ADHSETITM	NUMC	8
RCODE	Reason Code	ICA_RCODE	ICA_RC	CHAR	6
ORIG_TYPE	Origin Type	FINCS_ORIG_TYPE	FINCS_ORIGTYPE	CHAR	3
ORIG_REF	Origin Reference	FINCS_ORIG_REF		CHAR	30

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 ACDOCU

Table Name	Field	Cardinality	Check Table
ACDOCU	ADHOCITEM	:	FINCS_ADHITM
ACDOCU	ADHOCSET	:	FINCS_ADHSET
ACDOCU	ADHOCSETITEM	:	FINCS_ADHSETITM
ACDOCU	AUFNR	C: CN	AUFK
ACDOCU	BRSCH	C: CN	T016
ACDOCU	BZIRK	C: CN	T171
ACDOCU	COICU	C: CN	TF160
ACDOCU	DOCTY	C: CN	TF500
ACDOCU	FKART	C: CN	TVFK
ACDOCU	KDGRP	C: CN	T151
ACDOCU	KOKRS	:	TKA01
ACDOCU	KTOPL	C: CN	T004
ACDOCU	KUNNR	C: CN	KNA1
ACDOCU	KUNRE	C: CN	KNA1
ACDOCU	KUNWE	C: CN	KNA1
ACDOCU	LAND1	C: CN	T005
ACDOCU	LIFNR	C: CN	LFA1
ACDOCU	MATKL	C: CN	T023
ACDOCU	MATKL_MM	C: CN	T023
ACDOCU	MATNR	C: CN	MARA
ACDOCU	MATNR_COPA	C: CN	MARA
ACDOCU	ORIG_TYPE	:	FINCS_ORIGTYPE
ACDOCU	PPRCTR	:	CEPC
ACDOCU	PRCTR	:	CEPC
ACDOCU	PSEGMENT	:	FAGL_SEGM
ACDOCU	RACCT	:	SKB1
ACDOCU	RASSC	:	T880
ACDOCU	RBUNIT	C: CN	TF160
ACDOCU	RBUPTR	C: CN	TF160
ACDOCU	RBUSA	:	TGSB
ACDOCU	RCLNT	1: CN	T000
ACDOCU	RCNTR	:	CSKS
ACDOCU	RCODE	:	ICA_RC
ACDOCU	RCOMP	C: CN	T880
ACDOCU	RCONGR	C: CN	TF180
ACDOCU	RDIMEN	C: CN	TF150
ACDOCU	RFAREA	:	TFKB
ACDOCU	RITCLG	C: CN	TF120
ACDOCU	RITEM	C: CN	TF100
ACDOCU	RLDNR	C: CN	T881
ACDOCU	RMVCT	:	T856
ACDOCU	ROBUKRS	C: CN	T001
ACDOCU	RTCUR	C: CN	TCURC
ACDOCU	RUNIT	C: CN	T006
ACDOCU	RVERS	C: CN	TF200
ACDOCU	SBUSA	:	TGSB
ACDOCU	SCNTR	:	CSKS
ACDOCU	SEGMENT	:	FAGL_SEGM
ACDOCU	SFAREA	:	TFKB
ACDOCU	SITYP	C: CN	TF110
ACDOCU	SPART	C: CN	TSPA
ACDOCU	SUBIT	C: CN	TF115
ACDOCU	UPPCU	C: CN	TF160
ACDOCU	USNAM	C: CN	USR02
ACDOCU	VKORG	C: CN	TVKO
ACDOCU	VTWEG	C: CN	TVTW
ACDOCU	WERKS	C: CN	T001W

SAP ACDOCU Group Journal Entries Table

Overview

Techincal Settings of ACDOCU

List of ACDOCU Fields

Foreign Key Relationships

Other References