ACDOCU

Group Journal Entries | #transactional | Component: Consolidation
Column Name Description
RCLNT FK Client
RLDNR FK Ledger
RDIMEN FK Dimension
RYEAR Fiscal Year
DOCNR Document Number of an Accounting Document
DOCLN Six-Character Posting Item for Ledger
Column Name Description
💲 Currency Key (RTCUR):
TSL Value in Transaction Currency
💲 Currency key of the local currency (RHCUR):
HSL Value in Local Currency
💲 Currency key of the ledger currency (RKCUR):
KSL Value in Group Currency
Column Name Description
📏 Base Unit of Measure (RUNIT):
MSL Quantity
Column Name Description
BUDAT Posting Date in the Document
WSDAT Value Date for Currency Translation
CPUDT Day On Which Accounting Document Was Entered
CPUTM Time of Entry
_DATAAGING Data Filter Value for Data Aging
Column Name Description
RRCTY Record Type Show values
DOCCT Document Category Show values
PLEVL Posting Level Show values
RPFLG Apportionment Show values
RTFLG Currency Translation Show values
REFDOCCT Document Category Show values
COIAC Consolidation of Investments Activity Show values
Column Name Description Domain name
POPER Posting period POPER
FISCYEARPER Fiscal Year/Period FINS_JAHRPER
YRACQ Year of Acquisition GJAHR
PRACQ Period of Acquisition NUM03
SGTXT Item Text TEXT50
AUTOM Indicator: Automatic posting lines TEXT1
ACTIV Business Transaction CHAR4
BVORG Number of Cross-Company Code Posting Transaction BVORG
REFDOCNR Document Number of an Accounting Document BELNR
REFRYEAR Original Fiscal Year GJAHR
REFDOCLN Six-figure number of line item BUZEI6
REFACTIV Business Transaction CHAR4
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
RVSDOCNR Reverse Document Number BELNR
ORNDOCNR Number of Reversed Document BELNR
BUNNR Document Bundle Number FINCS_BUNNR
COINR Consolidation of Investments Activity Number BELNR
REVYEAR Year of reversal document or reversed document GJAHR
AWTYP Reference procedure AWTYP
AWORG Reference Organizational Units AWORG
LOGSYS Logical system LOGSYS
XBLNR Reference Document Number XBLNR1
ZUONR Assignment number ZUONR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_POSNR
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID
PS_PSPID Project definition PS_PSPID
KONZS Group key KONZS
ORIG_REF Origin Reference FINCS_ORIG_REF
DUMMY_CJE_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
Master Data Relations Join Conditions
Ad Hoc Item
  • ?
  • Client
  • Ad Hoc Item
Ad Hoc Set
  • Ad Hoc Set
  • Client
  • ?
Ad Hoc Set Item
  • Ad Hoc Set
  • ?
  • Ad Hoc Set Item
Order Number
  • Order Number
  • Client
  • ACDOCU.AUFNR == AUFK.AUFNR
  • ACDOCU.RCLNT == AUFK.MANDT
Industry key
  • Industry key
  • Client
  • ACDOCU.BRSCH == T016.BRSCH
  • ACDOCU.RCLNT == T016.MANDT
Sales District
  • ACDOCU.RCLNT == T171.MANDT
  • ACDOCU.BZIRK == T171.BZIRK
Investee Unit
  • Investee Unit
  • Dimension
  • ACDOCU.RCLNT == TF160.MANDT
  • ACDOCU.COICU == TF160.BUNIT
  • ACDOCU.RDIMEN == TF160.DIMEN
Document Type
  • Document Type
  • Dimension
  • ACDOCU.RCLNT == TF500.MANDT
  • ACDOCU.DOCTY == TF500.DOCTY
  • ACDOCU.RDIMEN == TF500.DIMEN
Billing Type
  • ACDOCU.RCLNT == TVFK.MANDT
  • ACDOCU.FKART == TVFK.FKART
