C_PurgInfoRecordFs

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 C_PurgInfoRecordFs.
-- 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: CPURGINFRECFS

CREATE VIEW C_PurgInfoRecordFs AS
SELECT
  I_PurchasingInfoRecord.PurchasingInfoRecord AS PurchasingInfoRecord,
  I_PurchasingInfoRecord.PurchasingInfoRecordDesc AS PurchasingInfoRecordDesc,
  I_PurchasingInfoRecord.IsDeleted AS IsDeleted,
  I_PurchasingInfoRecord.PurgDocOrderQuantityUnit AS PurgDocOrderQuantityUnit,
  / _Material AS _Material,
  I_PurchasingInfoRecord._Supplier AS _Supplier
FROM I_PurchasingInfoRecord
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN C_PurgInfoRecordOrgLevels AS _PurgInfoRecordOrgLevels ON _PurgInfoRecordOrgLevels.PurchasingInfoRecord = PurchasingInfoRecord  -- association [0..*]
LEFT OUTER JOIN C_PoByPurgInfoRecd AS _PoByPurgInfoRecd ON _PoByPurgInfoRecd.PurchasingInfoRecord = PurchasingInfoRecord  -- association [0..*]
LEFT OUTER JOIN I_SuplrContactCard AS _SupplierHeadOffice ON ( _SupplierHeadOffice.ContactCardType = 'Supplier' AND _SupplierHeadOffice.ContactCardID = Supplier AND _SupplierHeadOffice.ContactCardRole = 'Supplier' )  -- association [1..1]
LEFT OUTER JOIN I_SuplrContactCard AS _ManufacturerName ON ( _ManufacturerName.ContactCardType = 'Supplier' AND _ManufacturerName.ContactCardID = Manufacturer AND _ManufacturerName.ContactCardRole = 'Supplier' )  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON ( I_PurchasingInfoRecord.Material = _Material.Material )  -- association [1..1]
;