I_MPPurchasingSourceItemWD

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_MPPurchasingSourceItemWD.
-- 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: IMPPRSRCITMWD

CREATE VIEW I_MPPurchasingSourceItemWD AS
SELECT
  Document.SourceListRecord AS SourceListRecord,
  Document.Plant AS Plant,
  Document.Material AS Material,
  Document.Plant AS PlantForEdit,
  Document.Material AS MaterialForEdit,
  Document.SourceListRecord AS SourceListRecordForEdit,
  Document.CreationDate AS CreationDate,
  Document.CreatedByUserName AS CreatedByUserName,
  Document.ValidityStartDate AS ValidityStartDate,
  Document.ValidityEndDate AS ValidityEndDate,
  Document.Supplier AS Supplier,
  Document.SupplierIsFixed AS SupplierIsFixed,
  Document.PurchaseOutlineAgreement AS PurchaseOutlineAgreement,
  Document.PurchaseOutlineAgreementItem AS PurchaseOutlineAgreementItem,
  Document.PurOutlineAgreementIsFixed AS PurOutlineAgreementIsFixed,
  Document.SupplyingPlant AS SupplyingPlant,
  Document.IssgPlantIsFixed AS IssgPlantIsFixed,
  Document.ManufacturerMaterial AS ManufacturerMaterial,
  Document.SourceOfSupplyIsBlocked AS SourceOfSupplyIsBlocked,
  case when Document.PurchaseOutlineAgreement <> '' then cast ( concat(LTRIM(PurchaseOutlineAgreement,'0') , concat('/', LTRIM(PurchaseOutlineAgreementItem , '0') ) ) as abap.sstring( 16 ) ) else ' ' end as OutlineAgreement AS sstring16elseendasOutlineAgreement,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  Document.SourceListRecordCategory AS SourceListRecordCategory,
  Document.MRPSourcingControl AS MRPSourcingControl,
  Document.MRPArea AS MRPArea,
  case when Document.MRPSourcingControl <> '' and Document.MRPArea <> '' then cast ( concat(Document.MRPSourcingControl , concat('/', Document.MRPArea ) ) as abap.sstring( 16 ) ) else ' ' end as UnitOfMeasureName AS sstring16elseendasUnitOfMeasureName,
  Document.OrderQuantityUnit AS OrderQuantityUnit,
  Document.OriginSystem AS OriginSystem,
  Document.InventorySpecialStockType AS InventorySpecialStockType,
  Document.LastChangeDateTime AS LastChangeDateTime
FROM P_MPPurchasingSourceItem AS Document
LEFT OUTER JOIN I_MPPurchasingSourceWD AS _MPPurchasingSourceWD ON _MPPurchasingSourceWD.Material = Material AND _MPPurchasingSourceWD.Plant = Plant  -- association [1..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 [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_PurchaseContract AS _PurchaseContract ON _PurchaseContract.PurchaseContract = PurchaseOutlineAgreement  -- association [0..1]
LEFT OUTER JOIN I_PurchaseContractItem AS _PurchaseContractItem ON _PurchaseContractItem.PurchaseContract = PurchaseOutlineAgreement AND _PurchaseContractItem.PurchaseContractItem = PurchaseOutlineAgreementItem  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _SupplyingPlant ON _SupplyingPlant.Plant = SupplyingPlant  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON _PurchasingOrganization.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_MaterialPlanningUsage_SL AS _MaterialPlanningUsage_SL ON _MaterialPlanningUsage_SL.MRPSourcingControl = MRPSourcingControl  -- association [0..1]
LEFT OUTER JOIN I_MPPurchasingSourceStatus AS _MPPurchasingSourceStatus ON _MPPurchasingSourceStatus.SourceListStatus = SourceListStatus  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = OrderQuantityUnit  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON _LogicalSystem.LogicalSystem = OriginSystem  -- 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]
LEFT OUTER JOIN E_MPPurchasingSourceItem AS _MPPurSourceDraftExtension ON Material = _MPPurSourceDraftExtension.Material AND Plant = _MPPurSourceDraftExtension.Plant AND SourceListRecord = _MPPurSourceDraftExtension.SourceListRecord  -- association [0..1]
;