PROD_ROOT - I_PRODUCTWD I_PRODUCTWD

I_PRODUCTWD I_PRODUCTWD information is stored in SAP table PROD_ROOT.
It is part of development package VDM_MD_PRODUCT in software component LO-MD-MM. This development package consists of objects that can be grouped under "VDM Master Data Product".

Fields for table PROD_ROOT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
DRAFTUUID	UUID serving as key (parent key, root key)	X	/BOBF/UUID	RAW	16
PRODUCT	Product Number		PRODUCTNUMBER	CHAR	80
PRODUCTFOREDIT	Product Number		PRODUCTNUMBER	CHAR	80
PRODUCTTYPE	Product Type		PRODUCTTYPE	CHAR	8
CROSSPLANTSTATUS	Cross-Plant Product Status		CROSSPLANTSTATUS	CHAR	4
CROSSPLANTSTATUSVALIDITYDATE	Date from which the cross-plant material status is valid		MSTDE	DATS	16
CREATIONDATE	Created On		ERSDA	DATS	16
CREATIONTIME	Time of Creation		CREATED_AT_TIME	TIMS	12
CREATIONDATETIME	Product Created On		CMD_PRD_CREATION_DATE_TIME	DEC	11
CREATEDBYUSER	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
LASTCHANGEDATE	Date of Last Change		LAEDA	DATS	16
LASTCHANGETIME	Time of Last Change		LAST_CHANGED_TIME	TIMS	12
LASTCHANGEDATETIME	Change Time Stamp		CHANGEDATETIME	DEC	11
LASTCHANGEDBYUSER	Name of Person Who Changed Object		AENAM	CHAR	24
ISMARKEDFORDELETION	Deletion Indicator		ISMARKEDFORDELETION	CHAR	2
PRODUCTOLDID	Old Product Number		PRODUCTOLDID	CHAR	80
GROSSWEIGHT	Gross weight		BRGEW	QUAN	7
WEIGHTUNIT	Weight Unit		GEWEI	UNIT	6
NETWEIGHT	Net weight		NTGEW	QUAN	7
COUNTRYOFORIGIN	Country/Region of Origin of Product		CMD_PRD_COUNTRYOFORIGIN	CHAR	6
COMPETITORID	Competitor		WETTB	CHAR	20
PRODUCTGROUP	Product Group		PRODUCTGROUP	CHAR	18
BASEUNIT	Base Unit of Measure		MEINS	UNIT	6
ITEMCATEGORYGROUP	General item category group		MTPOS_MARA	CHAR	8
PRODUCTHIERARCHY	Product hierarchy		PRODH_D	CHAR	36
DIVISION	Division		SPART	CHAR	4
VOLUMEUNIT	Volume unit		VOLEH	UNIT	6
MATERIALVOLUME	Volume		MATERIALVOLUME	QUAN	7
ANPCODE	ANP Code		J_1BANP	NUMC	18
BRAND	Brand		WRF_BRAND_ID	CHAR	8
VALIDITYSTARTDATE	Valid-From Date		DATAB	DATS	16
PRODNOINGENPRODINPREPACKPROD	Material Number of the Generic Material in Prepack Materials		WSTR_SATNR_PP	CHAR	80
SIZEORDIMENSIONTEXT	Size/dimensions		GROES	CHAR	64
INDUSTRYSTANDARDNAME	Industry Standard Description (such as ANSI or ISO)		NORMT	CHAR	36
PRODUCTSTANDARDID	Global Trade Item Number (EAN/UPC/GTIN)		GLOBALTRADEITEMNUMBER	CHAR	36
INTERNATIONALARTICLENUMBERCAT	Category of International Article Number (EAN)		NUMTP	CHAR	4
PRODUCTISCONFIGURABLE	Product is Configurable		PRODUCTISCONFIGURABLE	CHAR	2
ISBATCHMANAGEMENTREQUIRED	Batch Management Requirement Indicator		XCHPF	CHAR	2
EXTERNALPRODUCTGROUP	External Product Group		EXTERNALPRODUCTGROUP	CHAR	36
CROSSPLANTCONFIGURABLEPRODUCT	Cross-Plant Configurable Product		CROSSPLANTCONFIGURABLEPRODUCT	CHAR	80
SERIALNOEXPLICITNESSLEVEL	Level of Explicitness for Serial Number		SERLV	CHAR	2
PRODUCTMANUFACTURERNUMBER	Manufacturer Part Number		MFRPN	CHAR	80
MANUFACTURERNUMBER	Manufacturer number		MFRNR	CHAR	20
MANUFACTURERPARTPROFILE	Mfr part profile		MPROF	CHAR	8
CHANGENUMBER	Change Number		CHANGENUMBER	CHAR	24
MATERIALREVISIONLEVEL	Revision Level		PRODUCTREVISIONLEVEL	CHAR	4
HANDLINGINDICATOR	Handling Indicator		CIFHDLCODE	CHAR	8
WAREHOUSEPRODUCTGROUP	Warehouse Material Group		CIFWHMATGR	CHAR	8
WAREHOUSESTORAGECONDITION	Warehouse Storage Condition		CIFWHSTC	CHAR	4
STANDARDHANDLINGUNITTYPE	Standard HU Type		CIFHUTYPDF	CHAR	8
SERIALNUMBERPROFILE	Serial Number Profile		CIFSERIAL	CHAR	8
ADJUSTMENTPROFILE	Adjustment Profile		CIFADPROF	CHAR	6
ISPILFERABLE	Pilferable		CIFPILFRBL	CHAR	2
ISRELEVANTFORHZDSSUBSTANCES	Relevant for Hazardous Substances		CIFHAZMAT	CHAR	2
QUARANTINEPERIOD	Quarantine Period		CIFQQTIME	QUAN	2
TIMEUNITFORQUARANTINEPERIOD	Time Unit for Quarantine Period		CIFQQTIMEUOM	UNIT	6
QUALITYINSPECTIONGROUP	Quality Inspection Group		CIFQGRP	CHAR	8
HANDLINGUNITTYPE	Handling Unit Type		CIFHUTYP	CHAR	8
HASVARIABLETAREWEIGHT	Variable Tare Weight		CIFTAREVAR	CHAR	2
MAXIMUMPACKAGINGLENGTH	Maximum Packing Length of Packaging Material		CIFMAXL	QUAN	8
MAXIMUMPACKAGINGWIDTH	Maximum Packing Width of Packaging Material		CIFMAXB	QUAN	8
MAXIMUMPACKAGINGHEIGHT	Maximum Packing Height of Packaging Material		CIFMAXH	QUAN	8
MAXIMUMCAPACITY	Maximum Allowed Capacity of Packaging Material		CIFMAXC	DEC	8
OVERCAPACITYTOLERANCE	Overcapacity Tolerance of the Handling Unit		CIFMAXCTOL	DEC	2
UNITFORMAXPACKAGINGDIMENSIONS	Unit of Measure for Maximum Packing Length/Width/Height		CIFMAXDUOM	UNIT	6
BASEUNITSPECIFICPRODUCTLENGTH	Length		LAENG	QUAN	7
BASEUNITSPECIFICPRODUCTWIDTH	Width		BREIT	QUAN	7
BASEUNITSPECIFICPRODUCTHEIGHT	Height		HOEHE	QUAN	7
PRODUCTMEASUREMENTUNIT	Unit of Dimension for Length/Width/Height		MEABM	UNIT	6
ARTICLECATEGORY	Product Category		PRODCATEGORY	CHAR	4
CONTENTUNIT	Content unit		INHME	UNIT	6
NETCONTENT	Net contents		INHAL	QUAN	7
COMPARISONPRICEQUANTITY	Comparison price unit		VPREH	DEC	3
GROSSCONTENT	Gross contents		INHBR	QUAN	7
PRODUCTVALIDENDDATE	Deletion date		LIQDT	DATS	16
ASSORTMENTLISTTYPE	Assortment List Type		BBTYP	CHAR	2
HASTEXTILEPARTSWTHANIMALORIGIN	Indicator: Contains Non-Textile Parts of Animal Origin		WRF_ANIMAL_ORIGIN_FLAG	CHAR	2
PRODUCTSEASONUSAGECATEGORY	Indicator: Use of Season		FSH_SEALV	CHAR	2
SERVICEAGREEMENT	Service agreement for a retail material		W_SERVV	CHAR	4
CONSUMPTIONVALUECATEGORY	ABC Indicator		MAABC	CHAR	2
GOODSISSUEUNIT	Unit of issue		AUSME	UNIT	6
REGIONOFORIGIN	Region of Origin of Material (Non-Preferential Origin)		HERKR	CHAR	6
ASSORTMENTGRADE	Assortment grade		SSTUF	CHAR	4
PRODEXTASSORTMENTPRIORITY	External assortment priority		PFLKS	CHAR	2
SALESUNIT	Sales unit		VRKME	UNIT	6
VALUATIONCLASS	Valuation Class		BKLAS	CHAR	8
VALUATIONMARGIN	Valuation margin		BWSPA	DEC	4
DISTRCNTRSALEENDDATE	Date to which sold in the distribution center		DISTRCNTRSALEENDDATE	DATS	16
CLASSIFICATIONSIDEEFFECT	Side effect data		VCHCLF_SIDE_EFFECT_DATA	CHAR	200
CONFIGURATIONSIDEEFFECT	Side effect data		VCHCLF_SIDE_EFFECT_DATA	CHAR	200
REFERENCEPRODUCT	Reference Product		REFERENCEPRODUCT	CHAR	80
PRODUCTDESCRIPTION	Product Description		PRODUCTDESCRIPTION	CHAR	80
AUTHORIZATIONGROUP	Authorization Group		BEGRU	CHAR	8
HASEMPTIESBOM	Empties Bill of Material		W_MITLEERG	CHAR	2
ISCHEMICALCOMPLIANCERELEVANT	Chemical Compliance Relevance Indicator		CHML_CMPLNC_RLVNCE_IND_PM	CHAR	2
LABORATORYORDESIGNOFFICE	Laboratory/design office		LABOR	CHAR	6
PACKAGINGMATERIALGROUP	Material Group: Packaging Materials		MAGRV	CHAR	8
PRODUCTDOCUMENTNUMBER	Document number (without document management system)		DZEINR	CHAR	44
PRODUCTDOCUMENTVERSION	Document version (without Document Management system)		DZEIVR	CHAR	4
PRODUCTDOCUMENTTYPE	Document type (without Document Management system)		DZEIAR	CHAR	6
PRODUCTDOCUMENTCHANGENUMBER	Document change number (without document management system)		AESZN	CHAR	12
PRODUCTDOCUMENTPAGECOUNT	Number of sheets (without Document Management system)		BLANZ	NUMC	6
PRODUCTDOCUMENTPAGENUMBER	Page number of document (without Document Management system)		BLATT	CHAR	6
PRODUCTDOCUMENTPAGEFORMAT	Page format of document (without Document Management system)		DZEIFO	CHAR	8
HASACTIVEENTITY	Draft - Indicator - Has active document		SDRAFT_HAS_ACTIVE	CHAR	2
.INCLUDE				SDRAFT_WRITE_DRAFT_ADMIN	0
DRAFTENTITYCREATIONDATETIME	Draft Created On		SDRAFT_CREATED_AT	DEC	11
DRAFTENTITYLASTCHANGEDATETIME	Draft Last Changed On		SDRAFT_LAST_CHANGED_AT	DEC	11
DRAFTADMINISTRATIVEDATAUUID	Technical ID for the Administrative Data of a Draft Document		SDRAFT_ADMIN_UUID	RAW	16
DRAFTENTITYCONSISTENCYSTATUS	Draft - Consistency Status		SDRAFT_CONSISTENCY_STATUS	CHAR	2
DRAFTENTITYOPERATIONCODE	Draft - Operation Code		SDRAFT_OPERATION_CODE	CHAR	2
.INCLUDE				PRD_INCL_EEW_PS	0
DUMMY_PRD_INCL_EEW_PS	Dummy Field		PRD_INCL_EEW	CHAR	2
.INCLUDE				PRT_INCL_EEW_PS	0
DUMMY_PRT_INCL_EEW_PS	Dummy Field		PRT_INCL_EEW	CHAR	2
.INCLU--AP				DFS_PRODUCT_APPEND	0
.INCLUDE				DFS_MARA_VDM	0
DFSAMMUNITIONGROUPCODE	Interchangeability Code for Ammunition		DFS_ICFA	CHAR	16
DFSRICIDENTIFIER	Reportable Item Code - Numerical ID		/ISDFPS/RIC_ID	INT8	8
DFSPRODUCTSENSITIVITY	Sensitivity for Characteristics		DFS_SENSITIVITY_KEY	CHAR	8	*
DFSMANUFACTURERPARTLONGNUMBER	Long Manufacturer Part Number		DFS_MFRP2	CHAR	120
DFSNATIONALITEMIDNNUMBER	NATO Stock Number		DFPS_NSNID	CHAR	18
DFSRETURNDELIVERY	Return Code		DFPS_RETDELC	CHAR	2
DFSLOGISTICSLEVEL	Return to Logistics Level		DFPS_LOGLEV_RETO	CHAR	2
DFSMATLCONDITIONMGMT	Material Condition Management		DFPS_MCOND	CHAR	2
.INCLU--AP				LMD_PRODUCT_APPEND	0
.INCLUDE				LMD_MARA_VDM	0
LSTMIPRODUCTTOLERANCETYPE	Tolerance Type		LMD_MDE_TOLERANCE_TYPE	CHAR	8	*