I_MRPProcurementSOS

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_MRPProcurementSOS.
-- 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: IMRPPROCSOS

CREATE VIEW I_MRPProcurementSOS AS
SELECT
  OA.Material AS Material,
  OA.ManufacturerMaterial AS ManufacturerMaterial,
  OA.Plant AS Plant,
  OA.ValidityStartDate AS ValidityStartDate,
  OA.PreferredSupplier AS PreferredSupplier,
  OA.ValidityEndDate AS ValidityEndDate,
  OA.MaterialMinLotSizeQuantity AS MaterialMinLotSizeQuantity,
  OA.MaterialMaxLotSizeQuantity AS MaterialMaxLotSizeQuantity,
  OA.IsRelevantForAutomSrcg AS IsRelevantForAutomSrcg,
  cast('' as infnr) AS ActivePurchasingInfoRecord,
  OA.PurchasingDocument AS PurchasingDocument,
  OA.PurchasingDocumentItem AS PurchasingDocumentItem,
  OA.PurchasingObjectCategory AS PurchasingObjectCategory,
  OA.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  OA.PurchasingOrganization AS PurchasingOrganization,
  OA.PurchasingGroup AS PurchasingGroup,
  cast('' as esokz) AS PurchasingInfoRecordCategory,
  OA.StorageLocation AS StorageLocation,
  OA.PurgDocSupplyingPlant AS PurgDocSupplyingPlant,
  OA.IssuingOrReceivingStorageLoc AS IssuingOrReceivingStorageLoc,
  OA.IssgOrRcvgStkIdfgSpclStkType AS IssgOrRcvgStkIdfgSpclStkType,
  OA.AccountAssignmentCategory AS AccountAssignmentCategory,
  OA.ConsumptionPosting AS ConsumptionPosting,
  OA.PlndOrderReplnmtElmntType AS PlndOrderReplnmtElmntType,
  OA.GoodsReceiptDuration AS GoodsReceiptDuration,
  OA.PlannedDeliveryDuration AS PlannedDeliveryDuration,
  OA.ProductionVersion AS ProductionVersion,
  OA.PurgDocReceivingSupplier AS PurgDocReceivingSupplier,
  OA.SupplierIsSubcontractor AS SupplierIsSubcontractor,
  OA.ScheduleAgreementHasReleaseDoc AS ScheduleAgreementHasReleaseDoc,
  OA.RoundingProfile AS RoundingProfile,
  OA.ProductVariantGroup AS ProductVariantGroup,
  OA.PurgDocHasRefPurchasingOrg AS PurgDocHasRefPurchasingOrg,
  OA.LeadingSalesOrder AS LeadingSalesOrder,
  OA.LeadingSalesOrderItem AS LeadingSalesOrderItem,
  OA.WBSElementInternalID AS WBSElementInternalID,
  InfoRecord.PurgDocHasPlant AS PurgDocHasPlant
FROM I_MRPOutlineAgreementMPN AS OA
-- UNION ALL with additional select branch(es): I_MRPPurchasingInfoRecordMPN
;