P_MATERIALPLANTMALFUNCMANAGE

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 P_MATERIALPLANTMALFUNCMANAGE (
    MATERIAL,
    PLANT,
    ABCINDICATOR,
    AUTHORIZATIONGROUP,
    AVAILABILITYCHECKTYPE,
    COMMODITY,
    CONSIGNMENTCONTROL,
    CONSUMPTIONQTYMULTIPLIER,
    CONSUMPTIONREFERENCEPLANT,
    CONSUMPTIONREFERENCEPRODUCT,
    CONSUMPTIONREFUSAGEENDDATE,
    CONSUMPTIONTAXCTRLCODE,
    COUNTRYOFORIGIN,
    DISTRCNTRDISTRIBUTIONPROFILE,
    FISCALYEARVARIANT,
    FIXEDLOTSIZEQUANTITY,
    GOODISSUEPROCESSINGDAYS,
    GOODSISSUEUNIT,
    GOODSRECEIPTBLOCKEDSTOCKQTY,
    GOODSRECEIPTDURATION,
    HASCONSIGNMENTCTRL,
    HASPOSTTOINSPECTIONSTOCK,
    ISBATCHMANAGEMENTREQUIRED,
    ISCOPRODUCT,
    ISINTERNALBATCHMANAGED,
    ISNEGATIVESTOCKALLOWED,
    ISPURGACROSSPURGGROUP,
    MAINTENANCESTATUSNAME,
    MATERIALBASEUNIT,
    MATERIALGROSSWEIGHT,
    MATERIALGROUP,
    MATERIALMANUFACTURERNUMBER,
    MATERIALMANUFACTURERPARTNUMBER,
    MATERIALNETWEIGHT,
    MATERIALTYPE,
    MATERIALWEIGHTUNIT,
    MAXIMUMLOTSIZEQUANTITY,
    MINIMUMLOTSIZEQUANTITY,
    MRPRESPONSIBLE,
    MRPTYPE,
    OVERDELIVTOLERANCELIMIT,
    PERIODTYPE,
    PROCUREMENTTYPE,
    PRODUCT,
    PRODUCTCFOPCATEGORY,
    PRODUCTIONINVTRYMANAGEDLOC,
    PRODUCTIONSCHEDULINGPROFILE,
    PRODUCTIONSUPERVISOR,
    PRODUCTISCONFIGURABLE,
    PRODUCTUNITGROUP,
    PROFILECODE,
    PROFILEVALIDITYSTARTDATE,
    PROFITCENTER,
    PURCHASINGGROUP,
    REGIONOFORIGIN,
    SAFETYSTOCKQUANTITY,
    SERIALNUMBERPROFILE,
    SOURCEOFSUPPLYCATEGORY,
    SPECIALPROCUREMENTTYPE,
    STOCKDETERMINATIONGROUP,
    STOCKINTRANSFERQUANTITY,
    STOCKINTRANSITQUANTITY,
    UNDERDELIVTOLERANCELIMIT,
    PRIMARY KEY (MATERIAL, PLANT)
);