P_PLANDATA_NRL_01

Select from ACDOCP; Consolidation Unit; Period and Year | view: PPLANDNRL_01 | Extraction: Not supported | Component: S/4HANA Financial Consolidation, Core Processing
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
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
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
FiscalYearPeriod Fiscal Year + Fiscal Period FINS_FYEARPERIOD
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
  • Client
  • Business Area
  • P_PLANDATA_NRL_01.MANDT == TGSB.MANDT
  • P_PLANDATA_NRL_01.BUSINESSAREA == TGSB.GSBER
Dimension
  • Client
  • Dimension
  • P_PLANDATA_NRL_01.MANDT == TF150.MANDT
  • P_PLANDATA_NRL_01.CONSOLIDATIONDIMENSION == TF150.DIMEN
Cost Center
  • Cost Center
  • ?
  • Client
  • ?
  • P_PLANDATA_NRL_01.COSTCENTER == CSKS.KOSTL
  • P_PLANDATA_NRL_01.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_PLANDATA_NRL_01.MANDT == CSKS.MANDT
  • P_PLANDATA_NRL_01.[column in domain "DATBI"] == CSKS.DATBI
Transaction type
  • Transaction type
  • Client
  • P_PLANDATA_NRL_01.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • P_PLANDATA_NRL_01.MANDT == T856.MANDT
FS Item Mapping Version
  • FS Item Mapping Version
  • Client
  • P_PLANDATA_NRL_01.FSITEMMAPPINGVERSION == TF23A.IMPVS
  • P_PLANDATA_NRL_01.MANDT == TF23A.MANDT
Functional Area
  • Client
  • Functional Area
  • P_PLANDATA_NRL_01.MANDT == TFKB.MANDT
  • P_PLANDATA_NRL_01.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Chart of Accounts
  • G/L Account
  • Client
  • P_PLANDATA_NRL_01.REFERENCECHARTOFACCOUNTS == SKA1.KTOPL
  • P_PLANDATA_NRL_01.GLACCOUNT == SKA1.SAKNR
  • P_PLANDATA_NRL_01.MANDT == SKA1.MANDT
Group Currency of Consolidation Version
  • Client
  • Group Currency of Consolidation Version
  • P_PLANDATA_NRL_01.MANDT == TCURC.MANDT
  • P_PLANDATA_NRL_01.GROUPCURRENCY == TCURC.WAERS
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_PLANDATA_NRL_01.PARTNERCOMPANY == T880.RCOMP
  • P_PLANDATA_NRL_01.MANDT == T880.MANDT
Profit Center
  • Profit Center
  • ?
  • Client
  • ?
  • P_PLANDATA_NRL_01.PROFITCENTER == CEPC.PRCTR
  • P_PLANDATA_NRL_01.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_PLANDATA_NRL_01.MANDT == CEPC.MANDT
  • P_PLANDATA_NRL_01.[column in domain "DATBI"] == CEPC.DATBI
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_PLANDATA_NRL_01.REFERENCECHARTOFACCOUNTS == T004.KTOPL
  • P_PLANDATA_NRL_01.MANDT == T004.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_PLANDATA_NRL_01.SEGMENT == FAGL_SEGM.SEGMENT
  • P_PLANDATA_NRL_01.MANDT == FAGL_SEGM.MANDT