DFS_FMPO_VARNT

Transparent Table Application Table
21 Fields 4 CDS Views

Flexible Material Planner Variant

DFS_FMPO_VARNT is an SAP database table in S/4HANA. Flexible Material Planner Variant. It contains 21 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
E_FlxMtPlObjVariant view from EXTENSION Extension View for Variant
I_AuthzdActlFlxMtPlObjVarInfo view_entity from BASIC FMPO Variant Details
I_FlxMtPlObjVariant view from BASIC List of Variants linked to a FMPO Header
I_FlxMtPlObjVariantDEX view_entity from BASIC Data Extractor for FMPO Variant

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY flxblmatlplngobjvariantuuid dfs_variantuuid Variant UUID
flxblmatlplngobjectuuid dfs_fmpouuid FMPO UUID
flxblmatlplngobjvariantid dfs_variantid Variant ID
flxblmatlplngobjvariantdesc dfs_variantdesc Variant Description
dfsassgmtstatusobject dfs_objnr Object Number
flxmtplobjvarstatuscode j_status Status
flxmtplobjvarisrelocrlvt dfs_relocflag Relocation-Relevant
flxmtplobjvarisserialnmbrrlvt dfs_serflag At Serial No. Level
flxmtplobjvarexternalprodgroup extwg Ext. Matl Group
materialgroup matkl Material Group
flxmtplobjvarproduct dfs_fmpo_product FMPO Product
flxmtplobjvarrespplnrobjtype dfs_fmpo_resp_plnr_objtyp Object Type
flxmtplobjvarrespplnrobjectid dfs_fmpo_resp_plnr_objid Object ID
flxmtplobjvarownerobjecttype dfs_fmpo_matl_owner_objtyp Object Type
flxmtplobjvarownerobjectid dfs_fmpo_matl_owner_objid Object ID
flxmtplobjvarcreationdatetime dfs_createdon Created On
flxmtplobjvariantcreatedbyuser dfs_createdby Created By
flxmtplobjvarlastchangeddtetme dfs_changedon Changed On
flxmtplobjvariantlastchangedby dfs_changedby Changed By
packinginstructionsystemuuid packing_instruction_number Packing Instructi Nr

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 Variant
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFS_FMPO_VARNT (
    MANDT,                           -- Client [mandt]
    FLXBLMATLPLNGOBJVARIANTUUID,     -- Variant UUID [dfs_variantuuid]
    FLXBLMATLPLNGOBJECTUUID,         -- FMPO UUID [dfs_fmpouuid]
    FLXBLMATLPLNGOBJVARIANTID,       -- Variant ID [dfs_variantid]
    FLXBLMATLPLNGOBJVARIANTDESC,     -- Variant Description [dfs_variantdesc]
    DFSASSGMTSTATUSOBJECT,           -- Object Number [dfs_objnr]
    FLXMTPLOBJVARSTATUSCODE,         -- Status [j_status]
    FLXMTPLOBJVARISRELOCRLVT,        -- Relocation-Relevant [dfs_relocflag]
    FLXMTPLOBJVARISSERIALNMBRRLVT,   -- At Serial No. Level [dfs_serflag]
    FLXMTPLOBJVAREXTERNALPRODGROUP,  -- Ext. Matl Group [extwg]
    MATERIALGROUP,                   -- Material Group [matkl]
    FLXMTPLOBJVARPRODUCT,            -- FMPO Product [dfs_fmpo_product]
    FLXMTPLOBJVARRESPPLNROBJTYPE,    -- Object Type [dfs_fmpo_resp_plnr_objtyp]
    FLXMTPLOBJVARRESPPLNROBJECTID,   -- Object ID [dfs_fmpo_resp_plnr_objid]
    FLXMTPLOBJVAROWNEROBJECTTYPE,    -- Object Type [dfs_fmpo_matl_owner_objtyp]
    FLXMTPLOBJVAROWNEROBJECTID,      -- Object ID [dfs_fmpo_matl_owner_objid]
    FLXMTPLOBJVARCREATIONDATETIME,   -- Created On [dfs_createdon]
    FLXMTPLOBJVARIANTCREATEDBYUSER,  -- Created By [dfs_createdby]
    FLXMTPLOBJVARLASTCHANGEDDTETME,  -- Changed On [dfs_changedon]
    FLXMTPLOBJVARIANTLASTCHANGEDBY,  -- Changed By [dfs_changedby]
    PACKINGINSTRUCTIONSYSTEMUUID,    -- Packing Instructi Nr [packing_instruction_number]
    PRIMARY KEY (MANDT, FLXBLMATLPLNGOBJVARIANTUUID)
);

Learn More