I_MRPOutlineAgreementMPN

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_MRPOutlineAgreementMPN.
-- 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: IMRPOUTLAGRMPN

CREATE VIEW I_MRPOutlineAgreementMPN AS
SELECT
  oa.PurchasingDocument AS PurchasingDocument,
  oa.PurchasingDocumentItem AS PurchasingDocumentItem,
  oa.Material AS Material,
  oa.ManufacturerMaterial AS ManufacturerMaterial,
  purgorgplant.Plant AS Plant,
  oa.ValidityStartDate AS ValidityStartDate,
  oa.ValidityEndDate AS ValidityEndDate,
  oa.PreferredSupplier AS PreferredSupplier,
  cast('0' as abap.dec(13,3)) AS MaterialMinLotSizeQuantity,
  cast('9999999999' as abap.dec(13,3))as MaterialMaxLotSizeQuantity AS dec133asMaterialMaxLotSizeQuantity,
  'X' AS IsRelevantForAutomSrcg,
  oa.PurchasingObjectCategory AS PurchasingObjectCategory,
  oa.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  oa.PurchasingOrganization AS PurchasingOrganization,
  oa.PurchasingGroup AS PurchasingGroup,
  oa.StorageLocation AS StorageLocation,
  oa.ProductVariantGroup AS ProductVariantGroup,
  oa.PurgDocSupplyingPlant AS PurgDocSupplyingPlant,
  oa.IssuingOrReceivingStorageLoc AS IssuingOrReceivingStorageLoc,
  oa.IssgOrRcvgStkIdfgSpclStkType AS IssgOrRcvgStkIdfgSpclStkType,
  oa.GoodsReceiptDuration AS GoodsReceiptDuration,
  oa.PlannedDeliveryDuration AS PlannedDeliveryDuration,
  coalesce(oa.ProductionVersion, '') AS ProductionVersion,
  oa.PurgDocReceivingSupplier AS PurgDocReceivingSupplier,
  oa.SupplierIsSubcontractor AS SupplierIsSubcontractor,
  oa.ScheduleAgreementHasReleaseDoc AS ScheduleAgreementHasReleaseDoc,
  oa.RoundingProfile AS RoundingProfile,
  oa.AccountAssignmentCategory AS AccountAssignmentCategory,
  oa.ConsumptionPosting AS ConsumptionPosting,
  oa.PlndOrderReplnmtElmntType AS PlndOrderReplnmtElmntType,
  case when purgorgplant.IsRefOrg = 'X' then cast('X' as abap.char( 1 )) else cast('' as abap.char( 1 )) end as PurgDocHasRefPurchasingOrg AS char1endasPurgDocHasRefPurchasingOrg,
  oa.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  oa.LeadingSalesOrder AS LeadingSalesOrder,
  oa.LeadingSalesOrderItem AS LeadingSalesOrderItem,
  oa.WBSElementInternalID AS WBSElementInternalID,
  ampl.datub AS ItemValidityStartDate,
  ampl.datuv AS ItemValidityEndDate,
  oa.PurgDocHasPlant AS PurgDocHasPlant
FROM I_MRPOutlineAgreement AS oa
;