DFS_FMPO_HEAD
Flexible Material Planning Object Header
DFS_FMPO_HEAD is an SAP database table in S/4HANA. Flexible Material Planning Object Header. It contains 15 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_FlxMtPlObj | view | from | EXTENSION | Extension View for FMPO Header |
| I_FlxMtPlObjBasic | view | from | BASIC | Basic view for FMPO |
Fields (15)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 | ||||
| dummy_fmpo_head_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 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]
DUMMY_FMPO_HEAD_INCL_EEW_PS, -- Dummy [CFD_DUMMY]
PRIMARY KEY (MANDT, FLXBLMATLPLNGOBJECTUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA