MRP_REQ_NOTE

Transparent Table Application Table
29 Fields 2 CDS Views

Requests and Notes for MRP Cockpit

MRP_REQ_NOTE is an SAP database table in S/4HANA. Requests and Notes for MRP Cockpit. It contains 29 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_MRPRequestNote view from EXTENSION MRP Change RequestNote - Extension
I_MRPRequestNote view from BASIC MRP Request Note

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY request_id guid GUID
createdon timestamp Time Stamp
crenam syuname User Name
updatedon timestamp Time Stamp
updnam syuname User Name
matnr matnr Material
type delkz MRP Elmnt Ind.
mrpplant werks_d Plant
mrparea berid MRP Area
mrpplanningsegmenttype plaab MRP segment
mrpplanningsegmentnumber planr Plng Segmnt No.
mrpelement del12 MRP element number
mrpelementitem delps MRP elemnt item
mrpelementscheduleline delet Scheduling
status mrprequeststatus Change Req. Status
vendorstatus mrprequestvendorstatus Vendor's Response
vendor lifnr Supplier
vendorplant werks_d Plant
materialgoodsreceiptduration webaz GR proc. time
note mrpreqnote Change Request Note
mrpcrstate mrpcrstate Sending Status
distributedon timestamp Time Stamp
attachment xflag X Flag
prioritycode mrp_cr_priority_code Priority
reasoncode mrp_cr_reason_code Reason Code
rejectioncode mrp_cr_rejection_code Rejection Code
costofchange costofchange Cost of Change
currencykey waers Currency

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.

-- Requests and Notes for MRP Cockpit
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MRP_REQ_NOTE (
    MANDT,                         -- Client [mandt]
    REQUEST_ID,                    -- GUID [guid]
    CREATEDON,                     -- Time Stamp [timestamp]
    CRENAM,                        -- User Name [syuname]
    UPDATEDON,                     -- Time Stamp [timestamp]
    UPDNAM,                        -- User Name [syuname]
    MATNR,                         -- Material [matnr]
    TYPE,                          -- MRP Elmnt Ind. [delkz]
    MRPPLANT,                      -- Plant [werks_d]
    MRPAREA,                       -- MRP Area [berid]
    MRPPLANNINGSEGMENTTYPE,        -- MRP segment [plaab]
    MRPPLANNINGSEGMENTNUMBER,      -- Plng Segmnt No. [planr]
    MRPELEMENT,                    -- MRP element number [del12]
    MRPELEMENTITEM,                -- MRP elemnt item [delps]
    MRPELEMENTSCHEDULELINE,        -- Scheduling [delet]
    STATUS,                        -- Change Req. Status [mrprequeststatus]
    VENDORSTATUS,                  -- Vendor's Response [mrprequestvendorstatus]
    VENDOR,                        -- Supplier [lifnr]
    VENDORPLANT,                   -- Plant [werks_d]
    MATERIALGOODSRECEIPTDURATION,  -- GR proc. time [webaz]
    NOTE,                          -- Change Request Note [mrpreqnote]
    MRPCRSTATE,                    -- Sending Status [mrpcrstate]
    DISTRIBUTEDON,                 -- Time Stamp [timestamp]
    ATTACHMENT,                    -- X Flag [xflag]
    PRIORITYCODE,                  -- Priority [mrp_cr_priority_code]
    REASONCODE,                    -- Reason Code [mrp_cr_reason_code]
    REJECTIONCODE,                 -- Rejection Code [mrp_cr_rejection_code]
    COSTOFCHANGE,                  -- Cost of Change [costofchange]
    CURRENCYKEY,                   -- Currency [waers]
    PRIMARY KEY (MANDT, REQUEST_ID)
);

Learn More