DFS_FMPO_HEAD

Transparent Table Application Table
14 Fields 2 CDS Views

Flexible Material Planning Object Header

DFS_FMPO_HEAD is an SAP database table in S/4HANA. Flexible Material Planning Object Header. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_FlxMtPlObj view from EXTENSION Extension View for FMPO Header
I_FlxMtPlObjBasic view from BASIC Basic view for FMPO

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY flxblmatlplngobjectuuid dfs_fmpouuid FMPO UUID
flxblmatlplngobjdescription dfs_fmpodesc FMPO Description
flxblmatlplngobjectid dfs_fmpoid FMPO ID
flxmtplobjricidentifier /isdfps/ric_id RIC ID
flxmtplobjric /isdfps/ricode RIC
flxmtplobjisupdatedinstantly dfs_mcflag Instant update
flxmtplobjcreationdatetime dfs_createdon Created On
flxmtplobjcreatedbyuser dfs_createdby Created By
flxmtplobjlastchangeddatetime dfs_changedon Changed On
flxmtplobjlastchangedby dfs_changedby Changed By
flxmtplobjhierrootnodeid dfs_fmpoid FMPO ID
flxmtplobjsensitivity dfs_sensitivity_key Sensitivity for Char
dfsammunitiongroupcode dfs_icfa Ammunition Code

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 Planning Object Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFS_FMPO_HEAD (
    MANDT,                          -- Client [mandt]
    FLXBLMATLPLNGOBJECTUUID,        -- FMPO UUID [dfs_fmpouuid]
    FLXBLMATLPLNGOBJDESCRIPTION,    -- FMPO Description [dfs_fmpodesc]
    FLXBLMATLPLNGOBJECTID,          -- FMPO ID [dfs_fmpoid]
    FLXMTPLOBJRICIDENTIFIER,        -- RIC ID [/isdfps/ric_id]
    FLXMTPLOBJRIC,                  -- RIC [/isdfps/ricode]
    FLXMTPLOBJISUPDATEDINSTANTLY,   -- Instant update [dfs_mcflag]
    FLXMTPLOBJCREATIONDATETIME,     -- Created On [dfs_createdon]
    FLXMTPLOBJCREATEDBYUSER,        -- Created By [dfs_createdby]
    FLXMTPLOBJLASTCHANGEDDATETIME,  -- Changed On [dfs_changedon]
    FLXMTPLOBJLASTCHANGEDBY,        -- Changed By [dfs_changedby]
    FLXMTPLOBJHIERROOTNODEID,       -- FMPO ID [dfs_fmpoid]
    FLXMTPLOBJSENSITIVITY,          -- Sensitivity for Char [dfs_sensitivity_key]
    DFSAMMUNITIONGROUPCODE,         -- Ammunition Code [dfs_icfa]
    PRIMARY KEY (MANDT, FLXBLMATLPLNGOBJECTUUID)
);

Learn More