I_MPPurchasingSourceItem

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_MPPurchasingSourceItem.
-- 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: IMPPRSRCITM

CREATE VIEW I_MPPurchasingSourceItem AS
SELECT
  matnr AS Material,
  werks AS Plant,
  zeord AS SourceListRecord,
  erdat AS CreationDate,
  ernam AS CreatedByUserName,
  vdatu AS ValidityStartDate,
  bdatu AS ValidityEndDate,
  lifnr AS Supplier,
  flifn AS SupplierIsFixed,
  ebeln AS PurchaseOutlineAgreement,
  ebelp AS PurchaseOutlineAgreementItem,
  febel AS PurOutlineAgreementIsFixed,
  reswk AS SupplyingPlant,
  fresw AS IssgPlantIsFixed,
  ematn AS ManufacturerMaterial,
  notkz AS SourceOfSupplyIsBlocked,
  cast( '' as flag ) AS SourceOfSupplyIsFixed,
  cast( '' as sl_status ) AS SourceListStatus,
  ekorg AS PurchasingOrganization,
  vrtyp AS PurchasingDocumentCategory,
  eortp AS SourceListRecordCategory,
  autet AS MRPSourcingControl,
  cast('' as abap.char(10) ) AS MRPArea,
  meins AS OrderQuantityUnit,
  logsy AS OriginSystem,
  sobkz AS InventorySpecialStockType,
  LastChangeDateTime
FROM eord
LEFT OUTER JOIN I_MPPurchasingSource AS _MPPurchasingSource ON Material = _MPPurchasingSource.Material AND Plant = _MPPurchasingSource.Plant  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- 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 [0..1]
LEFT OUTER JOIN I_PurchaseContract AS _PurchaseContract ON PurchaseOutlineAgreement = _PurchaseContract.PurchaseContract  -- association [0..1]
LEFT OUTER JOIN I_PurchaseContractItem AS _PurchaseContractItem ON PurchaseOutlineAgreement = _PurchaseContractItem.PurchaseContract AND PurchaseOutlineAgreementItem = _PurchaseContractItem.PurchaseContractItem  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _SupplyingPlant ON SupplyingPlant = _SupplyingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_MaterialPlanningUsage_SL AS _MaterialPlanningUsage_SL ON MRPSourcingControl = _MaterialPlanningUsage_SL.MRPSourcingControl  -- association [0..1]
LEFT OUTER JOIN I_MPPurchasingSourceStatus AS _MPPurchasingSourceStatus ON SourceListStatus = _MPPurchasingSourceStatus.SourceListStatus  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON OrderQuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON OriginSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN E_MPPurchasingSourceItem AS _MPPurchasingSourceExtension ON Material = _MPPurchasingSourceExtension.Material AND Plant = _MPPurchasingSourceExtension.Plant AND SourceListRecord = _MPPurchasingSourceExtension.SourceListRecord  -- association [0..1]
;