PROD_PLANT_SUPPL

Transparent Table Application Table
61 Fields 1 CDS Views

I_PRODUCTWD I_PRODUCTSUPPLYPLANNINGWD

PROD_PLANT_SUPPL is an SAP database table in S/4HANA. I_PRODUCTWD I_PRODUCTSUPPLYPLANNINGWD. It contains 61 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_Productsupplyplanningd view from EXTENSION Ext view prd supp draft(prd_supply)

Fields (61)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY draftuuid /bobf/uuid Key
parentdraftuuid /bobf/uuid Key
rootdraftuuid /bobf/uuid Key
product productnumber Product
plant werks_d Plant
plantforedit werks_d Plant
fixedlotsizequantity bstfe Fixed lot size
maximumlotsizequantity bstma Max. Lot Size
minimumlotsizequantity bstmi Min. Lot Size
lotsizeroundingquantity bstrf Rounding value
lotsizingprocedure disls Lot Sizing Procedure
mrptype dismm MRP Type
mrpresponsible dispo MRP Controller
safetystockquantity eisbe Safety Stock
minimumsafetystockquantity eislo Min. Saf. Stock
planningtimefence fxhor Plng time fence
abcindicator maabc ABC Indicator
maximumstockquantity mabst Max.Stock Level
reorderthresholdquantity minbe Reorder Point
planneddeliverydurationindays plifz Pl. Deliv. Time
safetyduration shzet Safety Time
planningstrategygroup strgr Strategy Group
totalreplenishmentleadtime wzeit Total RL time
procurementtype beskz Procurement
procurementsubtype sobsl Special Procur.
assemblyscrappercent ausss Assembly scrap
availabilitychecktype mtvfp Avail. check
goodsreceiptduration webaz GR proc. time
planandorderdaydetermination lfrhy Planning Cycle
roundingprofile rdprf Rnding Profile
productunitgroup productunitgroup Unit of Measure Group
dfltstoragelocationextprocmt lgfsb Storage Location
backwardcnsmpnperiodinworkdays backwardcnsmpnperiodinworkdays Backward Consumption Period
fwdconsumptionperiodinworkdays fwdconsumptionperiodinworkdays Forward Consumption Period
prodrqmtsconsumptionmode vrmod Consmption mode
currency waers Currency
goodissueprocessingdays wrf_pscd_wabaz GI Proc.Time
consignmentcontrol wrf_cons_procg Consign.Control
inhouseproductiontime dzeit InhseProdTime
repetitivemanufacturingprofile cmd_prd_rem_profile Repetitive Manufacturing Profile
repetitivemanufacturingisallwd cmd_prd_rem_enabled Repetitive Manufacturing Enabled
mrpgroup disgr MRP Group
isstoragecosts lagpr Storage Costs
mrpplanningcalendar mrppp Plan. Calendar
rangeofcvrgprflcode rwpro Coverage Prof.
issafetytime shflg Safety Time Ind
perdprflforsftytme shpro Time Profile
ismrpdependentrqmt ahdis MRP Relevant
lotsizeindependentcosts losfx LSI Costs
rqmtqtyrcpttakttmeinwrkgdays takzt Takt time
srvclvl lgrad Service level
plannedorderactioncontrol mdach Action Control
productioninvtrymanagedloc lgpro Storage Location
baseunit meins Base Unit
matlcompismarkedforbackflush rgekm Backflush
mrpsafetystockmethod mrp_sstock_method Safety Stock Method
jitprodnconfprofile njit_prodn_conf_profile JIT Production Confirmation Profile
dependentrequirementstype sbdkz Indiv./ Coll.
schedulingfloatprofile vdm_fhori Scheduling Float Profile
hasactiveentity sdraft_has_active Has active

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.

