MATERIAL

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MATERIAL (
    FACTORYCALENDAR,
    MASTERPROJECT,
    MATERIAL,
    MATERIALSHORTAGEPROFILE,
    MATERIALSHORTAGEPROFILECOUNT,
    MRPAREA,
    MRPPLANNINGSEGMENT,
    MRPPLANT,
    _UNITOFMEASURE,
    BASEUNIT,
    CUSTOMER,
    CUSTOMERNAME,
    DAYSOFSUPPLYCRITICALITY,
    DAYSOFSUPPLYDURATION,
    EVALUATIONHORIZONINDAYS,
    HASACCEPTEDSHORTAGE,
    HASSHORTAGEMANUALPLANHORIZON,
    HASSHORTAGEMRPSAFETYDURATION,
    HASSHORTAGETOTALREPLNMTLEAD,
    INTRADAYSUPPLYDURATION,
    ISMARKEDFORDELETION,
    ISSUECOUNT,
    LASTBUFFERUPDATEDATETIME,
    LOWLEVELCODE,
    MANUALPLANNINGHORIZONENDDATE,
    MATERIALABCCLASSIFICATION,
    MATERIALBASEUNIT,
    MATERIALCOMPISPROCUREDDIRECTLY,
    MATERIALFIRSTSHORTAGEDATE,
    MATERIALFIRSTSHORTAGEDATEQTY,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALGROUP,
    MATERIALGROUPNAME,
    MATERIALNAME,
    MATERIALPLANNEDPRODUCTIONDURN,
    MATERIALPROCUREMENTCATEGORY,
    MATERIALPROCUREMENTPROFILE,
    MATERIALSAFETYSTOCKQTY,
    MATERIALSHORTAGEDEFINITIONNAME,
    MATERIALSHORTAGEDURATION,
    MATERIALSHORTAGEDURNINWORKDAYS,
    MATERIALSHORTAGEENDDATE,
    MATERIALSHORTAGESTARTDATE,
    MATERIALTYPE,
    MATERIALTYPENAME,
    MATLMAXCOVERAGEDURNINWORKDAYS,
    MATNR,
    MRPAVAILABLESTOCKQTY,
    MRPCONTROLLER,
    MRPGROUP,
    MRPMATERIALNOTETEXT,
    MRPRESULTISPROCESSED,
    MRPRESULTPROCESSEDDATETIME,
    MRPSAFETYDURATION,
    MRPSAFETYDURATIONENDDATE,
    MRPSAFETYSTOCKMETHOD,
    MRPVALIDMATERIALSTATUS,
    NUMBEROFCANCELPROCESSES,
    NUMBEROFPASTDUEENDDATEELEMENTS,
    NUMBEROFPASTDUESTARTDATEELMNTS,
    NUMBEROFRESCHEDULEOUTELEMENTS,
    NUMBEROFSUPPLIER,
    PLANNINGSEGMENTDOCUMENTITEM,
    PLANNINGTIMEFENCEINDAYS,
    PLANTLANGUAGE,
    PRODUCTIONPRODUCTHIERARCHY,
    PRODUCTIONPRODUCTHIERARCHYNODE,
    RESPONSIBLEPERSON,
    SCHEDULEAGREEMENTHASRELEASEDOC,
    STOCKDAYSSUPPLYCRITICALITY,
    STOCKDAYSSUPPLYDURATION,
    STOCKINTRADAYSUPPLYDURATION,
    TIMETILLSHORTAGEINCALENDARDAYS,
    TOTALREPLENISHMENTLEADDURATION,
    TOTALREPLNMTLEADDURNENDDATE,
    UNITOFMEASUREDSPNMBROFDCMLS,
    UNITOFMEASURENUMBEROFDECIMALS,
    WBSDESCRIPTION,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    WEEKLYAVAILABILITYCHART,
    PRIMARY KEY (FACTORYCALENDAR, MASTERPROJECT, MATERIAL, MATERIALSHORTAGEPROFILE, MATERIALSHORTAGEPROFILECOUNT, MRPAREA, MRPPLANNINGSEGMENT, MRPPLANT)
);