I_MRPChangeRequestList

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_MRPChangeRequestList.
-- 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: IMRPCRLIST

CREATE VIEW I_MRPChangeRequestList AS
SELECT
  MRPElement,
  PurOrdList.MRPElementItem AS MRPElementItem,
  MRPElementScheduleLine,
  MRPPlant,
  PurOrdList.Material AS Material,
  PurOrdList.MRPArea AS MRPArea,
  _MPRExceptions.ExceptionMessageID AS ExceptionMessageID,
  _MPRExceptions.ExceptionMessageText AS ExceptionMessageText,
  _MRPPurOrdSchLine.OpenQuantity AS OrderOpenQuantity,
  _MPRExceptions.MRPElementReschedulingDate AS ChangeRequestProposedDate,
  _MPRExceptions.MRPExcptnPrpslDataSource AS MRPExcptnPrpslDataSource,
  _MPRExceptions.ExcessStockQty AS ChangeRequestProposedQty,
  _MRPChangeReq.ChangeRequestUUID AS ChangeRequestUUID,
  _MRPChangeReq.SupplierPlant AS SupplierPlant,
  _MaterialPlant.MRPController AS MRPController,
  _MRPChangeReq.CreatedByUser AS CreatedByUser,
  _MRPChangeReq.TotalQuantity AS TotalQuantity,
  _MRPChangeReq.SolutionRequestStatus AS SolutionRequestStatus,
  _MRPChangeReq.SolutionRequestStatusName AS SolutionRequestStatusName,
  _MRPChangeReq.MRPRequestSupplierResponse AS MRPRequestSupplierResponse,
  _MRPChangeReq.MRPRequestSupplierResponseText AS MRPRequestSupplierResponseText,
  _MRPChangeReq.MRPElementAvailyOrRqmtDate AS MRPElementAvailyOrRqmtDate,
  _MRPChangeReq.MRPElementChgAvailyOrRqmtDate AS MRPElementChgAvailyOrRqmtDate,
  _MRPChangeReq.ChangeRequestNote AS ChangeRequestNote,
  _MRPChangeReq.MRPPlanningSegment AS MRPPlanningSegment,
  _MRPChangeReq.MRPRequestRejection AS MRPRequestRejection,
  _MRPChangeReq.MRPRequestRejectionName AS MRPRequestRejectionName,
  _MRPChangeReq.MRPRequestDistributionStatus AS MRPChangeReqSendingStatus,
  _MRPChangeReq.MRPChangeReqSendingStatusName AS MRPChangeReqSendingStatusName,
  _MRPChangeReq.MRPRequestDistributedDateTime AS MRPChangeReqSendingDateTime,
  _MRPPurOrdSchLine._CompanyCode.CompanyCodeName AS SenderCompanyCodeName,
  _MRPChangeReq.MRPRequestCostOfChangeAmount AS MRPRequestCostOfChangeAmount,
  _MRPChangeReq.Currency AS Currency,
  _MRPChangeReq.HasAttachment AS HasAttachment,
  _MRPChangeReq.AuthorizationGroup AS AuthorizationGroup,
  _MRPChangeReq.CreationDateTime AS CreationDateTime,
  _MRPChangeReq.ChangedDateTime AS ChangedDateTime,
  _MRPPurOrdSchLine.QuantityUnit AS QuantityUnit,
  _MRPPurOrdSchLine.DeliveryDate AS DeliveryDate,
  _MRPPurOrdSchLine.DeliveryTime AS DeliveryTime,
  _MRPPurOrdSchLine.MaterialName AS MaterialName,
  _MRPPurOrdSchLine.Supplier AS Supplier,
  _MRPPurOrdSchLine._Supplier.SupplierName AS SupplierName,
  _MRPPurOrdSchLine.PurchasingGroup AS PurchasingGroup,
  _MRPPurOrdSchLine.PurchasingOrganization AS PurchasingOrganization,
  _MRPPurOrdSchLine.StorageLocation AS StorageLocation,
  _MRPPurOrdSchLine.CompanyCode AS CompanyCode,
  _MRPPurOrdSchLine.BaseUnit AS BaseUnit,
  _MRPPurOrdSchLine.IncotermsClassification AS IncotermsClassification,
  _MRPPurOrdSchLine.GoodsReceiptDurationInDays AS GoodsReceiptDurationInDays,
  _MRPPurOrdSchLine._PurchaseOrderQuantityUnit AS _PurchaseOrderQuantityUnit,
  _MRPPurOrdSchLine._CompanyCode AS _CompanyCode,
  _MRPPurOrdSchLine._Supplier AS _Supplier
FROM I_MRPPurchaseOrderList AS PurOrdList
INNER JOIN I_MRPPurchaseOrderScheduleLine AS _MRPPurOrdSchLine ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MRPExceptionList AS _MPRExceptions ON MRPElement = _MPRExceptions.MRPElement AND MRPElementItem = _MPRExceptions.MRPElementItem AND MRPElementScheduleLine = _MPRExceptions.MRPElementScheduleLine AND MRPPlant = _MPRExceptions.MRPPlant AND Material = _MPRExceptions.Material  -- association [1..1]
LEFT OUTER JOIN I_MaterialPlant AS _MaterialPlant ON Material = _MaterialPlant.Material AND MRPPlant = _MaterialPlant.Plant  -- association [1..1]
LEFT OUTER JOIN P_MRPChangeRequest AS _MRPChangeReq ON MRPElement = _MRPChangeReq.MRPElement AND MRPElementItem = _MRPChangeReq.MRPElementItem AND MRPElementScheduleLine = _MRPChangeReq.MRPElementScheduleLine AND Material = _MRPChangeReq.Material AND _MRPChangeReq.SolutionRequestStatus != '03' AND _MRPChangeReq.SolutionRequestStatus != 'C1' AND _MRPChangeReq.SolutionRequestStatus != '02'  -- association [0..1]
;