I_MRPCHANGEREQUESTLIST

CDS View
45 Fields 1 CDS Views

List of MRP Change Requests

I_MRPCHANGEREQUESTLIST is a CDS View in S/4HANA. List of MRP Change Requests. It contains 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_MRPChangeRequestList view_entity from CONSUMPTION List of MRP Change Requests

Fields (45)

KeyField CDS FieldsUsed in Views
KEY Material Material 1
KEY MRPElement MRPElement 1
KEY MRPElementItem MRPElementItem 1
KEY MRPElementScheduleLine MRPElementScheduleLine 1
KEY MRPPlant MRPPlant 1
_PurchaseOrderQuantityUnit _PurchaseOrderQuantityUnit 1
_Supplier _Supplier 1
AuthorizationGroup AuthorizationGroup 1
ChangedDateTime ChangedDateTime 1
ChangeRequestNote ChangeRequestNote 1
ChangeRequestProposedDate ChangeRequestProposedDate 1
ChangeRequestProposedQty ChangeRequestProposedQty 1
ChangeRequestUUID ChangeRequestUUID 1
CompanyCode CompanyCode 1
CreationDateTime CreationDateTime 1
Currency Currency 1
DeliveryDate DeliveryDate 1
ExceptionMessageID ExceptionMessageID 1
ExceptionMessageText ExceptionMessageText 1
GoodsReceiptDurationInDays GoodsReceiptDurationInDays 1
MaterialName MaterialName 1
MRPArea MRPArea 1
MRPChangeReqSendingDateTime MRPChangeReqSendingDateTime 1
MRPChangeReqSendingStatus MRPChangeReqSendingStatus 1
MRPController MRPController 1
MRPElementChgAvailyOrRqmtDate MRPElementChgAvailyOrRqmtDate 1
MRPExcptnPrpslDataSource MRPExcptnPrpslDataSource 1
MRPPlanningSegment MRPPlanningSegment 1
MRPRequestCostOfChangeAmount MRPRequestCostOfChangeAmount 1
MRPRequestPriority MRPRequestPriority 1
MRPRequestPriorityName MRPRequestPriorityName 1
MRPRequestReason MRPRequestReason 1
MRPRequestReasonName MRPRequestReasonName 1
MRPRequestRejection MRPRequestRejection 1
MRPRequestRejectionName MRPRequestRejectionName 1
MRPRequestSupplierResponse MRPRequestSupplierResponse 1
MRPRequestSupplierResponseText MRPRequestSupplierResponseText 1
OrderOpenQuantity OrderOpenQuantity 1
QuantityUnit QuantityUnit 1
SenderCompanyCodeName SenderCompanyCodeName 1
SolutionRequestStatusName SolutionRequestStatusName 1
Supplier Supplier 1
SupplierName SupplierName 1
SupplierPlant SupplierPlant 1
TotalQuantity TotalQuantity 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- List of MRP Change Requests
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MRPCHANGEREQUESTLIST (
    MATERIAL,
    MRPELEMENT,
    MRPELEMENTITEM,
    MRPELEMENTSCHEDULELINE,
    MRPPLANT,
    _PURCHASEORDERQUANTITYUNIT,
    _SUPPLIER,
    AUTHORIZATIONGROUP,
    CHANGEDDATETIME,
    CHANGEREQUESTNOTE,
    CHANGEREQUESTPROPOSEDDATE,
    CHANGEREQUESTPROPOSEDQTY,
    CHANGEREQUESTUUID,
    COMPANYCODE,
    CREATIONDATETIME,
    CURRENCY,
    DELIVERYDATE,
    EXCEPTIONMESSAGEID,
    EXCEPTIONMESSAGETEXT,
    GOODSRECEIPTDURATIONINDAYS,
    MATERIALNAME,
    MRPAREA,
    MRPCHANGEREQSENDINGDATETIME,
    MRPCHANGEREQSENDINGSTATUS,
    MRPCONTROLLER,
    MRPELEMENTCHGAVAILYORRQMTDATE,
    MRPEXCPTNPRPSLDATASOURCE,
    MRPPLANNINGSEGMENT,
    MRPREQUESTCOSTOFCHANGEAMOUNT,
    MRPREQUESTPRIORITY,
    MRPREQUESTPRIORITYNAME,
    MRPREQUESTREASON,
    MRPREQUESTREASONNAME,
    MRPREQUESTREJECTION,
    MRPREQUESTREJECTIONNAME,
    MRPREQUESTSUPPLIERRESPONSE,
    MRPREQUESTSUPPLIERRESPONSETEXT,
    ORDEROPENQUANTITY,
    QUANTITYUNIT,
    SENDERCOMPANYCODENAME,
    SOLUTIONREQUESTSTATUSNAME,
    SUPPLIER,
    SUPPLIERNAME,
    SUPPLIERPLANT,
    TOTALQUANTITY,
    PRIMARY KEY (MATERIAL, MRPELEMENT, MRPELEMENTITEM, MRPELEMENTSCHEDULELINE, MRPPLANT)
);

Learn More