I_MRPPurchasingInfoRecordMPN

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_MRPPurchasingInfoRecordMPN.
-- 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: IMRPPURINFRECMPN

CREATE VIEW I_MRPPurchasingInfoRecordMPN AS
SELECT
  ir.Material AS Material,
  ir.ManufacturerMaterial AS ManufacturerMaterial,
  ir.ValidityStartDate AS ValidityStartDate,
  ir.ValidityEndDate AS ValidityEndDate,
  ir.PreferredSupplier AS PreferredSupplier,
  ir.MaterialMinLotSizeQuantity AS MaterialMinLotSizeQuantity,
  ir.MaterialMaxLotSizeQuantity AS MaterialMaxLotSizeQuantity,
  ir.IsRelevantForAutomSrcg AS IsRelevantForAutomSrcg,
  ir.PurgDocNetPriceAmount AS PurgDocNetPriceAmount,
  ir.PurgDocTransactionCurrency AS PurgDocTransactionCurrency,
  ir.PurgDocNetPriceQuantity AS PurgDocNetPriceQuantity,
  ir.ActivePurchasingInfoRecord AS ActivePurchasingInfoRecord,
  ir.PurchasingOrganization AS PurchasingOrganization,
  ir.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  ir.PurchasingGroup AS PurchasingGroup,
  ir.GoodsReceiptDuration AS GoodsReceiptDuration,
  ir.PlannedDeliveryDuration AS PlannedDeliveryDuration,
  ir.ProductionVersion AS ProductionVersion,
  purgorgplant.Plant AS Plant,
  ir.RoundingProfile AS RoundingProfile,
  ir.PurgDocHasPlant AS PurgDocHasPlant,
  ir.ProductVariantGroup AS ProductVariantGroup,
  case when purgorgplant.IsRefOrg = 'X' then cast('X' as abap.char( 1 )) else cast('' as abap.char( 1 )) end as PurgDocHasRefPurchasingOrg AS char1endasPurgDocHasRefPurchasingOrg,
  ampl.mprof AS ManufacturerPartProfile,
  ampl.datuv AS ItemValidityStartDate,
  ampl.datub AS ItemValidityEndDate
FROM I_MRPPurchasingInfoRecord AS ir
;