Customer Group
  • Customer Group
  • Client
  • ACDOCU.KDGRP == T151.KDGRP
  • ACDOCU.RCLNT == T151.MANDT
Controlling Area
  • ACDOCU.RCLNT == TKA01.MANDT
  • ACDOCU.KOKRS == TKA01.KOKRS
Chart of Accounts
  • Chart of Accounts
  • Client
  • ACDOCU.KTOPL == T004.KTOPL
  • ACDOCU.RCLNT == T004.MANDT
Customer Number
  • ACDOCU.RCLNT == KNA1.MANDT
  • ACDOCU.KUNNR == KNA1.KUNNR
Bill-to Party
  • ACDOCU.RCLNT == KNA1.MANDT
  • ACDOCU.KUNRE == KNA1.KUNNR
Ship-to Party
  • ACDOCU.RCLNT == KNA1.MANDT
  • ACDOCU.KUNWE == KNA1.KUNNR
Country/Region Key
  • Country/Region Key
  • Client
  • ACDOCU.LAND1 == T005.LAND1
  • ACDOCU.RCLNT == T005.MANDT
Account Number of Supplier
  • ACDOCU.RCLNT == LFA1.MANDT
  • ACDOCU.LIFNR == LFA1.LIFNR
Product Sold Group
  • ACDOCU.RCLNT == T023.MANDT
  • ACDOCU.MATKL == T023.MATKL
Material Group
  • ACDOCU.RCLNT == T023.MANDT
  • ACDOCU.MATKL_MM == T023.MATKL
Material Number
  • Material Number
  • Client
  • ACDOCU.MATNR == MARA.MATNR
  • ACDOCU.RCLNT == MARA.MANDT
Product Sold
  • Product Sold
  • Client
  • ACDOCU.MATNR_COPA == MARA.MATNR
  • ACDOCU.RCLNT == MARA.MANDT
Partner Profit Center
  • ?
  • Controlling Area
  • Partner Profit Center
  • ACDOCU.RCLNT == CEPC.MANDT
  • ACDOCU.[column in domain "DATBI"] == CEPC.DATBI
  • ACDOCU.KOKRS == CEPC.KOKRS
  • ACDOCU.PPRCTR == CEPC.PRCTR
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • ACDOCU.RCLNT == CEPC.MANDT
  • ACDOCU.[column in domain "DATBI"] == CEPC.DATBI
  • ACDOCU.KOKRS == CEPC.KOKRS
  • ACDOCU.PRCTR == CEPC.PRCTR
Partner Segment for Segmental Reporting
Account Number
  • Original company code
  • Client
  • Account Number
  • ACDOCU.ROBUKRS == SKB1.BUKRS
  • ACDOCU.RCLNT == SKB1.MANDT
  • ACDOCU.RACCT == SKB1.SAKNR
Company ID of Trading Partner
  • ACDOCU.RCLNT == T880.MANDT
  • ACDOCU.RASSC == T880.RCOMP
Consolidation Unit
  • Consolidation Unit
  • Dimension
  • ACDOCU.RCLNT == TF160.MANDT
  • ACDOCU.RBUNIT == TF160.BUNIT
  • ACDOCU.RDIMEN == TF160.DIMEN
Partner Unit
  • Partner Unit
  • Dimension
  • ACDOCU.RCLNT == TF160.MANDT
  • ACDOCU.RBUPTR == TF160.BUNIT
  • ACDOCU.RDIMEN == TF160.DIMEN
Business Area
  • ACDOCU.RCLNT == TGSB.MANDT
  • ACDOCU.RBUSA == TGSB.GSBER
Client ACDOCU.RCLNT == T000.MANDT
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • ACDOCU.RCLNT == CSKS.MANDT
  • ACDOCU.[column in domain "DATBI"] == CSKS.DATBI
  • ACDOCU.RCNTR == CSKS.KOSTL
  • ACDOCU.KOKRS == CSKS.KOKRS
Reason Code
Company
  • ACDOCU.RCLNT == T880.MANDT
  • ACDOCU.RCOMP == T880.RCOMP
