I_MRPPurReqForHandoverSts

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_MRPPurReqForHandoverSts.
-- 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: IMRPPURREQHNDSTS

CREATE VIEW I_MRPPurReqForHandoverSts AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  ExternalApprovalStatus,
  PreqItem.Material AS Material,
  PreqItem._Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  PreqItem.Plant AS MRPPlant,
  MRPArea,
  SupplyingPlant,
  PreqItem.MRPController AS MRPController,
  PurchaseRequisitionType,
  PurchasingOrganization,
  PurchasingGroup,
  case when _MaterialMRPArea.MRPGroup is not null and _MaterialMRPArea.MRPGroup != '' then _MaterialMRPArea.MRPGroup else _ProdSupPlan.MRPGroup end as MRPGroup AS MRPGroupendasMRPGroup,
  PreqItem.FixedSupplier AS FixedSupplier,
  case PreqItem.FixedSupplier when '' then PreqItem.Supplier else PreqItem.FixedSupplier end as Supplier AS FixedSupplierendasSupplier,
  PreqItem._Supplier.BPSupplierName AS SupplierName,
  PreqItem._Supplier.BPSupplierFullName AS SupplierFullName,
  PreqItem.RequestedQuantity AS RequestedQuantity,
  OrderedQuantity,
  cast(PreqItem.RequestedQuantity - PreqItem.OrderedQuantity as obamg) AS OpenQuantity,
  _ProdSupPlan.MinimumLotSizeQuantity AS MaterialMinLotSizeQuantity,
  _ProdSupPlan.MaximumLotSizeQuantity AS MaterialMaxLotSizeQuantity,
  PreqItem.BaseUnit AS PurchaseRequisitionUnit,
  PreqItem.DeliveryDate AS DeliveryDate,
  PreqItem.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  PreqItem.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  PreqItem.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  PreqItem.PurchasingDocumentItemCategory AS MaterialProcurementCategory,
  _PurgDocumentItemCategory._Text[1: Language = $session.system_language].PurgDocItemCategoryName AS MaterialProcurementCatName,
  _PurReqnAcctAssgmt.SalesOrder AS SalesOrder,
  _PurReqnAcctAssgmt.SalesOrderItem AS SalesOrderItem,
  PreqItem.PurReqnReceivingCustomer AS Customer,
  _Customer.BPCustomerName AS CustomerName,
  IsDeleted,
  _UnitOfMeasure.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
  _UnitOfMeasure.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  LastChangeDateTime,
  StorageLocation
LEFT OUTER JOIN I_ProductSupplyPlanning AS _ProdSupPlan ON _ProdSupPlan.Product = PreqItem.Material AND _ProdSupPlan.Plant = PreqItem.Plant  -- association [0..1]
LEFT OUTER JOIN I_MaterialMRPArea AS _MaterialMRPArea ON Material = _MaterialMRPArea.Material AND MRPPlant = _MaterialMRPArea.Plant AND MRPArea = _MaterialMRPArea.MRPArea AND _MaterialMRPArea.DeletionIndicator = ''  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON MaterialProcurementCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN E_Purchaserequisitionitem AS _Extension ON PurchaseRequisition = _Extension.PurchaseRequisition AND PurchaseRequisitionItem = _Extension.PurchaseRequisitionItem  -- association [0..1]
;