I_BillingPlanDueDateAnalytics

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 I_BillingPlanDueDateAnalytics.
-- 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: ISDBLNPLNDDTEANA

CREATE VIEW I_BillingPlanDueDateAnalytics AS
SELECT
  SOI.SalesDocument AS SalesDocument,
  SOI.SalesDocumentItem AS SalesDocumentItem,
  FPLT.BillingPlan AS BillingPlan,
  FPLT.BillingPlanItem AS BillingPlanItem,
  SOI.SalesOrganization AS SalesOrganization,
  SDDocumentCategory,
  Product,
  SOI.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  SOI.InternationalArticleNumber AS InternationalArticleNumber,
  SOI.ProductHierarchyNode AS ProductHierarchyNode,
  SOI.MaterialGroup AS MaterialGroup,
  SOI.ProductGroup AS ProductGroup,
  SOI.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  SOI.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  SOI.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  SOI.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  SOI.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  SOI.ProfitCenter AS ProfitCenter,
  SalesOffice,
  FPLT.BillingPlanRelatedBillgStatus AS BillingPlanRelatedBillgStatus,
  SOI.BaseUnit AS BaseUnit,
  SOI._Product AS _Product,
  SOI._ProductText AS _ProductText,
  SOI._MaterialGroup AS _MaterialGroup,
  SOI._ProductGroup AS _ProductGroup,
  SOI._OriginallyRequestedMaterial AS _OriginallyRequestedMaterial
FROM I_SalesDocumentItem AS SOI
INNER JOIN I_SalesDocItemBillingPlanItem AS FPLT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _StatisticsCurrency ON StatisticsCurrency = _StatisticsCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
;