P_ReportedFinancialData_RT_04

Get Subitem (TF100, TF103A, TF110) | view: PREPFINDRT_04 | Extraction: Not supported | Component: Consolidation
Tables used: SCAL_TT_YEAR, ACDOCA, RTC_PULL_REQ, FINCS_FSITEM, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, T000, TF164, T881, TF165, TF168, TF200, TF110, TF103A, FINSC_LEDGER_REP, FINSC_FISC_DATE, TFIN010, 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
sitem_send SAP Consolidation Integration: Sender Field for Subitem Show values
curr_group_send Source for Group Currency Key Figure Show values
curr_local_send Sender for Local Currency ID Show values
Column Name Description Domain name
itgrp Breakdown Category FC_ITGRP
sityp Fixed value for a subitem category-like characteristic CHAR10
subit Functional Area FKBER
docln_fin Ledger Journal Entry Item DOCLN6
ritclg Consolidation Chart of Accounts FC_ITCLG
rbuptr null
rvers Consolidation Version FC_RVERS
gjahr Fiscal Year GJAHR
belnr Journal Entry BELNR
docln Ledger Journal Entry Item DOCLN6
rldnr Ledger RLDNR
poper Fiscal Period POPER
ryear Fiscal Year GJAHR
fiscal_year_period Fiscal Year + Fiscal Period FINS_FYEARPERIOD
ritem Financial Statement Item FC_ITEM
activ null
refdocnr Reference document number AWREF
refryear Fiscal Year GJAHR
refactiv null
aworg Reference Document Context AWORG
Master Data Relations Join Conditions
Reference Document Type P_REPORTEDFINANCIALDATA_RT_04.AWTYP == TTYP.AWTYP
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_REPORTEDFINANCIALDATA_RT_04.BLART == T003.BLART
  • P_REPORTEDFINANCIALDATA_RT_04.MANDT == T003.MANDT
Logical System P_REPORTEDFINANCIALDATA_RT_04.LOGSYS == TBDLS.LOGSYS
Profit Center
  • ?
  • Client
  • ?
  • Profit Center
  • P_REPORTEDFINANCIALDATA_RT_04.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_REPORTEDFINANCIALDATA_RT_04.MANDT == CEPC.MANDT
  • P_REPORTEDFINANCIALDATA_RT_04.[column in domain "DATBI"] == CEPC.DATBI
  • P_REPORTEDFINANCIALDATA_RT_04.PRCTR == CEPC.PRCTR
G/L Account
  • G/L Account
  • Client
  • Company Code
  • P_REPORTEDFINANCIALDATA_RT_04.RACCT == SKB1.SAKNR
  • P_REPORTEDFINANCIALDATA_RT_04.MANDT == SKB1.MANDT
  • P_REPORTEDFINANCIALDATA_RT_04.ROBUKRS == SKB1.BUKRS
Consolidation Unit
  • Consolidation Unit
  • Client
  • Dimension
  • P_REPORTEDFINANCIALDATA_RT_04.RBUNIT == TF160.BUNIT
  • P_REPORTEDFINANCIALDATA_RT_04.MANDT == TF160.MANDT
  • P_REPORTEDFINANCIALDATA_RT_04.RDIMEN == TF160.DIMEN
Business Area
  • Client
  • Business Area
  • P_REPORTEDFINANCIALDATA_RT_04.MANDT == TGSB.MANDT
  • P_REPORTEDFINANCIALDATA_RT_04.RBUSA == TGSB.GSBER
Cost Center
  • ?
  • Client
  • ?
  • Cost Center
  • P_REPORTEDFINANCIALDATA_RT_04.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_REPORTEDFINANCIALDATA_RT_04.MANDT == CSKS.MANDT
  • P_REPORTEDFINANCIALDATA_RT_04.[column in domain "DATBI"] == CSKS.DATBI
  • P_REPORTEDFINANCIALDATA_RT_04.RCNTR == CSKS.KOSTL
Dimension
  • Client
  • Dimension
  • P_REPORTEDFINANCIALDATA_RT_04.MANDT == TF150.MANDT
  • P_REPORTEDFINANCIALDATA_RT_04.RDIMEN == TF150.DIMEN
Functional Area
  • Client
  • Functional Area
  • P_REPORTEDFINANCIALDATA_RT_04.MANDT == TFKB.MANDT
  • P_REPORTEDFINANCIALDATA_RT_04.RFAREA == TFKB.FKBER
Local Currency
  • Local Currency
  • Client
  • P_REPORTEDFINANCIALDATA_RT_04.RLCURR == TCURC.WAERS
  • P_REPORTEDFINANCIALDATA_RT_04.MANDT == TCURC.MANDT
Source Ledger
  • Client
  • Ledger
  • Source Ledger
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • P_REPORTEDFINANCIALDATA_RT_04.MANDT == T856.MANDT
  • P_REPORTEDFINANCIALDATA_RT_04.RMVCT == T856.TRTYP
Company Code
  • Client
  • Company Code
  • P_REPORTEDFINANCIALDATA_RT_04.MANDT == T001.MANDT
  • P_REPORTEDFINANCIALDATA_RT_04.ROBUKRS == T001.BUKRS
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • P_REPORTEDFINANCIALDATA_RT_04.MANDT == TCURC.MANDT
  • P_REPORTEDFINANCIALDATA_RT_04.RTCUR == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_REPORTEDFINANCIALDATA_RT_04.MANDT == T006.MANDT
  • P_REPORTEDFINANCIALDATA_RT_04.RUNIT == T006.MSEHI
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_REPORTEDFINANCIALDATA_RT_04.SEGMENT == FAGL_SEGM.SEGMENT
  • P_REPORTEDFINANCIALDATA_RT_04.MANDT == FAGL_SEGM.MANDT