C_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 C_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: CMPPRSRCITM

CREATE VIEW C_Mppurchasingsourceitem AS
SELECT
  I_MPPurchasingSourceItemWD.SourceListRecord AS SourceListRecord,
  I_MPPurchasingSourceItemWD.Material AS Material,
  I_MPPurchasingSourceItemWD.Plant AS Plant,
  I_MPPurchasingSourceItemWD.MaterialForEdit AS MaterialForEdit,
  I_MPPurchasingSourceItemWD.PlantForEdit AS PlantForEdit,
  I_MPPurchasingSourceItemWD.SourceListRecordForEdit AS SourceListRecordForEdit,
  I_MPPurchasingSourceItemWD.CreationDate AS CreationDate,
  I_MPPurchasingSourceItemWD.CreatedByUserName AS CreatedByUserName,
  I_MPPurchasingSourceItemWD.ValidityStartDate AS ValidityStartDate,
  I_MPPurchasingSourceItemWD.ValidityEndDate AS ValidityEndDate,
  I_MPPurchasingSourceItemWD.Supplier AS Supplier,
  I_MPPurchasingSourceItemWD.OutlineAgreement AS OutlineAgreement,
  I_MPPurchasingSourceItemWD.PurchaseOutlineAgreement AS PurchaseOutlineAgreement,
  I_MPPurchasingSourceItemWD.PurchaseOutlineAgreementItem AS PurchaseOutlineAgreementItem,
  I_MPPurchasingSourceItemWD.PurchasingOrganization AS PurchasingOrganization,
  I_MPPurchasingSourceItemWD.SupplyingPlant AS SupplyingPlant,
  I_MPPurchasingSourceItemWD.SupplierIsFixed AS SupplierIsFixed,
  I_MPPurchasingSourceItemWD.PurOutlineAgreementIsFixed AS PurOutlineAgreementIsFixed,
  I_MPPurchasingSourceItemWD.IssgPlantIsFixed AS IssgPlantIsFixed,
  I_MPPurchasingSourceItemWD.ManufacturerMaterial AS ManufacturerMaterial,
  I_MPPurchasingSourceItemWD.SourceOfSupplyIsBlocked AS SourceOfSupplyIsBlocked,
  I_MPPurchasingSourceItemWD.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_MPPurchasingSourceItemWD.SourceListRecordCategory AS SourceListRecordCategory,
  I_MPPurchasingSourceItemWD.MRPSourcingControl AS MRPSourcingControl,
  I_MPPurchasingSourceItemWD.MRPArea AS MRPArea,
  I_MPPurchasingSourceItemWD.OrderQuantityUnit AS OrderQuantityUnit,
  I_MPPurchasingSourceItemWD.OriginSystem AS OriginSystem,
  I_MPPurchasingSourceItemWD.InventorySpecialStockType AS InventorySpecialStockType,
  I_MPPurchasingSourceItemWD.SourceListStatus AS SourceListStatus,
  I_MPPurchasingSourceItemWD.SourceListStatusCriticality AS SourceListStatusCriticality,
  I_MPPurchasingSourceItemWD._PurchaseContract AS _PurchaseContract,
  I_MPPurchasingSourceItemWD._PurchaseContractItem AS _PurchaseContractItem,
  I_MPPurchasingSourceItemWD._LogicalSystem AS _LogicalSystem,
  I_MPPurchasingSourceItemWD._PurchasingOrganization AS _PurchasingOrganization,
  I_MPPurchasingSourceItemWD._UnitOfMeasure AS _UnitOfMeasure,
  _Supplier.SupplierName AS SupplierName,
  _Plant.PlantName AS PlantName,
  _MaterialText.MaterialName AS MaterialName,
  _SupplyingPlant.PlantName AS SupplyingPlantName
FROM I_MPPurchasingSourceItemWD
LEFT OUTER JOIN C_MPPurchasingSource AS _MPPurchasingSourceWd ON _MPPurchasingSourceWd.Material = Material AND _MPPurchasingSourceWd.Plant = Plant  -- association [1..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON _MaterialText.Material = Material AND _MaterialText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..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_Material AS _Material ON _Material.Material = Material  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _SupplyingPlant ON _SupplyingPlant.Plant = SupplyingPlant  -- association [1..1]
LEFT OUTER JOIN C_PurchaseOutlineAgreementVH AS _PurchaseOutlineAgreement ON _PurchaseOutlineAgreement.PurchasingDocument = PurchaseOutlineAgreement  -- association [0..1]
;