DFS_FMPO_MODEL

Transparent Table Application Table
8 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 8 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 (8)

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

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]
    PRIMARY KEY (MANDT, FLXMTPLOBJVARIANTMODELUUID)
);

Learn More