_PRODUCTPLANT

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 _PRODUCTPLANT (
    PLANT,
    _MRPTYPE,
    _PURCHASINGGROUP,
    ABCINDICATOR,
    AVAILABILITYCHECKTYPE,
    COMMODITY,
    CONSIGNMENTCONTROL,
    CONSUMPTIONQTYMULTIPLIER,
    CONSUMPTIONREFERENCEPLANT,
    CONSUMPTIONREFERENCEPRODUCT,
    CONSUMPTIONREFUSAGEENDDATE,
    CONSUMPTIONTAXCTRLCODE,
    COUNTRYNAME,
    COUNTRYOFORIGIN,
    DISTRCNTRDISTRIBUTIONPROFILE,
    FISCALMONTHCURRENTPERIOD,
    FISCALYEARCURRENTPERIOD,
    FISCALYEARVARIANT,
    FIXEDLOTSIZEQUANTITY,
    GOODISSUEPROCESSINGDAYS,
    GOODSISSUEUNIT,
    GOODSRECEIPTBLOCKEDSTOCKQTY,
    GOODSRECEIPTDURATION,
    HASCONSIGNMENTCTRL,
    HASPOSTTOINSPECTIONSTOCK,
    ISBATCHMANAGEMENTREQUIRED,
    ISCOPRODUCT,
    ISINTERNALBATCHMANAGED,
    ISMARKEDFORDELETION,
    ISNEGATIVESTOCKALLOWED,
    ISPURGACROSSPURGGROUP,
    MAINTENANCESTATUSNAME,
    MATERIALABCCLASSIFICATIONDESC,
    MAXIMUMLOTSIZEQUANTITY,
    MINIMUMLOTSIZEQUANTITY,
    MRPRESPONSIBLE,
    MRPTYPE,
    OVERDELIVTOLERANCELIMIT,
    PERIODTYPE,
    PLANTNAME,
    PROCUREMENTTYPE,
    PRODUCT,
    PRODUCTCFOPCATEGORY,
    PRODUCTIONINVTRYMANAGEDLOC,
    PRODUCTIONSCHEDULINGPROFILE,
    PRODUCTIONSUPERVISOR,
    PRODUCTISCONFIGURABLE,
    PRODUCTUNITGROUP,
    PROFILECODE,
    PROFILEVALIDITYSTARTDATE,
    PROFITCENTER,
    PURCHASINGGROUP,
    PURCHASINGGROUPNAME,
    REGIONOFORIGIN,
    SAFETYSTOCKQUANTITY,
    SEGMENTATIONSTRATEGYFORPLANT,
    SERIALNUMBERPROFILE,
    SOURCEOFSUPPLYCATEGORY,
    SPECIALPROCUREMENTTYPE,
    STOCKDETERMINATIONGROUP,
    STOCKINTRANSFERQUANTITY,
    STOCKINTRANSITQUANTITY,
    UNDERDELIVTOLERANCELIMIT,
    PRIMARY KEY (PLANT)
);