PRD_PLANT

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.

-- Product: Draft Plant Node
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRD_PLANT (
    CLIENT,                         -- Client [MANDT]
    DRAFTKEY,                       -- NodeID [/BOBF/CONF_KEY]
    PARENTDRAFTKEY,                 -- NodeID [/BOBF/CONF_KEY]
    HASACTIVEENTITY,                -- TRUE [BOOLE_D]
    ACTIVEPRODUCT,                  -- Product [PRODUCTNUMBER]
    ACTIVEPLANT,                    -- Plant [PRODUCTPLANT]
    PRODUCT,                        -- Product [PRODUCTNUMBER]
    PLANT,                          -- Plant [PRODUCTPLANT]
    PURCHASINGGROUP,                -- Purch. group [PRODUCTPURCHASINGGROUP]
    COUNTRYOFORIGIN,                -- C/R of Origin [COUNTRYOFORIGIN]
    REGIONOFORIGIN,                 -- Reg. of Origin [REGIONOFORIGIN]
    PRODUCTIONINVTRYMANAGEDLOC,     -- Prod. Stor.Loc. [PRODUCTIONINVTRYMANAGEDLOC]
    PROFILECODE,                    -- Product Status [PROFILECODE]
    PROFILEVALIDITYSTARTDATE,       -- Valid from [PROFILEVALIDITYSTARTDATE]
    AVAILABILITYCHECKTYPE,          -- Avail. check [AVAILABILITYCHECKTYPE]
    FISCALYEARVARIANT,              -- Fi.Year Variant [FISCALYEARVARIANT]
    PERIODTYPE,                     -- PeriodIndicator [PERIODINDICATOR]
    PROFITCENTER,                   -- Profit Center [PROFITCENTER]
    COMMODITY,                      -- Commodity Code [COMMODITYCODE]
    GOODSRECEIPTDURATION,           -- GR proc. time [GOODSRECEIPTDURATION]
    MAINTENANCESTATUSNAME,          -- Maint. status [MAINTENANCESTATUSNAME]
    ISMARKEDFORDELETION,            -- DF plant level [ISMARKEDFORDELETIONATPLANT]
    CONSUMPTIONTAXCTRLCODE,         -- Taxes F.Trade [CONSUMPTIONTAXCTRLCODE]
    ISCOPRODUCT,                    -- Co-product? [ISCOPRODUCT]
    PRODUCTISCONFIGURABLE,          -- Confble prod [CONFIGURABLEPRODUCT]
    STOCKDETERMINATIONGROUP,        -- Stock det. grp [STOCKDETERMINATIONGROUP]
    STOCKINTRANSFERQUANTITY,        -- Stock in tfr [STOCKINTRANSFERQUANTITY]
    STOCKINTRANSITQUANTITY,         -- Stk in Transit [STOCKINTRANSITQUANTITY]
    HASPOSTTOINSPECTIONSTOCK,       -- Post to insp. stk [HASPOSTTOINSPECTIONSTOCK]
    ISBATCHMANAGEMENTREQUIRED,      -- Batch Mgmt Rqt [ISBATCHMANAGEMENTREQUIRED]
    SERIALNUMBERPROFILE,            -- SerialNoProfile [SERIALNUMBERPROFILE]
    ISNEGATIVESTOCKALLOWED,         -- Neg. stocks [ISNEGATIVESTOCKALLOWED]
    GOODSRECEIPTBLOCKEDSTOCKQTY,    -- Val. GR Blocked Stck [GOODSRECEIPTBLOCKEDSTOCKQTY]
    HASCONSIGNMENTCTRL,             -- Consign.Control [HASCONSIGNMENTCTRL]
    FISCALYEARCURRENTPERIOD,        -- Year cur.period [FISCALYEARCURRENTPERIOD]
    FISCALMONTHCURRENTPERIOD,       -- Current period [FISCALMONTHCURRENTPERIOD]
    ISPURGACROSSPURGGROUP,          -- Across Purch.Group [ISPURGACROSSPURGGROUP]
    ISINTERNALBATCHMANAGED,         -- Batches [ISINTERNALBATCHMANAGED]
    PRODUCTCFOPCATEGORY,            -- Prod. category [PRODUCTCFOPCATEGORY]
    GOODSISSUEUNIT,                 -- Unit of Issue [GOODSISSUEUNIT]
    SOURCEOFSUPPLYCATEGORY,         -- Supply source [SRCOFSUPPLYCATEGORY]
    CONSUMPTIONREFERENCEPRODUCT,    -- Ref.matl: cons. [CONSUMPTIONREFERENCEPRODUCT]
    CONSUMPTIONREFERENCEPLANT,      -- Ref.plant:cons. [CONSUMPTIONREFERENCEPLANT]
    CONSUMPTIONREFUSAGEENDDATE,     -- Date to [CONSUMPTIONREFUSAGEENDDATE]
    CONSUMPTIONQTYMULTIPLIER,       -- Multiplier [CONSUMPTIONQTYMULTIPLIER]
    PRODUCTUNITGROUP,               -- Unit of Measure Group [PRODUCTUNITGROUP]
    DISTRCNTRDISTRIBUTIONPROFILE,   -- Dist.prof. [DISTRCNTRDISTRIBUTIONPROFILE]
    CONSIGNMENTCONTROL,             -- Consign.Control [CONSIGNMENTCONTROL]
    GOODISSUEPROCESSINGDAYS,        -- GI Proc.Time [GOODISSUEPROCESSINGDAYS]
    SALESORGANIZATION,              -- Sales Org. [PRODUCTSALESORGANIZATION]
    DISTRIBUTIONCHANNEL,            -- Distr. Channel [PRODUCTDISTRIBUTIONCHANNEL]
    REFERENCEDISTRIBUTIONCENTER,    -- Ref. distr. ctr [REFDC]
    REFERENCESTORE,                 -- Reference Store [REFSTORE]
    PLANTCATEGORY,                  -- Plant cat. [PLANTINDICATOR]
    ISREFERENCEDISTRIBUTIONCENTER,  -- Checkbox [ISREFDC]
    ISREFERENCESTORE,               -- Checkbox [ISREFSTORE]
    DUMMY_PLNT_INCL_EEW_PS,         -- MD product plant extensible field element [PLNT_INCL_EEW]
    PRIMARY KEY (CLIENT, DRAFTKEY)
);