P_PlanData_RT_04

Get Subitem (TF100, TF103A, TF110) | view: PPLANDATA_04 | Extraction: Not supported | Component: Consolidation
Tables used: SCAL_TT_YEAR, ACDOCP, RTC_PULL_REQ, FINCS_FSITEM, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, T000, TF164, T881, TF165, TF200, TF110, TF103A, FINSC_FISC_DATE, FINSC_PERIOD, FINSC_LEDGER_REP, TFIN010, TFIN010
Column Name Description
Column Name Description
💲 Transaction Currency (BalanceTransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInLocalCurrency Amount in Company Code Currency
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGroupCurrency Amount in Global Currency
AmountInGlobalCurrency 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
📏 Unit of Measure (BaseUnit):
QuantityInBaseUnit Valuation 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
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 Consolidation Version FC_RVERS
ConsolidationLedger Ledger RLDNR
FiscalPeriod Fiscal Period POPER
FiscalYear Ledger Fiscal Year GJAHR
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number FIS_RSPM_TSN
FinancialPlanningDataPacket Financial Planning Data Packet Number NUM6
FinancialPlanningEntryItem Financial Planning Entry Item FIS_INT4_UNSIGNED
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • P_PLANDATA_RT_04.BUSINESSAREA == TGSB.GSBER
  • P_PLANDATA_RT_04.MANDT == TGSB.MANDT
Dimension
  • Client
  • Dimension
  • P_PLANDATA_RT_04.MANDT == TF150.MANDT
  • P_PLANDATA_RT_04.CONSOLIDATIONDIMENSION == TF150.DIMEN
Consolidation Unit
  • Client
  • Dimension
  • Consolidation Unit
  • P_PLANDATA_RT_04.MANDT == TF160.MANDT
  • P_PLANDATA_RT_04.CONSOLIDATIONDIMENSION == TF160.DIMEN
  • P_PLANDATA_RT_04.CONSOLIDATIONUNIT == TF160.BUNIT
Local Currency
  • Client
  • Local Currency
  • P_PLANDATA_RT_04.MANDT == TCURC.MANDT
  • P_PLANDATA_RT_04.CONSOLIDATIONUNITLOCALCURRENCY == TCURC.WAERS
Cost Center
  • ?
  • Cost Center
  • ?
  • Client
  • P_PLANDATA_RT_04.[column in domain "DATBI"] == CSKS.DATBI
  • P_PLANDATA_RT_04.COSTCENTER == CSKS.KOSTL
  • P_PLANDATA_RT_04.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_PLANDATA_RT_04.MANDT == CSKS.MANDT
Transaction type
  • Client
  • Transaction type
  • P_PLANDATA_RT_04.MANDT == T856.MANDT
  • P_PLANDATA_RT_04.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Functional Area
  • Functional Area
  • Client
  • P_PLANDATA_RT_04.FUNCTIONALAREA == TFKB.FKBER
  • P_PLANDATA_RT_04.MANDT == TFKB.MANDT
G/L Account
  • ?
  • Client
  • G/L Account
  • P_PLANDATA_RT_04.[column in domain "KTOPL"] == SKA1.KTOPL
  • P_PLANDATA_RT_04.MANDT == SKA1.MANDT
  • P_PLANDATA_RT_04.GLACCOUNT == SKA1.SAKNR
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • P_PLANDATA_RT_04.[column in domain "DATBI"] == CEPC.DATBI
  • P_PLANDATA_RT_04.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_PLANDATA_RT_04.MANDT == CEPC.MANDT
  • P_PLANDATA_RT_04.PROFITCENTER == CEPC.PRCTR
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client