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