P_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 P_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: PMPPRSRCITM

CREATE VIEW P_MPPurchasingSourceItem AS
SELECT
  I_MPPurchasingSourceItem.Material AS Material,
  I_MPPurchasingSourceItem.Plant AS Plant,
  I_MPPurchasingSourceItem.SourceListRecord AS SourceListRecord,
  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.SupplierIsFixed AS SupplierIsFixed,
  I_MPPurchasingSourceItem.PurchaseOutlineAgreement AS PurchaseOutlineAgreement,
  I_MPPurchasingSourceItem.PurchaseOutlineAgreementItem AS PurchaseOutlineAgreementItem,
  I_MPPurchasingSourceItem.PurOutlineAgreementIsFixed AS PurOutlineAgreementIsFixed,
  I_MPPurchasingSourceItem.SupplyingPlant AS SupplyingPlant,
  I_MPPurchasingSourceItem.IssgPlantIsFixed AS IssgPlantIsFixed,
  I_MPPurchasingSourceItem.ManufacturerMaterial AS ManufacturerMaterial,
  I_MPPurchasingSourceItem.SourceOfSupplyIsBlocked AS SourceOfSupplyIsBlocked,
  I_MPPurchasingSourceItem.SourceOfSupplyIsFixed AS SourceOfSupplyIsFixed,
  I_MPPurchasingSourceItem.SourceListStatus AS SourceListStatus,
  I_MPPurchasingSourceItem.PurchasingOrganization AS PurchasingOrganization,
  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.LastChangeDateTime AS LastChangeDateTime,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  I_MPPurchasingSourceItem._MPPurchasingSource AS _MPPurchasingSource,
  I_MPPurchasingSourceItem._Material AS _Material,
  I_MPPurchasingSourceItem._Plant AS _Plant,
  I_MPPurchasingSourceItem._Supplier AS _Supplier,
  I_MPPurchasingSourceItem._PurchaseContract AS _PurchaseContract,
  I_MPPurchasingSourceItem._PurchaseContractItem AS _PurchaseContractItem,
  I_MPPurchasingSourceItem._SupplyingPlant AS _SupplyingPlant,
  I_MPPurchasingSourceItem._PurchasingOrganization AS _PurchasingOrganization,
  I_MPPurchasingSourceItem._MaterialPlanningUsage_SL AS _MaterialPlanningUsage_SL,
  I_MPPurchasingSourceItem._MPPurchasingSourceStatus AS _MPPurchasingSourceStatus,
  I_MPPurchasingSourceItem._UnitOfMeasure AS _UnitOfMeasure,
  I_MPPurchasingSourceItem._LogicalSystem AS _LogicalSystem
FROM I_MPPurchasingSourceItem
;