PMRP_RES_CAPA

Transparent Table Application Table
12 Fields 1 CDS Views

pMRP Resource Capacity

PMRP_RES_CAPA is an SAP database table in S/4HANA. pMRP Resource Capacity. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PMRPResourceCapacity view_entity from BASIC Resource Capacity used in pMRP

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY reference_id pmrp_reference_id Reference Data
KEY resource_id kapid Capacity ID
KEY day_date sydatum Current Date
capacity pmrp_capacity Capacity
productive_day flag Indicator
productive_days pmrp_productive_days pMRP: Number of Cumulated Productive Days
number_of_shifts pmrp_number_of_shifts NumShft per Day
number_of_resources pmrp_number_of_resources NumResPDay
utilization pmrp_utilization Utilization
bucket_id pmrp_bucket_id Bucket ID
bucket_first_pday flag Indicator

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 Resource Capacity
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PMRP_RES_CAPA (
    MANDT,                -- Client [mandt]
    REFERENCE_ID,         -- Reference Data [pmrp_reference_id]
    RESOURCE_ID,          -- Capacity ID [kapid]
    DAY_DATE,             -- Current Date [sydatum]
    CAPACITY,             -- Capacity [pmrp_capacity]
    PRODUCTIVE_DAY,       -- Indicator [flag]
    PRODUCTIVE_DAYS,      -- pMRP: Number of Cumulated Productive Days [pmrp_productive_days]
    NUMBER_OF_SHIFTS,     -- NumShft per Day [pmrp_number_of_shifts]
    NUMBER_OF_RESOURCES,  -- NumResPDay [pmrp_number_of_resources]
    UTILIZATION,          -- Utilization [pmrp_utilization]
    BUCKET_ID,            -- Bucket ID [pmrp_bucket_id]
    BUCKET_FIRST_PDAY,    -- Indicator [flag]
    PRIMARY KEY (MANDT, REFERENCE_ID, RESOURCE_ID, DAY_DATE)
);

Learn More