PMRP_FLEXCON_MAT

Transparent Table Application Table

Materials for a PMRP Flexible Constraint

PMRP_FLEXCON_MAT is an SAP database table in S/4HANA. Materials for a PMRP Flexible Constraint. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PMRPFlxblConstraintProduct view_entity from BASIC pMRP Flexible Constraints Product

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY flexcon_id pmrp_flexcon_id Constraints ID
KEY simulation_id pmrp_simulation_id Simulation ID
KEY item_id pmrp_item_id Item ID
product matnr Material
display_uom pmrp_constraint_uom Constrtaint UoM
product_uom pmrp_product_uom Product UoM
umrez umrez Numerator
umren umren Denominator
factors_fixed xfeld Checkbox

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.

-- Materials for a PMRP Flexible Constraint
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PMRP_FLEXCON_MAT (
    MANDT,          -- Client [mandt]
    FLEXCON_ID,     -- Constraints ID [pmrp_flexcon_id]
    SIMULATION_ID,  -- Simulation ID [pmrp_simulation_id]
    ITEM_ID,        -- Item ID [pmrp_item_id]
    PRODUCT,        -- Material [matnr]
    DISPLAY_UOM,    -- Constrtaint UoM [pmrp_constraint_uom]
    PRODUCT_UOM,    -- Product UoM [pmrp_product_uom]
    UMREZ,          -- Numerator [umrez]
    UMREN,          -- Denominator [umren]
    FACTORS_FIXED,  -- Checkbox [xfeld]
    PRIMARY KEY (MANDT, FLEXCON_ID, SIMULATION_ID, ITEM_ID)
);