MDIP

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: MRP Profiles (Field Contents)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDIP (
    MANDT,   -- Client [mandt]
    DISPR,   -- MRP profile [dispr]
    DISMM,   -- MRP Type [dismm]
    DISPO,   -- MRP Controller [dispo]
    KZDIE,   -- MRPCtrllr=buyer [kzdie]
    MAABC,   -- ABC Indicator [maabc]
    PLIFZ,   -- Pl. Deliv. Time [plifz]
    DZEIT,   -- InhseProdTime [dzeit]
    FHORI,   -- Margin Key [fhori]
    SBDKZ,   -- Indiv./ Coll. [sbdkz]
    KZBED,   -- Reqmts grouping [kzbed]
    EISBE,   -- Safety Stock [eisbe]
    MINBE,   -- Reorder Point [minbe]
    DISLS,   -- Lot Sizing Procedure [disls]
    BSTRF,   -- Rounding value [bstrf]
    BSTMI,   -- Min. Lot Size [bstmi]
    BSTMA,   -- Max. Lot Size [bstma]
    BSTFE,   -- Fixed lot size [bstfe]
    MABST,   -- Max.Stock Level [mabst]
    AUSSS,   -- Assembly scrap [ausss]
    LOSFX,   -- LSI Costs [losfx]
    LAGPR,   -- Storage Costs [lagpr]
    AUFTL,   -- Splitting [auftl]
    LGRAD,   -- Service level [lgrad]
    WEBAZ,   -- GR proc. time [webaz]
    USEQU,   -- Quota arr.usage [usequ]
    PERKZ,   -- Period Ind. [perkz]
    PERIV,   -- FY Variant [periv]
    EKGRP,   -- Purch. Group [ekgrp]
    MRPPP,   -- Plan. Calendar [mrppp]
    SAUFT,   -- Repetitive Mfg [sa_sauft]
    SFEPR,   -- REM Profile [sfepr]
    FXHOR,   -- Plng time fence [fxhor]
    VRMOD,   -- Consmption mode [vrmod]
    VINT1,   -- Bwd cons. per. [vint1]
    VINT2,   -- Fwd cons.period [vint2]
    DISGR,   -- MRP Group [disgr]
    KAUSF,   -- Component Scrap [kausf]
    ALTSL,   -- SelectionMethod [altsl]
    MISKZ,   -- Mixed MRP [miskz]
    WZEIT,   -- Total RL time [wzeit]
    VPMAT,   -- Plng material [vpmat]
    VPWRK,   -- Planning Plant [vpwrk]
    VPREF,   -- Convers. Factor [vpref]
    TAKZT,   -- Takt time [takzt]
    RWPRO,   -- Coverage Prof. [rwpro]
    LFRHY,   -- Planning Cycle [lfrhy]
    RDPRF,   -- Rnding Profile [rdprf]
    STRGR,   -- Strategy Group [strgr]
    SOBSL,   -- Special Procur. [sobsl]
    RGEKZ,   -- Backflush [rgekm]
    SCHGT,   -- Bulk material [schgt]
    WAERS,   -- Currency [waers]
    SHFLG,   -- Safety Time Ind [shflg]
    SHZET,   -- Safety Time [shzet]
    MDACH,   -- Action Control [mdach]
    LGPRO,   -- Storage Location [lgpro]
    MTVFP,   -- Avail. check [mtvfp]
    BESKZ,   -- Procurement [beskz]
    KZECH,   -- Enter batch [kzech]
    EISLO,   -- Min. Saf. Stock [eislo]
    PLIFZX,  -- Consider PlDelTime [md_plifz_db]
    LGFSB,   -- Storage Location [lgfsb]
    PRIMARY KEY (MANDT, DISPR)
);