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 from COMPOSITE
I_MRPChangeRequest view from COMPOSITE MRP Change Request
I_MRPChangeRequestCalcValue view from COMPOSITE
I_MRPChangeRequestNote view from TRANSACTIONAL
I_MRPDiscardedChangeRequest view from TRANSACTIONAL
P_MRPChangeRequest view from COMPOSITE

Fields (7)

KeyField CDS FieldsUsed in Views
KEY ChangeRequestUUID ChangeRequestUUID 2
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