P_MRPChangeRequest

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 P_MRPChangeRequest.
-- 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: PMRPCHANGEREQ

CREATE VIEW P_MRPChangeRequest AS
SELECT
  ChangeRequestUUID,
  MRPPlant,
  Material,
  MRPArea,
  CreationDateTime,
  CreatedByUser,
  GoodsReceiptDuration,
  MRPElement,
  MRPElementItem,
  MRPElementScheduleLine,
  MRPPlanningSegment,
  MRPPlanningSegmentType,
  ChangeRequestNote,
  SolutionRequestStatus,
  _MRPRequestStatusText[1: Language = $session.system_language ].DomainText AS SolutionRequestStatusName,
  ChangeRequestType,
  ChangedDateTime,
  LastChangedByUser,
  Supplier,
  SupplierPlant,
  MRPRequestSupplierResponse,
  _MRPRequestSupplierText[1: Language = $session.system_language ].DomainText AS MRPRequestSupplierResponseText,
  _Material.MaterialBaseUnit AS MaterialBaseUnit,
  _ChangeRequestLineOriginal.OpenQuantity AS OpenQuantity,
  _ChangeRequestLineOriginal.TotalQuantity AS OriginalTotalQuantity,
  _ChangeRequestLineRequested.OpenQuantity AS MRPElementChangedOpenQuantity,
  _ChangeRequestLineRequested.TotalQuantity AS TotalQuantity,
  _ChangeRequestLineOriginal.DeliveryDate AS MRPElementAvailyOrRqmtDate,
  _ChangeRequestLineRequested.DeliveryDate AS MRPElementChgAvailyOrRqmtDate,
  case when _PurchaseOrder._PurchasingGroup.PurchasingGroupName is not null then _PurchaseOrder._PurchasingGroup.PurchasingGroupName else case when SupplierPlant is not null then _SupplierPlant._Supplier.SupplierName else _Supplier.SupplierName end end as ContactPerson AS SupplierNameendendasContactPerson,
  _Material._BaseUnit AS _BaseUnit,
  _PurchaseOrder.CompanyCode AS CompanyCode,
  MRPRequestPriority,
  _MRPCRPriority.MRPRequestPriorityName AS MRPRequestPriorityName,
  MRPRequestReason,
  _MRPCRReason.MRPRequestReasonName AS MRPRequestReasonName,
  MRPRequestRejection,
  _MRPCRRejection.MRPRequestRejectionName AS MRPRequestRejectionName,
  MRPRequestDistributionStatus,
  _MRPRequestSendText[1: Language = $session.system_language ].DomainText AS MRPChangeReqSendingStatusName,
  MRPRequestDistributedDateTime,
  MRPRequestCostOfChangeAmount,
  Currency,
  HasAttachment
FROM I_MRPRequestNote
LEFT OUTER JOIN I_MRPChangeRequestLine AS _ChangeRequestLineOriginal ON ChangeRequestUUID = _ChangeRequestLineOriginal.ChangeRequestUUID AND _ChangeRequestLineOriginal.ChangeRequestLineType = '01'  -- association [0..1]
LEFT OUTER JOIN I_MRPChangeRequestLine AS _ChangeRequestLineRequested ON ChangeRequestUUID = _ChangeRequestLineRequested.ChangeRequestUUID AND _ChangeRequestLineRequested.ChangeRequestLineType = '02'  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _SupplierPlant ON SupplierPlant = _SupplierPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrder ON MRPElement = _PurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MRPRequestRejection AS _MRPCRRejection ON MRPRequestRejection = _MRPCRRejection.MRPRequestRejection  -- association [0..1]
LEFT OUTER JOIN I_MRPRequestReason AS _MRPCRReason ON MRPRequestReason = _MRPCRReason.MRPRequestReason  -- association [0..1]
LEFT OUTER JOIN I_MRPRequestPriority AS _MRPCRPriority ON MRPRequestPriority = _MRPCRPriority.MRPRequestPriority  -- association [0..1]
LEFT OUTER JOIN I_MRPRequestStatusText AS _MRPRequestStatusText ON SolutionRequestStatus = _MRPRequestStatusText.DomainValue  -- association [0..*]
LEFT OUTER JOIN I_MRPRequestSupplierText AS _MRPRequestSupplierText ON MRPRequestSupplierResponse = _MRPRequestSupplierText.DomainValue  -- association [0..*]
LEFT OUTER JOIN I_MRPRequestSendingStatusText AS _MRPRequestSendText ON MRPRequestDistributionStatus = _MRPRequestSendText.DomainValue  -- association [0..*]
;