P_PlanData_RT_01

Select from ACDOCP; Consolidation Unit; Period and Year | view: PPLANDATA_01 | Extraction: Not supported | Component: Consolidation
Tables used: ACDOCP, T001, TKA02, T000, T881, TF165, TF200, FINSC_FISC_DATE, FINSC_PERIOD, FINSC_LEDGER_REP, 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
Column Name Description Domain name
ConsolidationVersion Consolidation Version FC_RVERS
ConsolidationLedger Ledger RLDNR
FiscalPeriod Fiscal Period POPER
FiscalYear Ledger Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year + Fiscal Period FINS_FYEARPERIOD
FinPlngEntryItemCrtnDateTime Created On TZNTSTMPS
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
const_zero UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • P_PLANDATA_RT_01.BUSINESSAREA == TGSB.GSBER
  • P_PLANDATA_RT_01.MANDT == TGSB.MANDT
Dimension
  • Dimension
  • Client
  • P_PLANDATA_RT_01.CONSOLIDATIONDIMENSION == TF150.DIMEN
  • P_PLANDATA_RT_01.MANDT == TF150.MANDT
Consolidation Unit
  • Consolidation Unit
  • Dimension
  • Client
  • P_PLANDATA_RT_01.CONSOLIDATIONUNIT == TF160.BUNIT
  • P_PLANDATA_RT_01.CONSOLIDATIONDIMENSION == TF160.DIMEN
  • P_PLANDATA_RT_01.MANDT == TF160.MANDT
Cost Center
  • ?
  • ?
  • Client
  • Cost Center
  • P_PLANDATA_RT_01.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_PLANDATA_RT_01.[column in domain "DATBI"] == CSKS.DATBI
  • P_PLANDATA_RT_01.MANDT == CSKS.MANDT
  • P_PLANDATA_RT_01.COSTCENTER == CSKS.KOSTL
Transaction type
  • Client
  • Transaction type
  • P_PLANDATA_RT_01.MANDT == T856.MANDT
  • P_PLANDATA_RT_01.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Item Mapping Version
  • Item Mapping Version
  • Client
  • P_PLANDATA_RT_01.FSITEMMAPPINGVERSION == TF23A.IMPVS
  • P_PLANDATA_RT_01.MANDT == TF23A.MANDT
Functional Area
  • Client
  • Functional Area
  • P_PLANDATA_RT_01.MANDT == TFKB.MANDT
  • P_PLANDATA_RT_01.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Chart of Accounts
  • G/L Account
  • Client
  • P_PLANDATA_RT_01.REFERENCECHARTOFACCOUNTS == SKA1.KTOPL
  • P_PLANDATA_RT_01.GLACCOUNT == SKA1.SAKNR
  • P_PLANDATA_RT_01.MANDT == SKA1.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_PLANDATA_RT_01.PARTNERCOMPANY == T880.RCOMP
  • P_PLANDATA_RT_01.MANDT == T880.MANDT
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • P_PLANDATA_RT_01.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_PLANDATA_RT_01.[column in domain "DATBI"] == CEPC.DATBI
  • P_PLANDATA_RT_01.MANDT == CEPC.MANDT
  • P_PLANDATA_RT_01.PROFITCENTER == CEPC.PRCTR
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_PLANDATA_RT_01.REFERENCECHARTOFACCOUNTS == T004.KTOPL
  • P_PLANDATA_RT_01.MANDT == T004.MANDT
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting