PMRP_RESOURCE

Transparent Table Application Table
14 Fields 3 CDS Views

pMRP Resource

PMRP_RESOURCE is an SAP database table in S/4HANA. pMRP Resource. It contains 14 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_PMRPResource view_entity from BASIC A Resource used in pMRP
I_PMRPSimulationResource view_entity inner BASIC Resource in pMRP Simulation
P_PMRPSIMLNRSCEGROUP1 view_entity inner BASIC pMRP resource group buckets

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY reference_id pmrp_reference_id Reference Data
KEY resource_id kapid Capacity ID
resource_name pmrp_resource_name Resource Name
factory_calendar_id cr_wfcid Factory Calendar
plant werks_d Plant
workcenter_id cr_objid Object ID
workcenter_name arbpl Work Center
capacity_category kapart Capacity cat.
base_unit kapbasis Base Unit
display_unit cr_kapeh Capacity Unit
numerator kapbaszhl Numerator base
denominator kapbasnen Denominator
capacity_planner kapplaner Capacity Planner

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PMRP_RESOURCE (
    MANDT,                -- Client [mandt]
    REFERENCE_ID,         -- Reference Data [pmrp_reference_id]
    RESOURCE_ID,          -- Capacity ID [kapid]
    RESOURCE_NAME,        -- Resource Name [pmrp_resource_name]
    FACTORY_CALENDAR_ID,  -- Factory Calendar [cr_wfcid]
    PLANT,                -- Plant [werks_d]
    WORKCENTER_ID,        -- Object ID [cr_objid]
    WORKCENTER_NAME,      -- Work Center [arbpl]
    CAPACITY_CATEGORY,    -- Capacity cat. [kapart]
    BASE_UNIT,            -- Base Unit [kapbasis]
    DISPLAY_UNIT,         -- Capacity Unit [cr_kapeh]
    NUMERATOR,            -- Numerator base [kapbaszhl]
    DENOMINATOR,          -- Denominator [kapbasnen]
    CAPACITY_PLANNER,     -- Capacity Planner [kapplaner]
    PRIMARY KEY (MANDT, REFERENCE_ID, RESOURCE_ID)
);

Learn More