MDFDDB

Transparent Table Application Table
9 Fields 2 CDS Views

Firming Data of MRP - MRP Area

MDFDDB is an SAP database table in S/4HANA. Firming Data of MRP - MRP Area. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_Prdscm_Locmap_Mdma view left_outer Join of /SAPAPO/LOCMAP, P_PRDSCM_MDMA_MDLV, MARC
ScmPrd_Locmap_Mdma view left_outer Join of /SAPAPO/LOCMAP, P_PRDSCM_MDMA_MDLV, MARC

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY matnr matnr Material
KEY berid berid MRP Area
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.

-- Firming Data of MRP - MRP Area
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDFDDB (
    MANDT,  -- Client [mandt]
    MATNR,  -- Material [matnr]
    BERID,  -- MRP Area [berid]
    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, BERID, PLSCN)
);

Learn More