P_ReportedFinancialData_RT_01

Select from ACDOCA; Consolidation Unit; Period and Year | view: PREPFINDRT_01 | Extraction: Not supported | Component: Consolidation
Tables used: ACDOCA, T001, TKA02, T000, T881, TF165, TF168, TF200, FINSC_LEDGER_REP, FINSC_FISC_DATE, TFIN010
Column Name Description
Column Name Description
💲 Balance Transaction Currency (rtcur):
tsl Amount in Balance Transaction Currency
hsl Amount in Company Code Currency
ksl Amount in Global Currency
osl Amount in Freely Defined Currency 1
vsl Amount in Freely Defined Currency 2
bsl Amount in Freely Defined Currency 3
csl Amount in Freely Defined Currency 4
dsl Amount in Freely Defined Currency 5
esl Amount in Freely Defined Currency 6
fsl Amount in Freely Defined Currency 7
gsl Amount in Freely Defined Currency 8
Column Name Description
📏 Base Unit of Measure (runit):
msl Quantity
Column Name Description
budat Posting Date
Column Name Description
curr_group_send Source for Group Currency Key Figure Show values
Column Name Description Domain name
docln_fin Ledger Journal Entry Item DOCLN6
gjahr Fiscal Year GJAHR
belnr Journal Entry BELNR
docln Ledger Journal Entry Item DOCLN6
activ null
refdocnr Reference document number AWREF
refryear Fiscal Year GJAHR
refactiv null
aworg Reference Document Context AWORG
timestamp Time Stamp of Creation TZNTSTMPS
rvers Consolidation Version FC_RVERS
rldnr Ledger RLDNR
const_zero UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
poper Fiscal Period POPER
ryear Fiscal Year GJAHR
fiscal_year_period Fiscal Year + Fiscal Period FINS_FYEARPERIOD
Master Data Relations Join Conditions
Reference Document Type P_REPORTEDFINANCIALDATA_RT_01.AWTYP == TTYP.AWTYP
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_REPORTEDFINANCIALDATA_RT_01.BLART == T003.BLART
  • P_REPORTEDFINANCIALDATA_RT_01.MANDT == T003.MANDT
Item Mapping Version
  • Item Mapping Version
  • Client
  • P_REPORTEDFINANCIALDATA_RT_01.IMPVS == TF23A.IMPVS
  • P_REPORTEDFINANCIALDATA_RT_01.MANDT == TF23A.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_REPORTEDFINANCIALDATA_RT_01.KTOPL == T004.KTOPL
  • P_REPORTEDFINANCIALDATA_RT_01.MANDT == T004.MANDT
Logical System P_REPORTEDFINANCIALDATA_RT_01.LOGSYS == TBDLS.LOGSYS
Profit Center
  • ?
  • Profit Center
  • Client
  • ?
  • P_REPORTEDFINANCIALDATA_RT_01.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_REPORTEDFINANCIALDATA_RT_01.PRCTR == CEPC.PRCTR
  • P_REPORTEDFINANCIALDATA_RT_01.MANDT == CEPC.MANDT
  • P_REPORTEDFINANCIALDATA_RT_01.[column in domain "DATBI"] == CEPC.DATBI
G/L Account
  • G/L Account
  • Client
  • Company Code
  • P_REPORTEDFINANCIALDATA_RT_01.RACCT == SKB1.SAKNR
  • P_REPORTEDFINANCIALDATA_RT_01.MANDT == SKB1.MANDT
  • P_REPORTEDFINANCIALDATA_RT_01.ROBUKRS == SKB1.BUKRS
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_REPORTEDFINANCIALDATA_RT_01.RASSC == T880.RCOMP
  • P_REPORTEDFINANCIALDATA_RT_01.MANDT == T880.MANDT
Consolidation Unit
  • Consolidation Unit
  • Dimension
  • Client
  • P_REPORTEDFINANCIALDATA_RT_01.RBUNIT == TF160.BUNIT
  • P_REPORTEDFINANCIALDATA_RT_01.RDIMEN == TF160.DIMEN
  • P_REPORTEDFINANCIALDATA_RT_01.MANDT == TF160.MANDT
Business Area
  • Business Area
  • Client
  • P_REPORTEDFINANCIALDATA_RT_01.RBUSA == TGSB.GSBER
  • P_REPORTEDFINANCIALDATA_RT_01.MANDT == TGSB.MANDT
Cost Center
  • ?
  • Cost Center
  • Client
  • ?
  • P_REPORTEDFINANCIALDATA_RT_01.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_REPORTEDFINANCIALDATA_RT_01.RCNTR == CSKS.KOSTL
  • P_REPORTEDFINANCIALDATA_RT_01.MANDT == CSKS.MANDT
  • P_REPORTEDFINANCIALDATA_RT_01.[column in domain "DATBI"] == CSKS.DATBI
Dimension
  • Dimension
  • Client
  • P_REPORTEDFINANCIALDATA_RT_01.RDIMEN == TF150.DIMEN
  • P_REPORTEDFINANCIALDATA_RT_01.MANDT == TF150.MANDT
Functional Area
  • Client
  • Functional Area
  • P_REPORTEDFINANCIALDATA_RT_01.MANDT == TFKB.MANDT
  • P_REPORTEDFINANCIALDATA_RT_01.RFAREA == TFKB.FKBER
Source Ledger
  • Ledger
  • Source Ledger
  • Client
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • P_REPORTEDFINANCIALDATA_RT_01.RMVCT == T856.TRTYP
  • P_REPORTEDFINANCIALDATA_RT_01.MANDT == T856.MANDT
Company Code
  • Client
  • Company Code
  • P_REPORTEDFINANCIALDATA_RT_01.MANDT == T001.MANDT
  • P_REPORTEDFINANCIALDATA_RT_01.ROBUKRS == T001.BUKRS
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • P_REPORTEDFINANCIALDATA_RT_01.RTCUR == TCURC.WAERS
  • P_REPORTEDFINANCIALDATA_RT_01.MANDT == TCURC.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_REPORTEDFINANCIALDATA_RT_01.RUNIT == T006.MSEHI
  • P_REPORTEDFINANCIALDATA_RT_01.MANDT == T006.MANDT
Partner Business Area
  • Partner Business Area
  • Client
  • P_REPORTEDFINANCIALDATA_RT_01.SBUSA == TGSB.GSBER
  • P_REPORTEDFINANCIALDATA_RT_01.MANDT == TGSB.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_REPORTEDFINANCIALDATA_RT_01.SEGMENT == FAGL_SEGM.SEGMENT
  • P_REPORTEDFINANCIALDATA_RT_01.MANDT == FAGL_SEGM.MANDT