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