SAP Tabel ACDOCU (Group Journal Entries)

SAP table ACDOCU has 6 primary key fields being RCLNT,RLDNR,RDIMEN,RYEAR,DOCNR,DOCLN.

Field Description Data Type Length Decimals Checktable Data Element
RCLNT Client CLNT 3 0 T000 MANDT
RLDNR Ledger CHAR 2 0 T881 RLDNR
RDIMEN Dimension CHAR 2 0 TF150 FC_DIMEN
RYEAR Fiscal Year NUMC 4 0 GJAHR
DOCNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
DOCLN Six-Character Posting Item for Ledger CHAR 6 0 DOCLN6
RRCTY Record Type CHAR 1 0 FC_RRCTY
0 Actual
A Acquisition
D Divestiture
E Equity method
U Replication from Universal Document
RVERS Consolidation Version CHAR 3 0 TF200 FC_RVERS
RTCUR Currency Key CUKY 5 0 TCURC RTCUR
RHCUR Currency key of the local currency CUKY 5 0 LCURR
RKCUR Currency key of the ledger currency CUKY 5 0 GCURR
RUNIT Base Unit of Measure UNIT 3 0 T006 MEINS
POPER Posting period NUMC 3 0 POPER
FISCYEARPER Fiscal Year/Period NUMC 7 0 FINCS_FISCYEARPER
DOCCT Document Category CHAR 1 0 DOCCT
* Any document type
A Documents with assigned document no. of receiver application
B Documents from accounting
C Documents from currency translation
G Documents from FI-SL for global postings
J Documents from Joint Venture
K Documents from CO
L Documents from FI-SL for local postings
M Consolidation documents (EC-MC)
P Documents from manual planning
R Rollup documents
S Documents for which FI-SL assigns document numbers
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
W Documents from the FI/CO doc
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
RCOMP Company CHAR 6 0 T880 RCOMP_D
RBUNIT Consolidation Unit CHAR 18 0 TF160 FC_BUNIT
RITCLG Consolidation Chart of Accounts CHAR 2 0 TF120 FC_ITCLG
RITEM Financial Statement Item CHAR 10 0 TF100 FC_ITEM
RBUPTR Partner Unit CHAR 18 0 TF160 FC_BUPTR
RCONGR Consolidation Group CHAR 18 0 TF180 FC_CONGR
ROBUKRS Original company code CHAR 4 0 T001 OBUKR
SITYP Subitem Category CHAR 3 0 TF110 FC_SITYP
SUBIT Subitem CHAR 10 0 TF115 FC_SITEM
PLEVL Posting Level CHAR 2 0 FC_PLEVL
Realtime update
00 Reported data: Entry
01 Adjustments to reported data
02 Reported data: Cons group change
08 Item substitution
0C Adjustment Entry for Universal Document
0T Reported Data: Currency Translation
10 Standardizing entry
12 Standardized data: Cons group change
20 Two-sided elimination entry
21 Reconciliation entry for elimination
22 Two-sided elimination: Cons group change
23 Two-sided elimination: Special logic
24 Two-sided elimination: Cons group change with special logic
30 Consolidation entry
R0 Rolled-up reported data
R1 Rolled-up standardizing entries
R2 Rolled-up elimination entries
R3 Rolled-up consolidation entries
RPFLG Apportionment NUMC 1 0 FC_RPFLG
0 Original record
1 Record for apportionment
RTFLG Currency Translation NUMC 1 0 FC_RTFLG
0 Group value at reference rate
1 Difference between GC value and GC value at reference rate
2 Group value at reference rate - translation difference
3 Diff. GC value/GC ref.rate value - translation difference
4 Group Currency Value at Reference Rate (Line Item)
DOCTY Document Type CHAR 2 0 TF500 FC_DOCTY
YRACQ Year of Acquisition NUMC 4 0 FC_RYACQ
PRACQ Period of Acquisition NUMC 3 0 RPACQ
COICU Investee Unit CHAR 18 0 TF160 FC_COICU
UPPCU Investor Unit CHAR 18 0 TF160 FC_UPPCU
TSL Value in Transaction Currency CURR 23 2 VTCUR12
HSL Value in Local Currency CURR 23 2 VLCUR12
KSL Value in Group Currency CURR 23 2 VGCUR12
MSL Quantity QUAN 29 8 FINCS_QUAN
SGTXT Item Text CHAR 50 0 SGTXT
AUTOM Indicator: Automatic posting lines CHAR 1 0 AUTOM
ACTIV Business Transaction CHAR 4 0 GLVOR
BVORG Number of Cross-Company Code Posting Transaction CHAR 16 0 BVORG
BUDAT Posting Date in the Document DATS 8 0 BUDAT
WSDAT Value Date for Currency Translation DATS 8 0 WSDAT
REFDOCNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
REFRYEAR Original Fiscal Year NUMC 4 0 FC_OYEAR
REFDOCLN Six-figure number of line item NUMC 6 0 BUZEI6
REFDOCCT Document Category CHAR 1 0 DOCCT
* Any document type
A Documents with assigned document no. of receiver application
B Documents from accounting
C Documents from currency translation
G Documents from FI-SL for global postings
J Documents from Joint Venture
K Documents from CO
L Documents from FI-SL for local postings
M Consolidation documents (EC-MC)
P Documents from manual planning
R Rollup documents
S Documents for which FI-SL assigns document numbers
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
W Documents from the FI/CO doc
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
REFACTIV Business Transaction CHAR 4 0 GLVOR
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM
USNAM User Name CHAR 12 0 USR02 USNAM
RVSDOCNR Reverse Document Number CHAR 10 0 STBLG
ORNDOCNR Number of Reversed Document CHAR 10 0 STBLN
BUNNR Document Bundle Number CHAR 13 0 FINCS_BUNNR
COIAC Consolidation of Investments Activity CHAR 2 0 FC_COIAC
01 First consolidation
02 Subsequent consolidation
03 Amortization of goodwill
04 Amortization of fair value adjustments
05 Increase in capitalization
06 Reduction in capitalization
07 Step acquisition
08 Partial transfer
09 Total transfer
10 Partial divestiture
11 Total divestiture
12 Liquidation
13 Reclassification of treasury stock
14 Amortization of investment
15 Write-up of investment
16 Horizontal business combination
17 Vertical business combination
18 Distribution of dividends
19 Capitalization of Manual Goodwill
20 Increase in indirect investment
21 Reduction in indirect investment
22 Indirect transfer
23 Currency translation of goodwill
24 Updating of Retained Earnings Merger
29 Push-down
32 Purchase -> Proportional
33 Purchase -> Equity
34 Purchase -> Mutual stock
38 History
42 Proportional -> Purchase
45 Proportional -> Equity
46 Proportional -> Mutual stock
48 Equity -> Purchase
50 Equity -> Proportional
52 Equity -> Mutual stock
54 Mutual stock -> Purchase
56 Mutual stock -> Proportional
57 Mutual stock -> Equity
58 Method change
66 Change of Control
COINR Consolidation of Investments Activity Number CHAR 10 0 FC_COINR
REVYEAR Year of reversal document or reversed document NUMC 4 0 FC_REVYEAR
AWTYP Reference procedure CHAR 5 0 AWTYP
AWORG Reference Organizational Units CHAR 10 0 AWORG
LOGSYS Logical system CHAR 10 0 LOGSYS
KTOPL Chart of Accounts CHAR 4 0 T004 KTOPL
RACCT Account Number CHAR 10 0 SKB1 RACCT
XBLNR Reference Document Number CHAR 16 0 XBLNR1
ZUONR Assignment number CHAR 18 0 DZUONR
RCNTR Cost Center CHAR 10 0 CSKS KOSTL
PRCTR Profit Center CHAR 10 0 CEPC PRCTR
RFAREA Functional Area CHAR 16 0 TFKB FKBER
RBUSA Business Area CHAR 4 0 TGSB GSBER
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
SEGMENT Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM FB_SEGMENT
SCNTR Sender cost center CHAR 10 0 CSKS SKOST
PPRCTR Partner Profit Center CHAR 10 0 CEPC PPRCTR
SFAREA Partner Functional Area CHAR 16 0 TFKB SFKBER
SBUSA Trading partner's business area CHAR 4 0 TGSB PARGB
RASSC Company ID of Trading Partner CHAR 6 0 T880 RASSC
PSEGMENT Partner Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM FB_PSEGMENT
AUFNR Order Number CHAR 12 0 AUFK AUFNR
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
MATNR Material Number CHAR 40 0 MARA MATNR
MATKL_MM Material Group CHAR 9 0 T023 FINS_MATKL_MM
WERKS Plant CHAR 4 0 T001W WERKS_D
RMVCT Transaction type CHAR 3 0 T856 RMVCT
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 * PS_PSP_PNR
PS_POSID Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
PS_PSPID Project definition CHAR 24 0 PS_PSPID
FKART Billing Type CHAR 4 0 TVFK FKART
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TSPA SPART
MATNR_COPA Product Sold CHAR 40 0 MARA FINS_MATNR_PA
MATKL Product Sold Group CHAR 9 0 T023 FINS_MATKL_PA
KDGRP Customer Group CHAR 2 0 T151 KDGRP
LAND1 Country/Region Key CHAR 3 0 T005 LAND1_GP
BRSCH Industry key CHAR 4 0 T016 BRSCH
BZIRK Sales District CHAR 6 0 T171 BZIRK
KUNRE Bill-to Party CHAR 10 0 KNA1 KUNRE
KUNWE Ship-to Party CHAR 10 0 KNA1 KUNWE
KONZS Group key CHAR 10 0 KONZS
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
ADHOCITEM Ad Hoc Item CHAR 30 0 FINCS_ADHITM FINCS_ADHOCITEM
ADHOCSET Ad Hoc Set CHAR 30 0 FINCS_ADHSET FINCS_ADHOCSET
ADHOCSETITEM Ad Hoc Set Item NUMC 8 0 FINCS_ADHSETITM FINCS_ADHOCSETITEM
RCODE Reason Code CHAR 6 0 ICA_RC ICA_RCODE
ORIG_TYPE Origin Type CHAR 3 0 FINCS_ORIGTYPE FINCS_ORIG_TYPE
ORIG_REF Origin Reference CHAR 30 0 FINCS_ORIG_REF
DUMMY_CJE_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY

