PMRP_RQMT

Transparent Table Application Table
27 Fields 1 CDS Views

pMRP Requirement

PMRP_RQMT is an SAP database table in S/4HANA. pMRP Requirement. It contains 27 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PMRPRequirementBasic view from BASIC Requirement used in pMRP

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY rqmt_id pmrp_rqmt_id Requirement ID
KEY simulation_id pmrp_simulation_id Simulation ID
product matnr Material
plant werks_d Plant
mrparea berid MRP Area
rqmt_category pmrp_order_category Order Category
rqmt_start_date pmrp_req_start_date Start Date
rqmt_end_date pmrp_req_end_date Requirement End Date
req_quantity pmrp_req_quantity Required Quantity
open_quantity pmrp_open_quantity Open Quantity
cov_by_stock_quan pmrp_cov_by_stock_quan Quantity Covered
available_stock pmrp_avail_stock_quantity Available Quantity
uom meins Base Unit
bucket_workdays pmrp_capreq_bucket_days Duration in Bucket
total_workdays pmrp_capreq_total_days Total Duration
sos_item_id pmrp_sos_item_id SoS Item ID
sos_input_quantity kmpmg Quantity
sos_output_quantity basmn Base quantity
output_uom meins Base Unit
aggr_quot_factor_nom pmrp_agg_quot_factor_nom Quota Nominator
aggr_quot_factor_denom pmrp_agg_quot_factor_denom Quota Denominator
trigger_receipt_id pmrp_trigger_receipt_id ID of Receipt
tld_id pmrp_sim_tld_id Top-Level Demand ID
creation_type pmrp_order_creation_type Creation Type
low_level_code pmrp_low_level_code Low-Level Code
scale_factor_tld pmrp_scale_factor_tld Scale from Top Level Domain to Element

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.

-- pMRP Requirement
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PMRP_RQMT (
    MANDT,                   -- Client [mandt]
    RQMT_ID,                 -- Requirement ID [pmrp_rqmt_id]
    SIMULATION_ID,           -- Simulation ID [pmrp_simulation_id]
    PRODUCT,                 -- Material [matnr]
    PLANT,                   -- Plant [werks_d]
    MRPAREA,                 -- MRP Area [berid]
    RQMT_CATEGORY,           -- Order Category [pmrp_order_category]
    RQMT_START_DATE,         -- Start Date [pmrp_req_start_date]
    RQMT_END_DATE,           -- Requirement End Date [pmrp_req_end_date]
    REQ_QUANTITY,            -- Required Quantity [pmrp_req_quantity]
    OPEN_QUANTITY,           -- Open Quantity [pmrp_open_quantity]
    COV_BY_STOCK_QUAN,       -- Quantity Covered [pmrp_cov_by_stock_quan]
    AVAILABLE_STOCK,         -- Available Quantity [pmrp_avail_stock_quantity]
    UOM,                     -- Base Unit [meins]
    BUCKET_WORKDAYS,         -- Duration in Bucket [pmrp_capreq_bucket_days]
    TOTAL_WORKDAYS,          -- Total Duration [pmrp_capreq_total_days]
    SOS_ITEM_ID,             -- SoS Item ID [pmrp_sos_item_id]
    SOS_INPUT_QUANTITY,      -- Quantity [kmpmg]
    SOS_OUTPUT_QUANTITY,     -- Base quantity [basmn]
    OUTPUT_UOM,              -- Base Unit [meins]
    AGGR_QUOT_FACTOR_NOM,    -- Quota Nominator [pmrp_agg_quot_factor_nom]
    AGGR_QUOT_FACTOR_DENOM,  -- Quota Denominator [pmrp_agg_quot_factor_denom]
    TRIGGER_RECEIPT_ID,      -- ID of Receipt [pmrp_trigger_receipt_id]
    TLD_ID,                  -- Top-Level Demand ID [pmrp_sim_tld_id]
    CREATION_TYPE,           -- Creation Type [pmrp_order_creation_type]
    LOW_LEVEL_CODE,          -- Low-Level Code [pmrp_low_level_code]
    SCALE_FACTOR_TLD,        -- Scale from Top Level Domain to Element [pmrp_scale_factor_tld]
    PRIMARY KEY (MANDT, RQMT_ID, SIMULATION_ID)
);

Learn More