P_PLANDATA_NRL_05

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_PLANDATA_NRL_05.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PPLANDNRL_05
-- Parameters: P_CreationDateTimeRgFr : timestamp, P_CreationDateTimeRgTo : timestamp

CREATE VIEW P_PLANDATA_NRL_05 AS
SELECT
  Source.SubItemCategory AS SubItemCategory,
  Source.SubItem AS SubItem,
  Source.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  Source.BaseUnit AS BaseUnit,
  Source.QuantityInBaseUnit AS QuantityInBaseUnit,
  Source.BreakdownCategory AS BreakdownCategory,
  Source.FinancialStatementItem AS FinancialStatementItem,
  Source.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  Source.ConsolidationDimension AS ConsolidationDimension,
  Source.ConsolidationUnit AS ConsolidationUnit,
  Source.ConsolidationVersion AS ConsolidationVersion,
  Source.ConsolidationLedger AS ConsolidationLedger,
  Source.DocumentEntryIsInGroupCurrency AS DocumentEntryIsInGroupCurrency,
  Source.FiscalPeriod AS FiscalPeriod,
  Source.FiscalYear AS FiscalYear,
  Source.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  Source.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  Source.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  Source.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  Source.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Source.ConsolidationUnitLocalCurrency AS ConsolidationUnitLocalCurrency,
  Source.AmountInCompanyCodeCurrency AS AmountInLocalCurrency,
  Source.GroupCurrency AS GroupCurrency,
  Source.AmountInGlobalCurrency AS AmountInGroupCurrency
FROM P_PLANDATA_NRL_04
;