PROD_ROOT

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_PRODUCTWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROD_ROOT (
    MANDT,                           -- Client [mandt]
    DRAFTUUID,                       -- Key [/bobf/uuid]
    PRODUCT,                         -- Product [productnumber]
    PRODUCTFOREDIT,                  -- Product [productnumber]
    PRODUCTTYPE,                     -- Product Type [producttype]
    CROSSPLANTSTATUS,                -- CrossPlantStat [crossplantstatus]
    CROSSPLANTSTATUSVALIDITYDATE,    -- Valid from [mstde]
    CREATIONDATE,                    -- Created On [ersda]
    CREATIONTIME,                    -- Created Time [created_at_time]
    CREATIONDATETIME,                -- Created On [cmd_prd_creation_date_time]
    CREATEDBYUSER,                   -- Created By [ernam]
    LASTCHANGEDATE,                  -- Last Change [laeda]
    LASTCHANGETIME,                  -- Last Chgd. Time [last_changed_time]
    LASTCHANGEDATETIME,              -- Last Changed [changedatetime]
    LASTCHANGEDBYUSER,               -- Changed By [aenam]
    ISMARKEDFORDELETION,             -- Deletion Flag [ismarkedfordeletion]
    PRODUCTOLDID,                    -- Old Prd Number [productoldid]
    GROSSWEIGHT,                     -- Gross Weight [brgew]
    WEIGHTUNIT,                      -- Unit of Weight [gewei]
    NETWEIGHT,                       -- Net Weight [ntgew]
    COUNTRYOFORIGIN,                 -- Country/Region of Origin [cmd_prd_countryoforigin]
    COMPETITORID,                    -- Competitor [wettb]
    PRODUCTGROUP,                    -- Product Group [productgroup]
    BASEUNIT,                        -- Base Unit [meins]
    ITEMCATEGORYGROUP,               -- GenItemCatGroup [mtpos_mara]
    PRODUCTHIERARCHY,                -- Prod. Hierarchy [prodh_d]
    DIVISION,                        -- Division [spart]
    BASICMATERIAL,                   -- Basic Material [wrkst]
    VOLUMEUNIT,                      -- Volume Unit [voleh]
    MATERIALVOLUME,                  -- Volume [materialvolume]
    ANPCODE,                         -- ANP Code [j_1banp]
    BRAND,                           -- Brand [wrf_brand_id]
    VALIDITYSTARTDATE,               -- Valid From [datab]
    PRODNOINGENPRODINPREPACKPROD,    -- GenericMaterial [wstr_satnr_pp]
    SIZEORDIMENSIONTEXT,             -- Size/dimensions [groes]
    INDUSTRYSTANDARDNAME,            -- Ind. Std Desc. [normt]
    PRODUCTSTANDARDID,               -- GTIN [globaltradeitemnumber]
    INTERNATIONALARTICLENUMBERCAT,   -- EAN Category [numtp]
    PRODUCTISCONFIGURABLE,           -- Configurable [productisconfigurable]
    ISBATCHMANAGEMENTREQUIRED,       -- Batch Mgmt Rqt [xchpf]
    EXTERNALPRODUCTGROUP,            -- Ext. prod group [externalproductgroup]
    CROSSPLANTCONFIGURABLEPRODUCT,   -- Cross-plant CP [crossplantconfigurableproduct]
    SERIALNOEXPLICITNESSLEVEL,       -- SerializLevel [serlv]
    PRODUCTMANUFACTURERNUMBER,       -- Mfr Part Number [mfrpn]
    MANUFACTURERNUMBER,              -- Manufacturer [mfrnr]
    MANUFACTURERPARTPROFILE,         -- Mfr Part Profile [mprof]
    CHANGENUMBER,                    -- Change Number [changenumber]
    MATERIALREVISIONLEVEL,           -- Revision Level [productrevisionlevel]
    HANDLINGINDICATOR,               -- Handling Ind. [cifhdlcode]
    WAREHOUSEPRODUCTGROUP,           -- WH Mat.Grp [cifwhmatgr]
    WAREHOUSESTORAGECONDITION,       -- Stor. Condition [cifwhstc]
    STANDARDHANDLINGUNITTYPE,        -- Stand. HU Type [cifhutypdf]
    SERIALNUMBERPROFILE,             -- Serial No. Prf. [cifserial]
    ADJUSTMENTPROFILE,               -- Adjust. Profile [cifadprof]
    ISPILFERABLE,                    -- Pilferable [cifpilfrbl]
    ISRELEVANTFORHZDSSUBSTANCES,     -- Haz. Sub. [cifhazmat]
    QUARANTINEPERIOD,                -- Quarant.Per. [cifqqtime]
    TIMEUNITFORQUARANTINEPERIOD,     -- Time Unit [cifqqtimeuom]
    QUALITYINSPECTIONGROUP,          -- Qual.Insp.Grp [cifqgrp]
    HANDLINGUNITTYPE,                -- HUTyp [cifhutyp]
    HASVARIABLETAREWEIGHT,           -- Variable TW [ciftarevar]
    MAXIMUMPACKAGINGLENGTH,          -- Max.Length [cifmaxl]
    MAXIMUMPACKAGINGWIDTH,           -- Max. Pack Width [cifmaxb]
    MAXIMUMPACKAGINGHEIGHT,          -- Max.Height [cifmaxh]
    MAXIMUMCAPACITY,                 -- Max. Capacity [cifmaxc]
    OVERCAPACITYTOLERANCE,           -- Overcapac. Tol. [cifmaxctol]
    UNITFORMAXPACKAGINGDIMENSIONS,   -- Unit of Measure [cifmaxduom]
    BASEUNITSPECIFICPRODUCTLENGTH,   -- Length [laeng]
    BASEUNITSPECIFICPRODUCTWIDTH,    -- Width [breit]
    BASEUNITSPECIFICPRODUCTHEIGHT,   -- Height [hoehe]
    PRODUCTMEASUREMENTUNIT,          -- Unit [meabm]
    ARTICLECATEGORY,                 -- Prod Category [prodcategory]
    CONTENTUNIT,                     -- Content Unit [inhme]
    NETCONTENT,                      -- Net Contents [inhal]
    COMPARISONPRICEQUANTITY,         -- Comp.price unit [vpreh]
    GROSSCONTENT,                    -- Gross Contents [inhbr]
    PRODUCTVALIDENDDATE,             -- Valid To [liqdt]
    ASSORTMENTLISTTYPE,              -- Astmt List Type [bbtyp]
    HASTEXTILEPARTSWTHANIMALORIGIN,  -- Animal Origin [wrf_animal_origin_flag]
    PRODUCTSEASONUSAGECATEGORY,      -- Season Usage [fsh_sealv]
    SERVICEAGREEMENT,                -- Service Agreemt [w_servv]
    CONSUMPTIONVALUECATEGORY,        -- ABC Indicator [maabc]
    GOODSISSUEUNIT,                  -- Unit of Issue [ausme]
    REGIONOFORIGIN,                  -- Reg. of Origin [herkr]
    ASSORTMENTGRADE,                 -- Assortm. Grade [sstuf]
    PRODEXTASSORTMENTPRIORITY,       -- Ext. asst prio. [pflks]
    SALESUNIT,                       -- Sales Unit [vrkme]
    VALUATIONCLASS,                  -- Valuation Class [bklas]
    VALUATIONMARGIN,                 -- Val. Margin [bwspa]
    DISTRCNTRSALEENDDATE,            -- sale till (DC) [distrcntrsaleenddate]
    CLASSIFICATIONSIDEEFFECT,        -- Side eff. [vchclf_side_effect_data]
    CONFIGURATIONSIDEEFFECT,         -- Side eff. [vchclf_side_effect_data]
    REFERENCEPRODUCT,                -- Reference Product [referenceproduct]
    PRODUCTDESCRIPTION,              -- Description [productdescription]
    AUTHORIZATIONGROUP,              -- AuthorizGroup [begru]
    HASEMPTIESBOM,                   -- W/ Empties BOM [w_mitleerg]
    ISCHEMICALCOMPLIANCERELEVANT,    -- Chemical Compliance Relevance Indicator [chml_cmplnc_rlvnce_ind_pm]
    LABORATORYORDESIGNOFFICE,        -- Lab/Office [labor]
    PACKAGINGMATERIALGROUP,          -- Matl Grp Pckmat [magrv]
    PRODUCTDOCUMENTNUMBER,           -- Document [dzeinr]
    PRODUCTDOCUMENTVERSION,          -- Doc. Version [dzeivr]
    PRODUCTDOCUMENTTYPE,             -- Document Type [dzeiar]
    PRODUCTDOCUMENTCHANGENUMBER,     -- Doc. Change No. [aeszn]
    PRODUCTDOCUMENTPAGECOUNT,        -- No. Of Sheets [blanz]
    PRODUCTDOCUMENTPAGENUMBER,       -- Page Number [blatt]
    PRODUCTDOCUMENTPAGEFORMAT,       -- Page Format [dzeifo]
    OWNINVENTORYMANAGEDPRODUCT,      -- Int. material no. [mpmat]
    VARBLPURORDUNITISACTIVE,         -- Var. Order Unit [vabme]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);