MRP_REQ_LINE

Transparent Table Application Table
13 Fields 1 CDS Views

Date and Quantity Values for Change Requests

MRP_REQ_LINE is an SAP database table in S/4HANA. Date and Quantity Values for Change Requests. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MRPChangeRequestLine view from BASIC MRP Change Request Line

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY request_id guid GUID
KEY request_line_id guid GUID
createdon timestamp Time Stamp
crenam syuname User Name
updatedon timestamp Time Stamp
updnam syuname User Name
mrpelementscheduleline delet Scheduling
linetype mrpreqlinetype Line Type
delivery_date mrpreqdatedlv Delivery Date
availability_date mrpreqdateavail Availability Date
open_quant mrpreqquantopen Open Quantity
total_quant mrpreqquanttotal Total Quantity

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.

-- Date and Quantity Values for Change Requests
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MRP_REQ_LINE (
    MANDT,                   -- Client [mandt]
    REQUEST_ID,              -- GUID [guid]
    REQUEST_LINE_ID,         -- GUID [guid]
    CREATEDON,               -- Time Stamp [timestamp]
    CRENAM,                  -- User Name [syuname]
    UPDATEDON,               -- Time Stamp [timestamp]
    UPDNAM,                  -- User Name [syuname]
    MRPELEMENTSCHEDULELINE,  -- Scheduling [delet]
    LINETYPE,                -- Line Type [mrpreqlinetype]
    DELIVERY_DATE,           -- Delivery Date [mrpreqdatedlv]
    AVAILABILITY_DATE,       -- Availability Date [mrpreqdateavail]
    OPEN_QUANT,              -- Open Quantity [mrpreqquantopen]
    TOTAL_QUANT,             -- Total Quantity [mrpreqquanttotal]
    PRIMARY KEY (MANDT, REQUEST_ID, REQUEST_LINE_ID)
);

Learn More