P_RealTimeRptdFinData_03

Get Subitem (TF100, TF103A, TF110) | view: PREALTIMERFD_03 | Extraction: Not supported | Component: Consolidation
Tables used: SCAL_TT_YEAR, ACDOCA, FINCS_FSITEM, TF200, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, T000, TF164, T881, TF165, TF168, TF110, TF103A, FINSC_LEDGER_REP, FINSC_FISC_DATE, TFIN010, TFIN010
Column Name Description
Column Name Description
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInTransactionCurrency Amount in Balance Transaction Currency
AmountInLocalCurrency Amount in Company Code Currency
AmountInGroupCurrency 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 (BaseUnit):
QuantityInBaseUnit Quantity
Column Name Description
Column Name Description
CnsldtnSubitemSource SAP Consolidation Integration: Sender Field for Subitem Show values
CnsldtnUnitLocalCrcySource Sender for Local Currency ID Show values
CnsldtnUnitGroupCrcySource Source for Group Currency Key Figure Show values
Column Name Description Domain name
SubItemCategory Fixed value for a subitem category-like characteristic CHAR10
SubItem Functional Area FKBER
BreakdownCategory Breakdown Category FC_ITGRP
FinancialStatementItem Financial Statement Item FC_ITEM
ConsolidationChartOfAccounts Consolidation Chart of Accounts FC_ITCLG
PartnerConsolidationUnit null
ConsolidationVersion Version FC_RVERS
ConsolidationLedger Ledger RLDNR
FiscalPeriod Fiscal Period POPER
FiscalYear Fiscal Year GJAHR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
AccountingDocument Journal Entry BELNR
ReferenceFiscalYear Fiscal Year GJAHR
Master Data Relations Join Conditions
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • P_REALTIMERPTDFINDATA_03.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
  • P_REALTIMERPTDFINDATA_03.MANDT == TCURC.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_REALTIMERPTDFINDATA_03.BASEUNIT == T006.MSEHI
  • P_REALTIMERPTDFINDATA_03.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • P_REALTIMERPTDFINDATA_03.BUSINESSAREA == TGSB.GSBER
  • P_REALTIMERPTDFINDATA_03.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • P_REALTIMERPTDFINDATA_03.COMPANYCODE == T001.BUKRS
  • P_REALTIMERPTDFINDATA_03.MANDT == T001.MANDT
Dimension
  • Client
  • Dimension
  • P_REALTIMERPTDFINDATA_03.MANDT == TF150.MANDT
  • P_REALTIMERPTDFINDATA_03.CONSOLIDATIONDIMENSION == TF150.DIMEN
Consolidation Unit
  • Consolidation Unit
  • Client
  • Dimension
  • P_REALTIMERPTDFINDATA_03.CONSOLIDATIONUNIT == TF160.BUNIT
  • P_REALTIMERPTDFINDATA_03.MANDT == TF160.MANDT
  • P_REALTIMERPTDFINDATA_03.CONSOLIDATIONDIMENSION == TF160.DIMEN
Local Currency
  • Client
  • Local Currency
  • P_REALTIMERPTDFINDATA_03.MANDT == TCURC.MANDT
  • P_REALTIMERPTDFINDATA_03.CONSOLIDATIONUNITLOCALCURRENCY == TCURC.WAERS
Cost Center
  • ?
  • ?
  • Cost Center
  • Client
  • P_REALTIMERPTDFINDATA_03.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_REALTIMERPTDFINDATA_03.[column in domain "DATBI"] == CSKS.DATBI
  • P_REALTIMERPTDFINDATA_03.COSTCENTER == CSKS.KOSTL
  • P_REALTIMERPTDFINDATA_03.MANDT == CSKS.MANDT
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • P_REALTIMERPTDFINDATA_03.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • P_REALTIMERPTDFINDATA_03.MANDT == T856.MANDT
Functional Area
  • Functional Area
  • Client
  • P_REALTIMERPTDFINDATA_03.FUNCTIONALAREA == TFKB.FKBER
  • P_REALTIMERPTDFINDATA_03.MANDT == TFKB.MANDT
G/L Account
  • Company Code
  • G/L Account
  • Client
  • P_REALTIMERPTDFINDATA_03.COMPANYCODE == SKB1.BUKRS
  • P_REALTIMERPTDFINDATA_03.GLACCOUNT == SKB1.SAKNR
  • P_REALTIMERPTDFINDATA_03.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Ledger
  • Source Ledger
Profit Center
  • ?
  • ?
  • Profit Center
  • Client
  • P_REALTIMERPTDFINDATA_03.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_REALTIMERPTDFINDATA_03.[column in domain "DATBI"] == CEPC.DATBI
  • P_REALTIMERPTDFINDATA_03.PROFITCENTER == CEPC.PRCTR
  • P_REALTIMERPTDFINDATA_03.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_REALTIMERPTDFINDATA_03.SEGMENT == FAGL_SEGM.SEGMENT
  • P_REALTIMERPTDFINDATA_03.MANDT == FAGL_SEGM.MANDT
Source Ledger
  • Ledger in General Ledger Accounting
  • Ledger
  • Source Ledger
  • Client