PROD_PLANT

Transparent Table Application Table
37 Fields 1 CDS Views

I_PRODUCTWD I_PRODUCTPLANTWD

PROD_PLANT is an SAP database table in S/4HANA. I_PRODUCTWD I_PRODUCTPLANTWD. It contains 37 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_Productplantd view from EXTENSION Ext view product plant draft (PRD_PLANT)

Fields (37)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY draftuuid /bobf/uuid Key
parentdraftuuid /bobf/uuid Key
product productnumber Product
plant werks_d Plant
productforedit productnumber Product
plantforedit werks_d Plant
profilecode mmsta P-S Mat. Status
profilevaliditystartdate mmstd Valid From
fiscalyearvariant periv FY Variant
periodtype perkz Period Ind.
profitcenter prctr Profit Center
ismarkedfordeletion lvowk DF plant level
configurableproduct stdpd Conf. Material
stockdeterminationgroup bf_group Stock Determ. Group
isbatchmanagementrequired xchpf_werks Batch Mgmt Rqt(Plnt)
serialnumberprofile serail SerialNoProfile
isnegativestockallowed xmcng Neg. Stocks
isinternalbatchmanaged xchar Batches
productcfopcategory j_1bindus3 Mat. category
productisexcisetaxrelevant cmd_prd_excise_tax_rlvnce Is Excise Tax Relevant
controllingarea kokrs CO Area
salesorganization vkoiv Sales Org. ICB
distributionchannel vtwiv Distrib.Channel
plantcategory vlfkz Plant Cat.
referencedistributioncenter vlgvz Ref. distr. ctr
referencestore vlgfi Reference Store
isreferencedistributioncenter boole_d TRUE
isreferencestore boole_d TRUE
configurationsideeffect vchclf_side_effect_data Side eff.
goodsissueunit ausme Unit of Issue
distrcntrdistributionprofile fprfm Dist.prof.
productmaxcontroltemperature /scmtms/temp_control_max Max. Temp.
productmincontroltemperature /scmtms/temp_control_min Min. Temp.
productcontroltemperatureunit /scmtms/temp_uom Temp. UoM
productfreightgroup mfrgr Mat.Freight Grp
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_PRODUCTPLANTWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROD_PLANT (
    MANDT,                          -- Client [mandt]
    DRAFTUUID,                      -- Key [/bobf/uuid]
    PARENTDRAFTUUID,                -- Key [/bobf/uuid]
    PRODUCT,                        -- Product [productnumber]
    PLANT,                          -- Plant [werks_d]
    PRODUCTFOREDIT,                 -- Product [productnumber]
    PLANTFOREDIT,                   -- Plant [werks_d]
    PROFILECODE,                    -- P-S Mat. Status [mmsta]
    PROFILEVALIDITYSTARTDATE,       -- Valid From [mmstd]
    FISCALYEARVARIANT,              -- FY Variant [periv]
    PERIODTYPE,                     -- Period Ind. [perkz]
    PROFITCENTER,                   -- Profit Center [prctr]
    ISMARKEDFORDELETION,            -- DF plant level [lvowk]
    CONFIGURABLEPRODUCT,            -- Conf. Material [stdpd]
    STOCKDETERMINATIONGROUP,        -- Stock Determ. Group [bf_group]
    ISBATCHMANAGEMENTREQUIRED,      -- Batch Mgmt Rqt(Plnt) [xchpf_werks]
    SERIALNUMBERPROFILE,            -- SerialNoProfile [serail]
    ISNEGATIVESTOCKALLOWED,         -- Neg. Stocks [xmcng]
    ISINTERNALBATCHMANAGED,         -- Batches [xchar]
    PRODUCTCFOPCATEGORY,            -- Mat. category [j_1bindus3]
    PRODUCTISEXCISETAXRELEVANT,     -- Is Excise Tax Relevant [cmd_prd_excise_tax_rlvnce]
    CONTROLLINGAREA,                -- CO Area [kokrs]
    SALESORGANIZATION,              -- Sales Org. ICB [vkoiv]
    DISTRIBUTIONCHANNEL,            -- Distrib.Channel [vtwiv]
    PLANTCATEGORY,                  -- Plant Cat. [vlfkz]
    REFERENCEDISTRIBUTIONCENTER,    -- Ref. distr. ctr [vlgvz]
    REFERENCESTORE,                 -- Reference Store [vlgfi]
    ISREFERENCEDISTRIBUTIONCENTER,  -- TRUE [boole_d]
    ISREFERENCESTORE,               -- TRUE [boole_d]
    CONFIGURATIONSIDEEFFECT,        -- Side eff. [vchclf_side_effect_data]
    GOODSISSUEUNIT,                 -- Unit of Issue [ausme]
    DISTRCNTRDISTRIBUTIONPROFILE,   -- Dist.prof. [fprfm]
    PRODUCTMAXCONTROLTEMPERATURE,   -- Max. Temp. [/scmtms/temp_control_max]
    PRODUCTMINCONTROLTEMPERATURE,   -- Min. Temp. [/scmtms/temp_control_min]
    PRODUCTCONTROLTEMPERATUREUNIT,  -- Temp. UoM [/scmtms/temp_uom]
    PRODUCTFREIGHTGROUP,            -- Mat.Freight Grp [mfrgr]
    HASACTIVEENTITY,                -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More