SDM_MSH_PROF01

Transparent Table Control Table (SAP+Cust)
14 Fields 3 CDS Views

Material Shortage definition for SDM routines

SDM_MSH_PROF01 is an SAP database table in S/4HANA. Material Shortage definition for SDM routines. It contains 14 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
e_mrp_mfg_comps view left_outer
e_mrp_proddem_aggr view left_outer
I_MaterialShortageDefinition view from BASIC MRP Material Shortage Definition

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY materialshortageprofile MATERIALSHORTAGEPROFILE Shortage Prf.
KEY materialshortageprof_cnt SDM_COUNTER Counter
demandcategorygroup DEMANDCATEGORYGROUP Demand Groups
receiptcategorygroup RECEIPTCATEGORYGROUP Supply Groups
sdivevaluationhorizonindays SDIVEVALUATIONHORIZONINDAYS Eval. Horizon
uncovereddemandiscalculated UNCOVEREDDEMANDISCALCULATED Uncovered Dmnd
mfgordercomponentcheckrule MFGORDERCOMPONENTCHECKRULE Check Comps
materialshortagethresholdtype MATERIALSHORTAGETHRESHOLDTYPE Threshold Type
minimumlotsizeratioinpercent MINIMUMLOTSIZERATIOINPERCENT LS Percentage
materialflowlogicisrelevant MATERIALFLOWLOGICISRELEVANT Material Flow
maxcoveragecalculationrule MAXCOVERAGECALCULATIONRULE MaxCoverageCalc
handlingofpastdata HANDLINGOFPASTDATA Past Data
demanddrivenrelevant DEMANDDRIVENRELEVANT Demand-Driven

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.

-- Material Shortage definition for SDM routines
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDM_MSH_PROF01 (
    MANDT,                          -- Client [MANDT]
    MATERIALSHORTAGEPROFILE,        -- Shortage Prf. [MATERIALSHORTAGEPROFILE]
    MATERIALSHORTAGEPROF_CNT,       -- Counter [SDM_COUNTER]
    DEMANDCATEGORYGROUP,            -- Demand Groups [DEMANDCATEGORYGROUP]
    RECEIPTCATEGORYGROUP,           -- Supply Groups [RECEIPTCATEGORYGROUP]
    SDIVEVALUATIONHORIZONINDAYS,    -- Eval. Horizon [SDIVEVALUATIONHORIZONINDAYS]
    UNCOVEREDDEMANDISCALCULATED,    -- Uncovered Dmnd [UNCOVEREDDEMANDISCALCULATED]
    MFGORDERCOMPONENTCHECKRULE,     -- Check Comps [MFGORDERCOMPONENTCHECKRULE]
    MATERIALSHORTAGETHRESHOLDTYPE,  -- Threshold Type [MATERIALSHORTAGETHRESHOLDTYPE]
    MINIMUMLOTSIZERATIOINPERCENT,   -- LS Percentage [MINIMUMLOTSIZERATIOINPERCENT]
    MATERIALFLOWLOGICISRELEVANT,    -- Material Flow [MATERIALFLOWLOGICISRELEVANT]
    MAXCOVERAGECALCULATIONRULE,     -- MaxCoverageCalc [MAXCOVERAGECALCULATIONRULE]
    HANDLINGOFPASTDATA,             -- Past Data [HANDLINGOFPASTDATA]
    DEMANDDRIVENRELEVANT,           -- Demand-Driven [DEMANDDRIVENRELEVANT]
    PRIMARY KEY (MANDT, MATERIALSHORTAGEPROFILE, MATERIALSHORTAGEPROF_CNT)
);

Learn More