PMRP_FLEXCON_MAT

Transparent Table Application Table
10 Fields 1 CDS Views

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 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)
);

Learn More