PMRP_CAPREQ

Transparent Table Application Table
16 Fields 1 CDS Views

pMRP Requirement

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PMRPSimlnCapacityRqmtBasic view_entity from BASIC pMRP capacity requirement

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY capreq_id pmrp_capreq_id Cap Rqmt ID
KEY simulation_id pmrp_simulation_id Simulation ID
resource_id kapid Capacity ID
bucket_id pmrp_bucket_id Bucket ID
bucket_days pmrp_capreq_bucket_days Duration in Bucket
total_days pmrp_capreq_total_days Total Duration
fix_demand pmrp_fix_demand Fix Demand
var_demand pmrp_var_demand Variable Demand
capacity_demand pmrp_eff_cap_demand Capacity Demand
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
scale_factor_tld pmrp_scale_factor_tld Scale from Top Level Domain to Element
is_from_preproduction boole_d TRUE

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_CAPREQ (
    MANDT,                   -- Client [mandt]
    CAPREQ_ID,               -- Cap Rqmt ID [pmrp_capreq_id]
    SIMULATION_ID,           -- Simulation ID [pmrp_simulation_id]
    RESOURCE_ID,             -- Capacity ID [kapid]
    BUCKET_ID,               -- Bucket ID [pmrp_bucket_id]
    BUCKET_DAYS,             -- Duration in Bucket [pmrp_capreq_bucket_days]
    TOTAL_DAYS,              -- Total Duration [pmrp_capreq_total_days]
    FIX_DEMAND,              -- Fix Demand [pmrp_fix_demand]
    VAR_DEMAND,              -- Variable Demand [pmrp_var_demand]
    CAPACITY_DEMAND,         -- Capacity Demand [pmrp_eff_cap_demand]
    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]
    SCALE_FACTOR_TLD,        -- Scale from Top Level Domain to Element [pmrp_scale_factor_tld]
    IS_FROM_PREPRODUCTION,   -- TRUE [boole_d]
    PRIMARY KEY (MANDT, CAPREQ_ID, SIMULATION_ID)
);

Learn More