SAP PROD_ROOT Table in S/4 HANA - I_PRODUCTWD I_PRODUCTWD
PROD_ROOT is a standard SAP Table which is used to store I_PRODUCTWD I_PRODUCTWD data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP PROD_ROOT table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can Be Enhanced (Deep)
Dictionary Type: Transparent table
Database Table: PROD_ROOT
PROD_ROOT table structure field list
Below is the full PROD_ROOT field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | Client | MANDT | CLNT | 3(0) | MANDT | |||||
DRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW | 16(0) | SYSUUID | |||||
PRODUCT | Product Number | PRODUCTNUMBER | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
PRODUCTFOREDIT | Product Number | PRODUCTNUMBER | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
PRODUCTTYPE | Product Type | PRODUCTTYPE | CHAR | 4(0) | MTART | MTA | ||||
CROSSPLANTSTATUS | Cross-Plant Product Status | CROSSPLANTSTATUS | CHAR | 2(0) | MMSTA | |||||
CROSSPLANTSTATUSVALIDITYDATE | Date from which the cross-plant material status is valid | MSTDE | DATS | 8(0) | DATUM | |||||
CREATIONDATE | Created On | ERSDA | DATS | 8(0) | DATUM | |||||
CREATIONTIME | Time of Creation | CREATED_AT_TIME | TIMS | 6(0) | TIME | |||||
CREATIONDATETIME | Product Created On | CMD_PRD_CREATION_DATE_TIME | DEC | 21(7) | TZNTSTMPL | |||||
CREATEDBYUSER | Name of Person who Created the Object | ERNAM | CHAR | 12(0) | USNAM | |||||
LASTCHANGEDATE | Date of Last Change | LAEDA | DATS | 8(0) | DATUM | |||||
LASTCHANGETIME | Time of Last Change | LAST_CHANGED_TIME | TIMS | 6(0) | TIME | |||||
LASTCHANGEDATETIME | Change Time Stamp | CHANGEDATETIME | DEC | 21(7) | TZNTSTMPL | |||||
LASTCHANGEDBYUSER | Name of person who changed object | AENAM | CHAR | 12(0) | USNAM | |||||
ISMARKEDFORDELETION | Deletion Indicator | ISMARKEDFORDELETION | CHAR | 1(0) | XFELD | |||||
PRODUCTOLDID | Old Product Number | PRODUCTOLDID | CHAR | 40(0) | BISMT | |||||
GROSSWEIGHT | Gross weight | BRGEW | QUAN | 13(3) | MENG13 | |||||
WEIGHTUNIT | Weight Unit | GEWEI | UNIT | 3(0) | CUNIT | MEINS | ||||
NETWEIGHT | Net weight | NTGEW | QUAN | 13(3) | MENG13 | |||||
COUNTRYOFORIGIN | Country of Origin of Material (Non-Preferential Origin) | HERKL | CHAR | 3(0) | LAND1 | LND | ||||
COMPETITORID | Competitor | WETTB | CHAR | 10(0) | ALPHA | KUNNR | KUN | |||
PRODUCTGROUP | Product Group | PRODUCTGROUP | CHAR | 9(0) | MATKL | MKL | S_WBWG | MATKL | ||
BASEUNIT | Base Unit of Measure | MEINS | UNIT | 3(0) | CUNIT | MEINS | ||||
ITEMCATEGORYGROUP | General item category group | MTPOS_MARA | CHAR | 4(0) | MTPOS | |||||
PRODUCTHIERARCHY | Product hierarchy | PRODH_D | CHAR | 18(0) | PRODH | VPR | ||||
DIVISION | Division | SPART | CHAR | 2(0) | SPART | SPA | C_SPART | SPART | ||
VOLUMEUNIT | Volume unit | VOLEH | UNIT | 3(0) | CUNIT | MEINS | ||||
MATERIALVOLUME | Volume | MATERIALVOLUME | QUAN | 13(3) | MENG13 | |||||
ANPCODE | ANP Code | J_1BANP | NUMC | 9(0) | J_1BANP | |||||
BRAND | Brand | WRF_BRAND_ID | CHAR | 4(0) | WRF_BRAND_ID | |||||
VALIDITYSTARTDATE | Valid-From Date | DATAB | DATS | 8(0) | DATUM | |||||
PRODNOINGENPRODINPREPACKPROD | Material Number of the Generic Material in Prepack Materials | WSTR_SATNR_PP | CHAR | 40(0) | MATN1 | MATNR | ||||
SIZEORDIMENSIONTEXT | Size/dimensions | GROES | CHAR | 32(0) | CHAR32 | |||||
INDUSTRYSTANDARDNAME | Industry Standard Description (such as ANSI or ISO) | NORMT | CHAR | 18(0) | NORMT | |||||
PRODUCTSTANDARDID | The global trade item number (EAN/UPC/GTIN) | GLOBALTRADEITEMNUMBER | CHAR | 18(0) | EAN11 | EAN11 | EAN | |||
INTERNATIONALARTICLENUMBERCAT | Category of International Article Number (EAN) | NUMTP | CHAR | 2(0) | NUMTP | |||||
PRODUCTISCONFIGURABLE | Configurable Material | KZKFG | CHAR | 1(0) | XFELD | |||||
ISBATCHMANAGEMENTREQUIRED | Batch management requirement indicator | XCHPF | CHAR | 1(0) | XFELD | |||||
EXTERNALPRODUCTGROUP | External Product Group | EXTERNALPRODUCTGROUP | CHAR | 18(0) | EXTWG | |||||
CROSSPLANTCONFIGURABLEPRODUCT | Cross-Plant Configurable Product | CROSSPLANTCONFIGURABLEPRODUCT | CHAR | 40(0) | MATN1 | MATNR | ||||
SERIALNOEXPLICITNESSLEVEL | Level of Explicitness for Serial Number | SERLV | CHAR | 1(0) | SERLV | |||||
PRODUCTMANUFACTURERNUMBER | Manufacturer Part Number | MFRPN | CHAR | 40(0) | CHAR40 | |||||
MANUFACTURERNUMBER | Manufacturer number | MFRNR | CHAR | 10(0) | ALPHA | LIFNR | ||||
MANUFACTURERPARTPROFILE | Mfr part profile | MPROF | CHAR | 4(0) | MPROF | |||||
CHANGENUMBER | Change Number | CHANGENUMBER | CHAR | 12(0) | AENNR | AENNR | ||||
MATERIALREVISIONLEVEL | Revision Level | PRODUCTREVISIONLEVEL | CHAR | 2(0) | NUMCV | REVLV | ||||
HANDLINGINDICATOR | Handling Indicator | CIFHDLCODE | CHAR | 4(0) | CHAR4 | |||||
WAREHOUSEPRODUCTGROUP | Warehouse Material Group | CIFWHMATGR | CHAR | 4(0) | CHAR4 | |||||
WAREHOUSESTORAGECONDITION | Warehouse Storage Condition | CIFWHSTC | CHAR | 2(0) | CHAR2 | |||||
STANDARDHANDLINGUNITTYPE | Standard HU Type | CIFHUTYPDF | CHAR | 4(0) | CHAR4 | |||||
SERIALNUMBERPROFILE | Serial Number Profile | CIFSERIAL | CHAR | 4(0) | CIFSERIAL | |||||
ADJUSTMENTPROFILE | Adjustment Profile | CIFADPROF | CHAR | 3(0) | /SCWM/DO_MEDI_APROF | |||||
ISPILFERABLE | Pilferable | CIFPILFRBL | CHAR | 1(0) | XFELD | |||||
ISRELEVANTFORHZDSSUBSTANCES | Relevant for Hazardous Substances | CIFHAZMAT | CHAR | 1(0) | XFELD | |||||
QUARANTINEPERIOD | Quarantine Period | CIFQQTIME | QUAN | 3(0) | ||||||
TIMEUNITFORQUARANTINEPERIOD | Time Unit for Quarantine Period | CIFQQTIMEUOM | UNIT | 3(0) | CUNIT | MEINS | ||||
QUALITYINSPECTIONGROUP | Quality Inspection Group | CIFQGRP | CHAR | 4(0) | CIFQGRP | |||||
HANDLINGUNITTYPE | Handling Unit Type | CIFHUTYP | CHAR | 4(0) | CHAR4 | |||||
HASVARIABLETAREWEIGHT | Variable Tare Weight | CIFTAREVAR | CHAR | 1(0) | XFELD | |||||
MAXIMUMPACKAGINGLENGTH | Maximum Packing Length of Packaging Material | CIFMAXL | QUAN | 15(3) | CIFQUAN15 | |||||
MAXIMUMPACKAGINGWIDTH | Maximum Packing Width of Packaging Material | CIFMAXB | QUAN | 15(3) | CIFQUAN15 | |||||
MAXIMUMPACKAGINGHEIGHT | Maximum Packing Height of Packaging Material | CIFMAXH | QUAN | 15(3) | CIFQUAN15 | |||||
MAXIMUMCAPACITY | Maximum Allowed Capacity of Packaging Material | CIFMAXC | DEC | 15(3) | DECV15_3 | |||||
OVERCAPACITYTOLERANCE | Overcapacity Tolerance of the Handling Unit | CIFMAXCTOL | DEC | 3(1) | DEC2_1 | |||||
UNITFORMAXPACKAGINGDIMENSIONS | Unit of Measure for Maximum Packing Length/Width/Height | CIFMAXDUOM | UNIT | 3(0) | CUNIT | MEINS | ||||
BASEUNITSPECIFICPRODUCTLENGTH | Length | LAENG | QUAN | 13(3) | MENG13 | |||||
BASEUNITSPECIFICPRODUCTWIDTH | Width | BREIT | QUAN | 13(3) | MENG13 | |||||
BASEUNITSPECIFICPRODUCTHEIGHT | Height | HOEHE | QUAN | 13(3) | MENG13 | |||||
PRODUCTMEASUREMENTUNIT | Unit of Dimension for Length/Width/Height | MEABM | UNIT | 3(0) | CUNIT | MEINS | ||||
ARTICLECATEGORY | Product Category | PRODCATEGORY | CHAR | 2(0) | ATTYP | MTY | ||||
CONTENTUNIT | Content unit | INHME | UNIT | 3(0) | CUNIT | MEINS | ||||
NETCONTENT | Net contents | INHAL | QUAN | 13(3) | MENG13 | |||||
COMPARISONPRICEQUANTITY | Comparison price unit | VPREH | DEC | 5(0) | PACK3 | |||||
GROSSCONTENT | Gross contents | INHBR | QUAN | 13(3) | MENG13 | |||||
PRODUCTVALIDENDDATE | Deletion date | LIQDT | DATS | 8(0) | DATUM | |||||
ASSORTMENTLISTTYPE | Assortment List Type | BBTYP | CHAR | 1(0) | BBTYP | WBB | ||||
HASTEXTILEPARTSWTHANIMALORIGIN | Indicator: Contains Non-Textile Parts of Animal Origin | WRF_ANIMAL_ORIGIN_FLAG | CHAR | 1(0) | WRF_ANIMAL_ORIGIN_FLAG | |||||
PRODUCTSEASONUSAGECATEGORY | Indicator: Use of Season | FSH_SEALV | CHAR | 1(0) | FSH_SEALV | FSH_SL | ||||
SERVICEAGREEMENT | Service agreement for a retail material | W_SERVV | CHAR | 2(0) | W_SERVV | |||||
CONSUMPTIONVALUECATEGORY | ABC Indicator | MAABC | CHAR | 1(0) | MAABC | |||||
GOODSISSUEUNIT | Unit of issue | AUSME | UNIT | 3(0) | CUNIT | MEINS | ||||
REGIONOFORIGIN | Region of Origin of Material (Non-Preferential Origin) | HERKR | CHAR | 3(0) | REGIO | |||||
ASSORTMENTGRADE | Assortment grade | SSTUF | CHAR | 2(0) | SSTUF | |||||
PRODEXTASSORTMENTPRIORITY | External assortment priority | PFLKS | CHAR | 1(0) | PFLKS | |||||
SALESUNIT | Sales unit | VRKME | UNIT | 3(0) | CUNIT | MEINS | ||||
VALUATIONCLASS | Valuation Class | BKLAS | CHAR | 4(0) | BKLAS | |||||
VALUATIONMARGIN | Valuation margin | BWSPA | DEC | 6(2) | PRZ32V | |||||
DISTRCNTRSALEENDDATE | Date to which sold in the distribution center | VDBZL | DATS | 8(0) | DATS | |||||
CLASSIFICATIONSIDEEFFECT | Side effect data | VCHCLF_SIDE_EFFECT_DATA | CHAR | 100(0) | ||||||
CONFIGURATIONSIDEEFFECT | Side effect data | VCHCLF_SIDE_EFFECT_DATA | CHAR | 100(0) | ||||||
REFERENCEPRODUCT | Reference Product | REFERENCEPRODUCT | CHAR | 40(0) | MATN1 | MATNR | ||||
PRODUCTDESCRIPTION | Product Description | PRODUCTDESCRIPTION | CHAR | 40(0) | TEXT40 | |||||
AUTHORIZATIONGROUP | Authorization Group | BEGRU | CHAR | 4(0) | BEGRU | |||||
HASEMPTIESBOM | Empties Bill of Material | W_MITLEERG | CHAR | 1(0) | FLAG | |||||
ISCHEMICALCOMPLIANCERELEVANT | Chemical Compliance Relevance Indicator | CHML_CMPLNC_RLVNCE_IND | CHAR | 1(0) | CHCMI | CHML_CMPLNC_RLVNCE_IND | ||||
LABORATORYORDESIGNOFFICE | Laboratory/design office | LABOR | CHAR | 3(0) | LABOR | |||||
HASACTIVEENTITY | Draft - Indicator - Has active document | SDRAFT_HAS_ACTIVE | CHAR | 1(0) | BOOLE | |||||
DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC | 21(7) | TZNTSTMPL | |||||
DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC | 21(7) | TZNTSTMPL | |||||
DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW | 16(0) | SYSUUID | |||||
DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR | 1(0) | SDRAFT_CONSISTENCY_STATUS | |||||
DRAFTENTITYOPERATIONCODE | Draft - Operation Code | SDRAFT_OPERATION_CODE | CHAR | 1(0) | SDRAFT_OPERATION_CODE | |||||
DUMMY_PRD_INCL_EEW_PS | Dummy Field | PRD_INCL_EEW | CHAR | 1(0) | PRD_INCL_EEW | |||||
.INCLU--AP | 0(0) | |||||||||
DFSAMMUNITIONGROUPCODE | Interchangeability Code for Ammunition | DFS_ICFA | CHAR | 8(0) | DFS_ICFA | |||||
DFSRICIDENTIFIER | Reportable Item Code - Numerical ID | /ISDFPS/RIC_ID | INT8 | 19(0) | /ISDFPS/RIC_ID |
Search for further information about these or an SAP related objects