Consolidation Group
  • Dimension
  • Consolidation Group
  • ACDOCU.RCLNT == TF180.MANDT
  • ACDOCU.RDIMEN == TF180.DIMEN
  • ACDOCU.RCONGR == TF180.CONGR
Dimension
  • Dimension
  • Client
  • ACDOCU.RDIMEN == TF150.DIMEN
  • ACDOCU.RCLNT == TF150.MANDT
Functional Area
  • ACDOCU.RCLNT == TFKB.MANDT
  • ACDOCU.RFAREA == TFKB.FKBER
Consolidation Chart of Accounts
  • Consolidation Chart of Accounts
  • Client
  • ACDOCU.RITCLG == TF120.ITCLG
  • ACDOCU.RCLNT == TF120.MANDT
Financial Statement Item
  • Consolidation Chart of Accounts
  • Client
  • Financial Statement Item
  • ACDOCU.RITCLG == TF100.ITCLG
  • ACDOCU.RCLNT == TF100.MANDT
  • ACDOCU.RITEM == TF100.ITEM
Ledger
  • Ledger
  • Client
  • ACDOCU.RLDNR == T881.RLDNR
  • ACDOCU.RCLNT == T881.MANDT
Transaction type
  • ACDOCU.RCLNT == T856.MANDT
  • ACDOCU.RMVCT == T856.TRTYP
Original company code
  • ACDOCU.RCLNT == T001.MANDT
  • ACDOCU.ROBUKRS == T001.BUKRS
Currency Key
  • ACDOCU.RCLNT == TCURC.MANDT
  • ACDOCU.RTCUR == TCURC.WAERS
Base Unit of Measure
  • ACDOCU.RCLNT == T006.MANDT
  • ACDOCU.RUNIT == T006.MSEHI
Consolidation Version
  • ACDOCU.RCLNT == TF200.MANDT
  • ACDOCU.RVERS == TF200.RVERS
Trading partner's business area
  • ACDOCU.RCLNT == TGSB.MANDT
  • ACDOCU.SBUSA == TGSB.GSBER
Sender cost center
  • ?
  • Sender cost center
  • Controlling Area
  • ACDOCU.RCLNT == CSKS.MANDT
  • ACDOCU.[column in domain "DATBI"] == CSKS.DATBI
  • ACDOCU.SCNTR == CSKS.KOSTL
  • ACDOCU.KOKRS == CSKS.KOKRS
Segment for Segmental Reporting
Partner Functional Area
  • ACDOCU.RCLNT == TFKB.MANDT
  • ACDOCU.SFAREA == TFKB.FKBER
Subitem Category
  • Subitem Category
  • Client
  • ACDOCU.SITYP == TF110.SITYP
  • ACDOCU.RCLNT == TF110.MANDT
Division
  • ACDOCU.RCLNT == TSPA.MANDT
  • ACDOCU.SPART == TSPA.SPART
Subitem
  • Subitem
  • Client
  • Subitem Category
  • ACDOCU.SUBIT == TF115.SITEM
  • ACDOCU.RCLNT == TF115.MANDT
  • ACDOCU.SITYP == TF115.SITYP
Investor Unit
  • Investor Unit
  • Dimension
  • ACDOCU.RCLNT == TF160.MANDT
  • ACDOCU.UPPCU == TF160.BUNIT
  • ACDOCU.RDIMEN == TF160.DIMEN
User Name
  • ACDOCU.RCLNT == USR02.MANDT
  • ACDOCU.USNAM == USR02.BNAME
Sales Organization
  • ACDOCU.RCLNT == TVKO.MANDT
  • ACDOCU.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • ACDOCU.VTWEG == TVTW.VTWEG
  • ACDOCU.RCLNT == TVTW.MANDT
Plant
  • ACDOCU.RCLNT == T001W.MANDT
  • ACDOCU.WERKS == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Origin Type ACDOCU.ORIG_TYPE == FINCS_ORIGTYPE.ORIG_TYPE