I_PRODUCTPLANTMRP

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.

-- MRP area data of a Product
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODUCTPLANTMRP (
    MRPAREA,
    PLANT,
    PRODUCT,
    ADVNCDPLNGPERIODFACTORVALUE,
    ADVNCDPLNGPPDSHORIZONINDAYS,
    ADVNCDPLNGSFTYSTKMETH,
    ADVNCDPLNGTGTSTKLVLMETH,
    ASSEMBLYSCRAPPERCENT,
    BASEUNIT,
    CONSUMPTIONOFSTORAGECAPACITY,
    CONSUMPTIONOFSTORAGECAPUNIT,
    COSTFACTORFORSTOCKHOLDINGVAL,
    CREATIONDATE,
    CURRENCY,
    DEPENDENTRQMTMRPRELEVANCE,
    DFLTSTORAGELOCATIONEXTPROCMT,
    FIXEDLOTSIZEQUANTITY,
    GIHANDLINGCAPACITYQUANTITY,
    GIHANDLINGCAPACITYUNIT,
    GOODSISSUEHANDLINGCOST,
    GOODSRECEIPTHANDLINGCOST,
    GRHANDLINGCAPACITYQUANTITY,
    GRHANDLINGCAPACITYUNIT,
    ISMARKEDFORDELETION,
    ISPLANNEDDELIVERYTIME,
    LOCPRODGOODSISSUEPROCHOURS,
    LOCPRODGOODSRECEIPTPROCHOURS,
    LOCPRODSTORAGECOSTVALUE,
    LOTSIZEINDEPENDENTCOSTS,
    LOTSIZEROUNDINGQUANTITY,
    LOTSIZEUNIT,
    LOTSIZINGPROCEDURE,
    MAINTENANCESTATUSNAME,
    MAXDAYSOFSUPPLYISACTIVE,
    MAXDAYSOFSUPPLYPENALTYAMOUNT,
    MAXIMUMLOTSIZEQUANTITY,
    MAXIMUMSTOCKQUANTITY,
    MINIMUMLOTSIZEQUANTITY,
    MRPGROUP,
    MRPPLANNINGCALENDAR,
    MRPRESPONSIBLE,
    MRPSAFETYSTOCKMETHOD,
    MRPTYPE,
    PARLOCSAFETYSTOCKQUANTITY,
    PERDPRFLFORSFTYTME,
    PERIODFACTORISUSED,
    PLANANDORDERDAYDETERMINATION,
    PLANNEDDELIVERYDURATIONINDAYS,
    PLANNINGTIMEFENCE,
    PLNGCALENDARPERDCLOTSIZING,
    PPPLANNINGPROCEDURE,
    PROCUREMENTSUBTYPE,
    PRODNPLNGHEURISTIC,
    PRODUCTPLANNINGGROUP,
    PRODUCTPLANNINGPACKAGE,
    PRODUCTPROCUREMENTCOSTSVAL,
    PRODUCTSAFETYTIMEMRPRELEVANCE,
    RANGEOFCVRGPRFLCODE,
    REORDERDAYSSUPPLYINWORKDAYS,
    REORDERTHRESHOLDQUANTITY,
    ROUNDINGPROFILE,
    RQMTQTYRCPTTAKTTMEINWRKGDAYS,
    SAFETYDURATION,
    SAFETYSTOCKQUANTITY,
    SFTYSTKMETHISAUTOMLYDTMND,
    SFTYSTKVIOLTNPNLTYCOSTVALUE,
    SRVCLVL,
    SRVCPARTSTHROUGHPUTTIMEDURN,
    STORAGECOSTSPERCENTAGECODE,
    STORAGELOCATION,
    TARGETDAYSSUPPLYINWORKDAYS,
    TIMEDEPDNTSTKLVLPERDFACTORVAL,
    VCLMAXIMUMSTOCKQUANTITY,
    VCLPARLOCSAFETYSTOCKQUANTITY,
    VCLREORDERPOINTQUANTITY,
    VCLSAFETYSTOCKQUANTITY,
    PRIMARY KEY (MRPAREA, PLANT, PRODUCT)
);