I_MRPPurchaseOrder

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_MRPPurchaseOrder.
-- 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: IMRPPURCHORDER
-- Parameters: P_MRPElementCategory : mrpelementcategory

CREATE VIEW I_MRPPurchaseOrder AS
SELECT
  Item.PurchasingDocument AS PurchaseOrder,
  Item.PurchasingDocumentItem AS PurchaseOrderItem,
  Line.ScheduleLine AS ScheduleLine,
  cast( Item.PurchasingDocumentItem as abap.int4 ) AS MRPElementItem,
  Item.Material AS Material,
  Item._Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  Head.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  Head.PurchasingDocumentType AS PurchasingDocumentType,
  Item.PurchasingDocumentItemCategory AS MaterialProcurementCategory,
  _PurgDocumentItemCategory._Text[1: Language = $session.system_language].PurgDocItemCategoryName AS MaterialProcurementCatName,
  case $parameters.P_MRPElementCategory when 'BE' then Item.Plant when 'U1' then Head.SupplyingPlant when 'LE' then Item.Plant else '' end as MRPPlant AS PlantelseendasMRPPlant,
  case $parameters.P_MRPElementCategory when 'BE' then Head.SupplyingPlant when 'U1' then Item.Plant when 'LE' then Head.SupplyingPlant else '' end as SupplyingPlant AS SupplyingPlantelseendasSupplyingPlant,
  Prod.MRPResponsible AS MRPController,
  Head.Supplier AS Supplier,
  Item.SupplierMaterialNumber AS SupplierMaterialNumber,
  Item.InventorySpecialStockType AS InventorySpecialStockType,
  Head.LastChangeDateTime AS LastChangeDateTime,
  Acct.SalesOrder AS SalesDocument,
  Acct.SalesOrderItem AS SalesDocumentItem,
  Acct._SalesOrder.SalesOrderType AS SalesDocumentType,
  Acct._SalesOrderItem.Material AS SalesOrderItemMaterial,
  Acct._SalesOrderItem._Material._Text[1: Language = $session.system_language ].MaterialName AS SalesOrderItemMaterialName,
  Acct._SalesOrder.SoldToParty AS Customer,
  Acct._SalesOrder._SoldToParty.BPCustomerName AS CustomerName,
  Acct._SalesOrder._SoldToParty.BPCustomerFullName AS CustomerFullName,
  Acct._SalesOrder._SoldToParty._StandardAddress.PhoneNumber AS PhoneNumber,
  Acct.WBSElementInternalID AS WBSElementInternalID,
  WBSElement.WBSElement AS WBSElement,
  WBSElement.WBSDescription AS WBSDescription,
  WBSElement._WBSElementLangBsdDesc[1: Language = $session.system_language ].WBSElementLangBsdDescription AS WBSElementDescription,
  WBSElement.WBSElementObject AS WBSElementObject,
  WBSElement.ResponsiblePerson AS ResponsiblePerson,
  WBSElement.ResponsiblePersonName AS ResponsiblePersonName,
  WBSElement.ProjectInternalID AS ProjectInternalID,
  WBSElement._Project.ProjectWithCodingMask AS Project,
  WBSElement._Project.ProjectDescription AS ProjectDescription,
  WBSElement._Project.ResponsiblePerson AS ProjectResponsiblePerson,
  WBSElement._Project.ResponsiblePersonName AS ProjectResponsiblePersonName,
  Item.PurchasingInfoRecord AS PurchasingInfoRecord,
  Head.PurchasingOrganization AS PurchasingOrganization,
  Head.PurchasingGroup AS PurchasingGroup,
  Head._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  Head._PurchasingGroup.EmailAddress AS PurchasingGroupEmailAddress,
  Item.PlannedDeliveryDurationInDays AS MaterialPlannedDeliveryDurn,
  Item.GoodsReceiptDurationInDays AS MaterialGoodsReceiptDuration,
  Line.ScheduleLineOrderDate AS ScheduleLineOrderDate,
  Line.ScheduleLineDeliveryDate AS DeliveryDate,
  Line.ProductAvailabilityDate AS ProductAvailabilityDate,
  Item.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  Item.IsOrderAcknRqd AS IsOrderAcknRqd,
  Item.PurchaseContract AS PurchaseOutlineAgreement,
  Item.PurchaseContractItem AS PurchaseOutlineAgreementItem,
  Item.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  Item.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  Prod.FixedLotSizeQuantity AS MaterialFixedLotSizeQuantity,
  Prod.MinimumLotSizeQuantity AS MaterialMinLotSizeQuantity,
  Prod.MaximumLotSizeQuantity AS MaterialMaxLotSizeQuantity,
  Prod.LotSizeRoundingQuantity AS LotSizeRoundingQuantity,
  Prod.RoundingProfile AS MaterialRoundingProfile,
  Item.BaseUnit AS BaseUnit,
  _BaseUnit.UnitOfMeasure AS UnitOfMeasure,
  _BaseUnit.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  _BaseUnit.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
  _BaseUnit._Text[1: Language = $session.system_language ].UnitOfMeasureCommercialName AS UnitOfMeasureCommercialName,
  Item.OrderQuantityUnit AS PurchaseOrderItemQuantityUnit,
  Item.OrderQuantity AS PurchaseOrderItemQuantity,
  Line.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  Line.GoodsReceiptQuantity AS GoodsReceiptQuantity,
  Line.ScheduleLineOpenQuantity AS ScheduleLineOpenQuantity,
  '000' AS QuickViewCategory,
  $parameters.P_MRPElementCategory AS MRPElementCategory,
  Head._Supplier AS _Supplier,
  Head._PurchasingGroup AS _PurchasingGroup,
  Acct._SalesOrder AS _SalesOrder,
  Acct._SalesOrderItem AS _SalesOrderItem,
  Item._Material AS _Material,
  Item._PurchaseContract AS _PurchaseContract,
  Item._PurchaseContractItem AS _PurchaseContractItem,
  Item._PurchasingDocument AS _PurchasingDocument,
  Head._PurchasingDocumentType AS _PurchasingDocumentType,
  Item._PurchasingInfoRecord AS _PurchasingInfoRecord,
  Head._PurchasingOrganization AS _PurchasingOrganization,
  Acct._SalesOrder._SalesOrderType AS _SalesOrderType,
  Acct._SalesOrder._SoldToParty AS _SoldToParty,
  Acct._WBSElementByInternalKey AS _WBSElementByInternalKey,
  Head._PurchasingDocumentCategory AS _PurchasingDocumentCategory
FROM I_PurchasingDocument AS Head
INNER JOIN I_PurchasingDocumentItem AS Item ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurgDocScheduleLine AS Line ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurgDocAccountAssignment AS Acct ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurgInfoRecdOrgPlantData AS PIR ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurgInfoRecdOrgPlantData AS PIR2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductSupplyPlanning AS Prod ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElement AS WBSElement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON MaterialProcurementCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON PurchaseOrderItemQuantityUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
;