ACDOCU foreign key relationships

Table Field Check Table Check Field
0 ACDOCU ADHOCITEM FINCS_ADHITM Ad Hoc Item MANDT
0 ACDOCU ADHOCITEM FINCS_ADHITM Ad Hoc Item ITCLG
0 ACDOCU ADHOCITEM FINCS_ADHITM Ad Hoc Item ADHOCITEM
1 ACDOCU ADHOCSET FINCS_ADHSET Ad Hoc Set MANDT
1 ACDOCU ADHOCSET FINCS_ADHSET Ad Hoc Set ITCLG
1 ACDOCU ADHOCSET FINCS_ADHSET Ad Hoc Set ADHOCSET
0 ACDOCU ADHOCSETITEM FINCS_ADHSETITM Ad Hoc Set Item MANDT
0 ACDOCU ADHOCSETITEM FINCS_ADHSETITM Ad Hoc Set Item ITCLG
0 ACDOCU ADHOCSETITEM FINCS_ADHSETITM Ad Hoc Set Item ADHOCSET
1 ACDOCU AUFNR AUFK Order master data AUFNR
0 ACDOCU BRSCH T016 Industries BRSCH
1 ACDOCU BZIRK T171 Customers: Sales Districts MANDT
1 ACDOCU BZIRK T171 Customers: Sales Districts BZIRK
0 ACDOCU COICU TF160 Consolidation Units MANDT
0 ACDOCU COICU TF160 Consolidation Units DIMEN
0 ACDOCU COICU TF160 Consolidation Units BUNIT
1 ACDOCU DOCTY TF500 Document Types MANDT
1 ACDOCU DOCTY TF500 Document Types DIMEN
1 ACDOCU DOCTY TF500 Document Types DOCTY
0 ACDOCU FKART TVFK Billing: Document Types MANDT
0 ACDOCU FKART TVFK Billing: Document Types FKART
1 ACDOCU KDGRP T151 Customers: Customer Groups MANDT
1 ACDOCU KDGRP T151 Customers: Customer Groups KDGRP
0 ACDOCU KOKRS TKA01 Controlling Areas MANDT
1 ACDOCU KTOPL T004 Directory of Charts of Accounts MANDT
0 ACDOCU KUNNR KNA1 General Data in Customer Master MANDT
0 ACDOCU KUNNR KNA1 General Data in Customer Master KUNNR
1 ACDOCU KUNRE KNA1 General Data in Customer Master MANDT
1 ACDOCU KUNRE KNA1 General Data in Customer Master KUNNR
0 ACDOCU KUNWE KNA1 General Data in Customer Master MANDT
0 ACDOCU KUNWE KNA1 General Data in Customer Master KUNNR
1 ACDOCU LAND1 T005 Countries MANDT
1 ACDOCU LAND1 T005 Countries LAND1
0 ACDOCU LIFNR LFA1 Supplier Master (General Section) MANDT
0 ACDOCU LIFNR LFA1 Supplier Master (General Section) LIFNR
1 ACDOCU MATKL T023 Material Groups MATKL
0 ACDOCU MATKL_MM T023 Material Groups MATKL
1 ACDOCU MATNR MARA General Material Data MANDT
1 ACDOCU MATNR MARA General Material Data MATNR
0 ACDOCU MATNR_COPA MARA General Material Data MANDT
0 ACDOCU MATNR_COPA MARA General Material Data MATNR
1 ACDOCU PPRCTR CEPC Profit Center Master Data Table PRCTR
1 ACDOCU PPRCTR CEPC Profit Center Master Data Table DATBI
1 ACDOCU PPRCTR CEPC Profit Center Master Data Table KOKRS
0 ACDOCU PRCTR CEPC Profit Center Master Data Table PRCTR
0 ACDOCU PRCTR CEPC Profit Center Master Data Table DATBI
0 ACDOCU PRCTR CEPC Profit Center Master Data Table KOKRS
1 ACDOCU PSEGMENT FAGL_SEGM Master Data for Segments SEGMENT
0 ACDOCU RACCT SKB1 G/L account master (company code) MANDT
0 ACDOCU RACCT SKB1 G/L account master (company code) BUKRS
1 ACDOCU RASSC T880 Global Company Data (for KONS Ledger) MANDT
1 ACDOCU RASSC T880 Global Company Data (for KONS Ledger) RCOMP
0 ACDOCU RBUNIT TF160 Consolidation Units MANDT
0 ACDOCU RBUNIT TF160 Consolidation Units DIMEN
0 ACDOCU RBUNIT TF160 Consolidation Units BUNIT
1 ACDOCU RBUPTR TF160 Consolidation Units MANDT
1 ACDOCU RBUPTR TF160 Consolidation Units DIMEN
1 ACDOCU RBUPTR TF160 Consolidation Units BUNIT
0 ACDOCU RBUSA TGSB Business Areas MANDT
0 ACDOCU RBUSA TGSB Business Areas GSBER
1 ACDOCU RCLNT T000 Clients MANDT
0 ACDOCU RCNTR CSKS Cost Center Master Record MANDT
0 ACDOCU RCNTR CSKS Cost Center Master Record KOKRS
0 ACDOCU RCNTR CSKS Cost Center Master Record KOSTL
0 ACDOCU RCNTR CSKS Cost Center Master Record DATBI
1 ACDOCU RCODE ICA_RC Reason Code RCLNT
1 ACDOCU RCODE ICA_RC Reason Code RCODE
0 ACDOCU RCOMP T880 Global Company Data (for KONS Ledger) MANDT
0 ACDOCU RCOMP T880 Global Company Data (for KONS Ledger) RCOMP
1 ACDOCU RCONGR TF180 Consolidation Groups MANDT
1 ACDOCU RCONGR TF180 Consolidation Groups DIMEN
0 ACDOCU RDIMEN TF150 Dimensions DIMEN
1 ACDOCU RFAREA TFKB Functional areas FKBER
0 ACDOCU RITCLG TF120 Consolidation Charts of Accounts MANDT
0 ACDOCU RITCLG TF120 Consolidation Charts of Accounts ITCLG
1 ACDOCU RITEM TF100 Financial Statement Items MANDT
1 ACDOCU RITEM TF100 Financial Statement Items ITCLG
0 ACDOCU RLDNR T881 Ledger Master MANDT
1 ACDOCU RMVCT T856 Transaction Types MANDT
1 ACDOCU RMVCT T856 Transaction Types TRTYP
0 ACDOCU ROBUKRS T001 Company Codes BUKRS
1 ACDOCU RTCUR TCURC Currency Codes MANDT
1 ACDOCU RTCUR TCURC Currency Codes WAERS
0 ACDOCU RUNIT T006 Units of Measurement MSEHI
1 ACDOCU RVERS TF200 Consolidation Versions MANDT
1 ACDOCU RVERS TF200 Consolidation Versions RVERS
0 ACDOCU SBUSA TGSB Business Areas MANDT
0 ACDOCU SBUSA TGSB Business Areas GSBER
1 ACDOCU SCNTR CSKS Cost Center Master Record MANDT
1 ACDOCU SCNTR CSKS Cost Center Master Record KOKRS
1 ACDOCU SCNTR CSKS Cost Center Master Record KOSTL
1 ACDOCU SCNTR CSKS Cost Center Master Record DATBI
0 ACDOCU SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
1 ACDOCU SFAREA TFKB Functional areas FKBER
0 ACDOCU SITYP TF110 Subitem Categories MANDT
0 ACDOCU SITYP TF110 Subitem Categories SITYP
1 ACDOCU SPART TSPA Organizational Unit: Sales Divisions MANDT
1 ACDOCU SPART TSPA Organizational Unit: Sales Divisions SPART
0 ACDOCU SUBIT TF115 Subitems MANDT
0 ACDOCU SUBIT TF115 Subitems SITYP
0 ACDOCU SUBIT TF115 Subitems SITEM
1 ACDOCU UPPCU TF160 Consolidation Units MANDT
1 ACDOCU UPPCU TF160 Consolidation Units DIMEN
1 ACDOCU UPPCU TF160 Consolidation Units BUNIT
0 ACDOCU USNAM USR02 Logon Data (Kernel-Side Use) BNAME
1 ACDOCU VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 ACDOCU VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 ACDOCU VTWEG TVTW Organizational Unit: Distribution Channels MANDT
0 ACDOCU VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
1 ACDOCU WERKS T001W Plants/Branches MANDT
1 ACDOCU WERKS T001W Plants/Branches WERKS