P_SourcesOfSupply

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_SourcesOfSupply.
-- 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: PSOS

CREATE VIEW P_SourcesOfSupply AS
SELECT
  ekko.Supplier AS Supplier,
  ekpo.Plant AS Plant,
  ekko.PurchasingOrganization AS PurchasingOrganization,
  ekpo.Material AS Material,
  ekpo.ManufacturerMaterial AS ManufacturerMaterial,
  _matText.MaterialName AS MaterialName,
  ekpo.MaterialGroup AS MaterialGroup,
  ekko.PurchasingDocument AS SourceDocument,
  ekpo.PurchasingDocumentItem AS SourceDocumentItem,
  ekko.PurchasingGroup AS PurchasingGroup,
  ekko.PurchasingDocumentType AS PurchasingDocumentType,
  ekpo.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  cast ( '' as esokz ) AS PurInfoRecordCat,
  cast( 0 as quotp) AS QuotaInPercent,
  ekko.CreationDate AS CreationDate,
  ekko.ValidityStartDate AS ValidityStartDate,
  ekko.ValidityEndDate AS ValidityEndDate,
  0 AS SourceOfSupplyIsFixed,
  0 AS SourceOfSupplyIsBlocked,
  0 AS QuotaArrangementIsFixed,
  StorageLocation,
  case when einaEine.MaterialGroup = '' then _Material.MaterialGroup else einaEine.MaterialGroup end as MaterialGroup AS MaterialGroupendasMaterialGroup,
  cast('infrec' as vdm_purchasingsourcetype) AS PurchasingSourceType,
  cast ( '' as dzeord) AS SourceListRecord
FROM I_PurchasingDocument AS ekko
INNER JOIN I_PurchasingDocumentItem AS ekpo ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurgQuotaArrgmtItem AS equp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SupplierMaster AS _lfa1 ON ekko.Supplier = _lfa1.Supplier  -- association [1..1]
LEFT OUTER JOIN I_SupplierCompany AS _lfb1 ON ekko.Supplier = _lfb1.Supplier AND ekko.CompanyCode = _lfb1.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_MaterialText AS _matText ON Material = _matText.Material AND _matText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocument AS _PurchDocumentExtension ON SourceDocument = _PurchDocumentExtension.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _PurchDocumentItemExtension ON SourceDocument = _PurchDocumentItemExtension.PurchasingDocument AND SourceDocumentItem = _PurchDocumentItemExtension.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON _Material.Material = Material  -- association [0..1]
LEFT OUTER JOIN E_PurchasingInforecord AS _PurchasingInforecordExtension ON SourceDocument = _PurchasingInforecordExtension.PurchasingInfoRecord  -- association [1..1]
LEFT OUTER JOIN E_PurgInfoRecdOrgPlantData AS _PurInfRecOrgPlanDataExtension ON SourceDocument = _PurInfRecOrgPlanDataExtension.PurchasingInfoRecord AND PurchasingOrganization = _PurInfRecOrgPlanDataExtension.PurchasingOrganization AND SourceDocumentItem = _PurInfRecOrgPlanDataExtension.PurchasingInfoRecordCategory AND Plant = _PurInfRecOrgPlanDataExtension.Plant  -- association [1..1]
LEFT OUTER JOIN E_MPPurchasingSourceItem AS _MPPurchSourceItemExtension ON Material = _MPPurchSourceItemExtension.Material AND Plant = _MPPurchSourceItemExtension.Plant  -- association [1..1]
LEFT OUTER JOIN I_Material AS _mat ON Material = _mat.Material  -- association [0..1]
-- UNION with additional select branch(es): I_PurgInfoRecordWithOrgData, I_MPPurchasingSourceItem, I_PurgQuotaArrgmt
;