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_entity 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