P_PLANDATA_NRL_01

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_01.
-- 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_01
-- Parameters: P_CreationDateTimeRgFr : timestamp, P_CreationDateTimeRgTo : timestamp

CREATE VIEW P_PLANDATA_NRL_01 AS
SELECT
  I_CnsldtnUnit_3.ConsolidationDimension AS ConsolidationDimension,
  I_CnsldtnUnit_3.ConsolidationUnit AS ConsolidationUnit,
  I_CompanyCode.ChartOfAccounts AS ReferenceChartOfAccounts,
  I_CnsldtnVersion.ConsolidationVersion AS ConsolidationVersion,
  I_CnsldtnVersion.FSItemMappingVersion AS FSItemMappingVersion,
  I_CnsldtnVersion.ConsolidationLedger AS ConsolidationLedger,
  I_CnsldtnVersion.GroupCurrency AS GroupCurrency,
  I_CnsldtnUnitByTimeVersion.DocumentEntryIsInGroupCurrency AS DocumentEntryIsInGroupCurrency,
  I_CnsldtnUnitByTimeVersion.CnsldtnUnitGroupCrcySource AS CnsldtnUnitGroupCrcySource,
  I_CnsldtnUnitByTimeVersion.CnsldtnUnitLocalCrcySource AS CnsldtnUnitLocalCrcySource,
  Source.FiscalPeriod AS FiscalPeriod,
  Source.LedgerFiscalYear AS FiscalYear,
  cast( Source.FiscalYearPeriod as fins_fyearperiod preserving type ) AS FiscalYearPeriod,
  Source.PartnerCompany AS PartnerCompany,
  Source.TransactionCurrency AS BalanceTransactionCurrency,
  Source.CostSourceUnit AS BaseUnit,
  Source.FinancialTransactionType AS FinancialTransactionType,
  Source.FunctionalArea AS FunctionalArea,
  Source.BusinessArea AS BusinessArea,
  Source.CostCenter AS CostCenter,
  Source.GLAccount AS GLAccount,
  Source.ProfitCenter AS ProfitCenter,
  Source.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Source.AmountInCompanyCodeCurrency AS AmountInLocalCurrency,
  Source.AmountInGlobalCurrency AS AmountInGroupCurrency,
  Source.ValuationQuantity AS QuantityInBaseUnit,
  Source.AmountInFreeDefinedCurrency1 AS osl,
  Source.AmountInFreeDefinedCurrency2 AS vsl,
  Source.AmountInFreeDefinedCurrency3 AS bsl,
  Source.AmountInFreeDefinedCurrency4 AS csl,
  Source.AmountInFreeDefinedCurrency5 AS dsl,
  Source.AmountInFreeDefinedCurrency6 AS esl,
  Source.AmountInFreeDefinedCurrency7 AS fsl,
  Source.AmountInFreeDefinedCurrency8 AS gsl,
  Source.Segment AS Segment,
  Source.CompanyCode AS CompanyCode,
  Source.ChartOfAccounts AS ChartOfAccounts,
  cast( '' as dzuonr ) AS AssignmentReference,
  Source.ControllingArea AS ControllingArea,
  Source.PartnerCostCenter AS PartnerCostCenter,
  Source.PartnerProfitCenter AS PartnerProfitCenter,
  Source.PartnerFunctionalArea AS PartnerFunctionalArea,
  Source.PartnerBusinessArea AS PartnerBusinessArea,
  Source.PartnerSegment AS PartnerSegment,
  Source.OrderID AS OrderID,
  Source.Customer AS Customer,
  cast( '' as lifnr ) AS Supplier,
  Source.Material AS Material,
  Source.MaterialGroup AS MaterialGroup,
  Source.ProductGroup AS ProductGroup,
  Source.Plant AS Plant,
  Source.WBSElement AS WBSElementExternalID,
  Source.WBSElement AS WBSElement,
  Source.Project AS Project,
  Source.BillingDocumentType AS BillingDocumentType,
  Source.SalesOrganization AS SalesOrganization,
  Source.DistributionChannel AS DistributionChannel,
  Source.OrganizationDivision AS OrganizationDivision,
  Source.SoldProduct AS SoldProduct,
  Source.SoldProductGroup AS SoldProductGroup,
  Source.CustomerGroup AS CustomerGroup,
  Source.CustomerSupplierCountry AS CustomerSupplierCountry,
  Source.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  Source.SalesDistrict AS SalesDistrict,
  Source.BillToParty AS BillToParty,
  Source.ShipToParty AS ShipToParty,
  Source.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  Source.WBSElementInternalID AS WBSElementInternalID,
  Source.FinPlngEntryItemCrtnDateTime AS CreationDateTime,
  Source.FinancialManagementArea AS FinancialManagementArea,
  Source.GrantID AS GrantID,
  Source.Fund AS Fund,
  Source.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Source.CompanyCodeCurrency AS CompanyCodeCurrency,
  Source.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  Source.GlobalCurrency AS GlobalCurrency,
  Source.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  Source.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  Source.FinancialPlanningEntryItem AS FinancialPlanningEntryItem
FROM I_FinancialPlanningEntryItem AS Source
INNER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
INNER JOIN I_CnsldtnUnit_3 ON /* join condition not captured in parsed metadata */
INNER JOIN I_CnsldtnUnitByTimeVersion ON /* join condition not captured in parsed metadata */
INNER JOIN I_CnsldtnVersion ON /* join condition not captured in parsed metadata */
;