P_CanceledDocWthGRIRFlagNotSet

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_CanceledDocWthGRIRFlagNotSet.
-- 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: PDOCGRCANCELLED
-- Parameters: P_StartDate : vdm_validitystart, P_EndDate : vdm_validityend

CREATE VIEW P_CanceledDocWthGRIRFlagNotSet AS
SELECT
  PurchDoc.PurchasingDocument AS PurchasingDocument,
  PurchDoc.PurchasingDocumentItem AS PurchasingDocumentItem,
  PurchDoc.PurchasingDocumentItemUniqueID AS PurchasingDocumentItemUniqueID,
  PurchDoc.Supplier AS Supplier,
  PurchDoc.PurchasingOrganization AS PurchasingOrganization,
  PurchDoc.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  PurchDoc.PurchasingGroup AS PurchasingGroup,
  PurchDoc.Material AS Material,
  PurchDoc.MaterialGroup AS MaterialGroup,
  PurchDoc.Plant AS Plant,
  NetPriceAmount,
  DocumentCurrency
FROM P_PurchDocWthGRIRFlagNotSet
INNER JOIN P_MatDocHavingRetOrCancel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
;