DFS_FMPO_VARNT

Transparent Table Application Table
22 Fields 5 CDS Views

Flexible Material Planner Variant

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

CDS Views using this table (5)

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_FlxMtPlObjVariantBasic view_entity from BASIC FMPO Variant
I_FlxMtPlObjVariantDEX view_entity from BASIC Data Extractor for FMPO Variant

Fields (22)

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
dummy_fmpo_variant_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 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]
    DUMMY_FMPO_VARIANT_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, FLXBLMATLPLNGOBJVARIANTUUID)
);

Learn More