P_PlanData_RT_03

Account mapping and Partner Consolidation Unit | view: PPLANDATA_03 | Extraction: Not supported | Component: Consolidation
Tables used: SCAL_TT_YEAR, ACDOCP, RTC_PULL_REQ, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, T000, TF164, T881, TF165, TF200, 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
CnsldtnUnitLocalCrcySource Sender for Local Currency ID Show values
Column Name Description Domain name
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_03.BUSINESSAREA == TGSB.GSBER
  • P_PLANDATA_RT_03.MANDT == TGSB.MANDT
Dimension
  • Client
  • Dimension
  • P_PLANDATA_RT_03.MANDT == TF150.MANDT
  • P_PLANDATA_RT_03.CONSOLIDATIONDIMENSION == TF150.DIMEN
Consolidation Unit
  • Client
  • Dimension
  • Consolidation Unit
  • P_PLANDATA_RT_03.MANDT == TF160.MANDT
  • P_PLANDATA_RT_03.CONSOLIDATIONDIMENSION == TF160.DIMEN
  • P_PLANDATA_RT_03.CONSOLIDATIONUNIT == TF160.BUNIT
Local Currency
  • Local Currency
  • Client
  • P_PLANDATA_RT_03.CONSOLIDATIONUNITLOCALCURRENCY == TCURC.WAERS
  • P_PLANDATA_RT_03.MANDT == TCURC.MANDT
Cost Center
  • ?
  • Client
  • ?
  • Cost Center
  • P_PLANDATA_RT_03.[column in domain "DATBI"] == CSKS.DATBI
  • P_PLANDATA_RT_03.MANDT == CSKS.MANDT
  • P_PLANDATA_RT_03.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_PLANDATA_RT_03.COSTCENTER == CSKS.KOSTL
Transaction type
  • Client
  • Transaction type
  • P_PLANDATA_RT_03.MANDT == T856.MANDT
  • P_PLANDATA_RT_03.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Functional Area
  • Functional Area
  • Client
  • P_PLANDATA_RT_03.FUNCTIONALAREA == TFKB.FKBER
  • P_PLANDATA_RT_03.MANDT == TFKB.MANDT
G/L Account
  • G/L Account
  • ?
  • Client
  • P_PLANDATA_RT_03.GLACCOUNT == SKA1.SAKNR
  • P_PLANDATA_RT_03.[column in domain "KTOPL"] == SKA1.KTOPL
  • P_PLANDATA_RT_03.MANDT == SKA1.MANDT
Profit Center
  • ?
  • Client
  • ?
  • Profit Center
  • P_PLANDATA_RT_03.[column in domain "DATBI"] == CEPC.DATBI
  • P_PLANDATA_RT_03.MANDT == CEPC.MANDT
  • P_PLANDATA_RT_03.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_PLANDATA_RT_03.PROFITCENTER == CEPC.PRCTR
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting