pp_mrp_read_purchase_req

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 pp_mrp_read_purchase_req.
-- 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: V_MRP_PUR_REQ
-- Parameters: P_MRPElementCategory : delkz

CREATE VIEW pp_mrp_read_purchase_req AS
SELECT
  pur.purchasingdoc AS PurchaseRequisition,
  pur.purchasingdocitem5 AS PurchaseRequisitionItem,
  pur.material AS Material,
  pur.purchasingdocitemcategory AS MaterialProcurementCategory,
  case $parameters.P_MRPElementCategory when 'BA' then pur.plant when 'U2' then pur.supplyingplant else '' end as MRPPlant AS supplyingplantelseendasMRPPlant,
  case $parameters.P_MRPElementCategory when 'BA' then pur.supplyingplant when 'U2' then pur.plant else '' end as SupplyingPlant AS plantelseendasSupplyingPlant,
  marc.dispo AS MRPController,
  case pur.fixedvendor when '' then pur.vendor else pur.fixedvendor end as Vendor AS fixedvendorendasVendor,
  mdt.fix01 AS PurchaseRequisitionIsFixed,
  pur.purchasinginforecord AS PurchasingInfoRecord,
  pur.purchasingorganization AS PurchasingOrganization,
  pur.purchasinggroup AS PurchasingGroup,
  pur.purchasingdocumentorderqty AS TotalQuantity,
  pur.orderedquantity AS OrderedQuantity,
  (pur.purchasingdocumentorderqty - pur.orderedquantity) AS OpenQuantity,
  pur.purchasingdocorderqtyunit AS PurchaseRequisitionUnit,
  case pur.materialidbyvendor when '' then eina.idnlf else pur.materialidbyvendor end as VendorMaterial AS materialidbyvendorendasVendorMaterial,
  pur.inventoryspecialstock AS InventorySpecialStock,
  pur.salesdocument AS SalesDocument,
  pur.salesdocumentitem AS SalesDocumentItem,
  vbk.auart AS SalesDocumentType,
  vbp.matnr AS SalesDocumentItemMaterial,
  vbk.kunnr AS Customer,
  pur.wbselementinternalid AS WBSElementInternalID,
  psp.posid AS WBSElement,
  psp.post1 AS WBSDescription,
  psp.vernr AS WBSResponsiblePerson,
  psp.verna AS WBSResponsiblePersonName,
  psp.psphi AS ProjectInternalID,
  pro.pspid AS Project,
  pro.post1 AS ProjectDescription,
  pur.materialplanneddeliverydurn AS MaterialPlannedDeliveryDurn,
  pur.materialgoodsreceiptduration AS MaterialGoodsReceiptDuration,
  cast(pur.purchasingdocreleasedate as abap.dats) AS ReleaseDate,
  pur.deliverydate AS DeliveryDate,
  pur.purchaseoutlineagreement AS PurchaseOutlineAgreement,
  pur.purchaseoutlineagreementitem AS PurchaseOutlineAgreementItem,
  eine.norbm AS StandardPurchaseOrderQuantity,
  eine.bstma AS MaximumPurchaseOrderQuantity,
  eine.minbm AS MinimumPurchaseOrderQuantity,
  eine.staging_time AS MaterialStagingDuration,
  eine.rdprf AS PurchaseOrderRoundingProfile,
  marc.bstfe AS MaterialFixedLotSizeQuantity,
  marc.bstmi AS MaterialMinLotSizeQuantity,
  marc.bstma AS MaterialMaxLotSizeQuantity,
  marc.bstrf AS MaterialRoundingQuantity,
  marc.rdprf AS MaterialRoundingProfile
FROM e_mrp_purchase_docs AS pur
LEFT OUTER JOIN eina ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN eine ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN marc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mdtb AS mdt ON /* join condition not captured in parsed metadata */
INNER JOIN proj AS pro ON /* join condition not captured in parsed metadata */
INNER JOIN vbap AS vbp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_Purchaserequisitionitem AS MM_PURREQN_ITEM_EXT ON PurchaseRequisition = MM_PURREQN_ITEM_EXT.PurchaseRequisition AND PurchaseRequisitionItem = MM_PURREQN_ITEM_EXT.PurchaseRequisitionItem  -- association [0..1]
;