-- I_PRODUCTWD I_PRODUCTSUPPLYPLANNINGWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROD_PLANT_SUPPL (
    MANDT,                           -- Client [mandt]
    DRAFTUUID,                       -- Key [/bobf/uuid]
    PARENTDRAFTUUID,                 -- Key [/bobf/uuid]
    ROOTDRAFTUUID,                   -- Key [/bobf/uuid]
    PRODUCT,                         -- Product [productnumber]
    PLANT,                           -- Plant [werks_d]
    PLANTFOREDIT,                    -- Plant [werks_d]
    FIXEDLOTSIZEQUANTITY,            -- Fixed lot size [bstfe]
    MAXIMUMLOTSIZEQUANTITY,          -- Max. Lot Size [bstma]
    MINIMUMLOTSIZEQUANTITY,          -- Min. Lot Size [bstmi]
    LOTSIZEROUNDINGQUANTITY,         -- Rounding value [bstrf]
    LOTSIZINGPROCEDURE,              -- Lot Sizing Procedure [disls]
    MRPTYPE,                         -- MRP Type [dismm]
    MRPRESPONSIBLE,                  -- MRP Controller [dispo]
    SAFETYSTOCKQUANTITY,             -- Safety Stock [eisbe]
    MINIMUMSAFETYSTOCKQUANTITY,      -- Min. Saf. Stock [eislo]
    PLANNINGTIMEFENCE,               -- Plng time fence [fxhor]
    ABCINDICATOR,                    -- ABC Indicator [maabc]
    MAXIMUMSTOCKQUANTITY,            -- Max.Stock Level [mabst]
    REORDERTHRESHOLDQUANTITY,        -- Reorder Point [minbe]
    PLANNEDDELIVERYDURATIONINDAYS,   -- Pl. Deliv. Time [plifz]
    SAFETYDURATION,                  -- Safety Time [shzet]
    PLANNINGSTRATEGYGROUP,           -- Strategy Group [strgr]
    TOTALREPLENISHMENTLEADTIME,      -- Total RL time [wzeit]
    PROCUREMENTTYPE,                 -- Procurement [beskz]
    PROCUREMENTSUBTYPE,              -- Special Procur. [sobsl]
    ASSEMBLYSCRAPPERCENT,            -- Assembly scrap [ausss]
    AVAILABILITYCHECKTYPE,           -- Avail. check [mtvfp]
    GOODSRECEIPTDURATION,            -- GR proc. time [webaz]
    PLANANDORDERDAYDETERMINATION,    -- Planning Cycle [lfrhy]
    ROUNDINGPROFILE,                 -- Rnding Profile [rdprf]
    PRODUCTUNITGROUP,                -- Unit of Measure Group [productunitgroup]
    DFLTSTORAGELOCATIONEXTPROCMT,    -- Storage Location [lgfsb]
    BACKWARDCNSMPNPERIODINWORKDAYS,  -- Backward Consumption Period [backwardcnsmpnperiodinworkdays]
    FWDCONSUMPTIONPERIODINWORKDAYS,  -- Forward Consumption Period [fwdconsumptionperiodinworkdays]
    PRODRQMTSCONSUMPTIONMODE,        -- Consmption mode [vrmod]
    CURRENCY,                        -- Currency [waers]
    GOODISSUEPROCESSINGDAYS,         -- GI Proc.Time [wrf_pscd_wabaz]
    CONSIGNMENTCONTROL,              -- Consign.Control [wrf_cons_procg]
    INHOUSEPRODUCTIONTIME,           -- InhseProdTime [dzeit]
    REPETITIVEMANUFACTURINGPROFILE,  -- Repetitive Manufacturing Profile [cmd_prd_rem_profile]
    REPETITIVEMANUFACTURINGISALLWD,  -- Repetitive Manufacturing Enabled [cmd_prd_rem_enabled]
    MRPGROUP,                        -- MRP Group [disgr]
    ISSTORAGECOSTS,                  -- Storage Costs [lagpr]
    MRPPLANNINGCALENDAR,             -- Plan. Calendar [mrppp]
    RANGEOFCVRGPRFLCODE,             -- Coverage Prof. [rwpro]
    ISSAFETYTIME,                    -- Safety Time Ind [shflg]
    PERDPRFLFORSFTYTME,              -- Time Profile [shpro]
    ISMRPDEPENDENTRQMT,              -- MRP Relevant [ahdis]
    LOTSIZEINDEPENDENTCOSTS,         -- LSI Costs [losfx]
    RQMTQTYRCPTTAKTTMEINWRKGDAYS,    -- Takt time [takzt]
    SRVCLVL,                         -- Service level [lgrad]
    PLANNEDORDERACTIONCONTROL,       -- Action Control [mdach]
    PRODUCTIONINVTRYMANAGEDLOC,      -- Storage Location [lgpro]
    BASEUNIT,                        -- Base Unit [meins]
    MATLCOMPISMARKEDFORBACKFLUSH,    -- Backflush [rgekm]
    MRPSAFETYSTOCKMETHOD,            -- Safety Stock Method [mrp_sstock_method]
    JITPRODNCONFPROFILE,             -- JIT Production Confirmation Profile [njit_prodn_conf_profile]
    DEPENDENTREQUIREMENTSTYPE,       -- Indiv./ Coll. [sbdkz]
    SCHEDULINGFLOATPROFILE,          -- Scheduling Float Profile [vdm_fhori]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More