P_PLANDATA_NRL_03

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
DocumentEntryIsInGroupCurrency Group Currency is Leading Currency Show values
CnsldtnUnitGroupCrcySource Source for Group Currency Key Figure Show values
CnsldtnUnitLocalCrcySource Source for Local 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
ConsolidationUnit Consolidation Unit FINCS_MD_BUNIT
ConsolidationVersion Version FC_RVERS
ConsolidationLedger Consolidation Ledger FC_RLDNR_CONS
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_NRL_03.BUSINESSAREA == TGSB.GSBER
  • P_PLANDATA_NRL_03.MANDT == TGSB.MANDT
Dimension
  • Dimension
  • Client
  • P_PLANDATA_NRL_03.CONSOLIDATIONDIMENSION == TF150.DIMEN
  • P_PLANDATA_NRL_03.MANDT == TF150.MANDT
Local Currency
  • Client
  • Local Currency
  • P_PLANDATA_NRL_03.MANDT == TCURC.MANDT
  • P_PLANDATA_NRL_03.CONSOLIDATIONUNITLOCALCURRENCY == TCURC.WAERS
Cost Center
  • Cost Center
  • Client
  • ?
  • ?
  • P_PLANDATA_NRL_03.COSTCENTER == CSKS.KOSTL
  • P_PLANDATA_NRL_03.MANDT == CSKS.MANDT
  • P_PLANDATA_NRL_03.[column in domain "DATBI"] == CSKS.DATBI
  • P_PLANDATA_NRL_03.[column in domain "KOKRS"] == CSKS.KOKRS
Transaction type
  • Client
  • Transaction type
  • P_PLANDATA_NRL_03.MANDT == T856.MANDT
  • P_PLANDATA_NRL_03.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Functional Area
  • Client
  • Functional Area
  • P_PLANDATA_NRL_03.MANDT == TFKB.MANDT
  • P_PLANDATA_NRL_03.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • ?
  • G/L Account
  • Client
  • P_PLANDATA_NRL_03.[column in domain "KTOPL"] == SKA1.KTOPL
  • P_PLANDATA_NRL_03.GLACCOUNT == SKA1.SAKNR
  • P_PLANDATA_NRL_03.MANDT == SKA1.MANDT
Group Currency of Consolidation Version
  • Group Currency of Consolidation Version
  • Client
  • P_PLANDATA_NRL_03.GROUPCURRENCY == TCURC.WAERS
  • P_PLANDATA_NRL_03.MANDT == TCURC.MANDT
Profit Center
  • Client
  • Profit Center
  • ?
  • ?
  • P_PLANDATA_NRL_03.MANDT == CEPC.MANDT
  • P_PLANDATA_NRL_03.PROFITCENTER == CEPC.PRCTR
  • P_PLANDATA_NRL_03.[column in domain "DATBI"] == CEPC.DATBI
  • P_PLANDATA_NRL_03.[column in domain "KOKRS"] == CEPC.KOKRS
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_PLANDATA_NRL_03.MANDT == FAGL_SEGM.MANDT
  • P_PLANDATA_NRL_03.SEGMENT == FAGL_SEGM.SEGMENT