R_PurchasingSourceListItemTP

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 R_PurchasingSourceListItemTP.
-- 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.

CREATE VIEW R_PurchasingSourceListItemTP AS
SELECT
  I_MPPurchasingSourceItem.SourceListRecord AS SourceListRecord,
  I_MPPurchasingSourceItem.Material AS Material,
  I_MPPurchasingSourceItem.Plant AS Plant,
  I_MPPurchasingSourceItem.Material AS MaterialForEdit,
  I_MPPurchasingSourceItem.Plant AS PlantForEdit,
  I_MPPurchasingSourceItem.SourceListRecord AS SourceListRecordForEdit,
  I_MPPurchasingSourceItem.CreationDate AS CreationDate,
  I_MPPurchasingSourceItem.CreatedByUserName AS CreatedByUserName,
  I_MPPurchasingSourceItem.ValidityStartDate AS ValidityStartDate,
  I_MPPurchasingSourceItem.ValidityEndDate AS ValidityEndDate,
  I_MPPurchasingSourceItem.Supplier AS Supplier,
  I_MPPurchasingSourceItem.PurchaseOutlineAgreement AS PurchaseOutlineAgreement,
  I_MPPurchasingSourceItem.PurchaseOutlineAgreementItem AS PurchaseOutlineAgreementItem,
  I_MPPurchasingSourceItem.PurchasingOrganization AS PurchasingOrganization,
  I_MPPurchasingSourceItem.SupplyingPlant AS SupplyingPlant,
  I_MPPurchasingSourceItem.SupplierIsFixed AS SupplierIsFixed,
  I_MPPurchasingSourceItem.PurOutlineAgreementIsFixed AS PurOutlineAgreementIsFixed,
  I_MPPurchasingSourceItem.IssgPlantIsFixed AS IssgPlantIsFixed,
  I_MPPurchasingSourceItem.ManufacturerMaterial AS ManufacturerMaterial,
  I_MPPurchasingSourceItem.SourceOfSupplyIsBlocked AS SourceOfSupplyIsBlocked,
  I_MPPurchasingSourceItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_MPPurchasingSourceItem.SourceListRecordCategory AS SourceListRecordCategory,
  I_MPPurchasingSourceItem.MRPSourcingControl AS MRPSourcingControl,
  I_MPPurchasingSourceItem.MRPArea AS MRPArea,
  I_MPPurchasingSourceItem.OrderQuantityUnit AS OrderQuantityUnit,
  I_MPPurchasingSourceItem.OriginSystem AS OriginSystem,
  I_MPPurchasingSourceItem.InventorySpecialStockType AS InventorySpecialStockType,
  I_MPPurchasingSourceItem._PurchaseContract AS _PurchaseContract,
  I_MPPurchasingSourceItem._PurchaseContractItem AS _PurchaseContractItem,
  I_MPPurchasingSourceItem._LogicalSystem AS _LogicalSystem,
  I_MPPurchasingSourceItem._PurchasingOrganization AS _PurchasingOrganization,
  I_MPPurchasingSourceItem._UnitOfMeasure AS _UnitOfMeasure,
  _Supplier.SupplierName AS SupplierName,
  _Plant.PlantName AS PlantName,
  _MaterialText.MaterialName AS MaterialName,
  _SupplyingPlant.PlantName AS SupplyingPlantName,
  I_MPPurchasingSourceItem.LastChangeDateTime AS LastChangeDateTime
FROM I_MPPurchasingSourceItem
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 ON MRPSourcingControl = _MaterialPlanningUsage.MRPSourcingControl  -- association [0..1]
LEFT OUTER JOIN I_MPPurchasingSourceStatus AS _PurchasingSourceStatus ON SourceListStatus = _PurchasingSourceStatus.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]
;