MDFD

Transparent Table Application Table
9 Fields 2 CDS Views

MRP firming date

MDFD is an SAP database table in S/4HANA. MRP firming date. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_Prdscm_Locmap_Marc view left_outer Join of MARC, /SAPAPO/LOCMAP
ScmPrd_Locmap_Marc view left_outer Join of MARC, /SAPAPO/LOCMAP

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY werks WERKS_D Plant
KEY plscn PLSCN Planning Scenario
opfdt OPFDT Op.plg firmDate
mfxdt MFXDT Man.firm date
mfnam MFNAM User
mfdat MFDAT Date
mfxti MFXTI Man.firm time

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.

-- MRP firming date
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDFD (
    MANDT,  -- Client [MANDT]
    MATNR,  -- Material [MATNR]
    WERKS,  -- Plant [WERKS_D]
    PLSCN,  -- Planning Scenario [PLSCN]
    OPFDT,  -- Op.plg firmDate [OPFDT]
    MFXDT,  -- Man.firm date [MFXDT]
    MFNAM,  -- User [MFNAM]
    MFDAT,  -- Date [MFDAT]
    MFXTI,  -- Man.firm time [MFXTI]
    PRIMARY KEY (MANDT, MATNR, WERKS, PLSCN)
);

Learn More