I_MRPREQUESTNOTE

CDS View
7 Fields 6 CDS Views

MRP Request Note

I_MRPREQUESTNOTE is a CDS View in S/4HANA. MRP Request Note. It contains 7 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_MRPChangeReqNewProposal view_entity from COMPOSITE List of MRP Change Request that are New Proposals
I_MRPChangeRequest view from COMPOSITE MRP Change Request
I_MRPChangeRequestCalcValue view from COMPOSITE Calculated Values for DD MRP
I_MRPChangeRequestNote view_entity from TRANSACTIONAL MRP Change Request Note
I_MRPDiscardedChangeRequest view from TRANSACTIONAL List of MRP Change Request that were discarded
P_MRPChangeRequest view from COMPOSITE MRP Change Request

Fields (7)

KeyField CDS FieldsUsed in Views
KEY ChangeRequestUUID ChangeRequestUUID 3
KEY MRPElement MRPElement 1
KEY MRPElementItem MRPElementItem 1
KEY MRPElementScheduleLine MRPElementScheduleLine 1
ChangeRequestNote ChangeRequestNote 1
Material Material 1
SolutionRequestStatus SolutionRequestStatus 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.

-- MRP Request Note
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MRPREQUESTNOTE (
    CHANGEREQUESTUUID,
    MRPELEMENT,
    MRPELEMENTITEM,
    MRPELEMENTSCHEDULELINE,
    CHANGEREQUESTNOTE,
    MATERIAL,
    SOLUTIONREQUESTSTATUS,
    PRIMARY KEY (CHANGEREQUESTUUID, MRPELEMENT, MRPELEMENTITEM, MRPELEMENTSCHEDULELINE)
);

Learn More