DFS_FMPO_MODEL

Transparent Table Application Table
9 Fields 2 CDS Views

Flexible Material Planner Object Model

DFS_FMPO_MODEL is an SAP database table in S/4HANA. Flexible Material Planner Object Model. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_FlxMtPlObjVarModel view from EXTENSION Extension View for Model
I_FlxMtPlObjVarModel view from BASIC List of Models for Variants of FMPO

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY flxmtplobjvariantmodeluuid DFS_MODELUUID Model Guid
flxblmatlplngobjvariantuuid DFS_VARIANTUUID Variant UUID
flxblmatlplngobjectuuid DFS_FMPOUUID FMPO UUID
flxmtplobjvarmodelitmid DFS_MODELID Model ID
flxmtplobjvarmodelproductid MATNR Material
flxmtplobjvarmodelisdflt DFS_PLANNING_FLAG Planning Flag
flxmtplobjvarmodelislocked DFS_LOCKFLAG Lock Flag
dummy_fmpo_model_incl_eew_ps CFD_DUMMY Dummy

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.

-- Flexible Material Planner Object Model
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFS_FMPO_MODEL (
    MANDT,                         -- Client [MANDT]
    FLXMTPLOBJVARIANTMODELUUID,    -- Model Guid [DFS_MODELUUID]
    FLXBLMATLPLNGOBJVARIANTUUID,   -- Variant UUID [DFS_VARIANTUUID]
    FLXBLMATLPLNGOBJECTUUID,       -- FMPO UUID [DFS_FMPOUUID]
    FLXMTPLOBJVARMODELITMID,       -- Model ID [DFS_MODELID]
    FLXMTPLOBJVARMODELPRODUCTID,   -- Material [MATNR]
    FLXMTPLOBJVARMODELISDFLT,      -- Planning Flag [DFS_PLANNING_FLAG]
    FLXMTPLOBJVARMODELISLOCKED,    -- Lock Flag [DFS_LOCKFLAG]
    DUMMY_FMPO_MODEL_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, FLXMTPLOBJVARIANTMODELUUID)
);

Learn More