PRD_ROOT - Product: Draft Rloot Node

Product: Draft Rloot Node information is stored in SAP table PRD_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 PRD_ROOT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6
DRAFTKEY	NodeID	X	/BOBF/CONF_KEY	RAW	16
ACTIVEPRODUCT	Product Number		PRODUCTNUMBER	CHAR	80
HASACTIVEENTITY	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')		BOOLE_D	CHAR	2
.INCLUDE				PRD_S_ROOT_D	0
PRODUCT	Product Number		PRODUCTNUMBER	CHAR	80
PRODUCTTYPE	Product Type		PRODUCTTYPE	CHAR	8	*
CREATIONDATE	Created On		CREATIONDATE	DATS	16
CREATEDBYUSER	Created By		CREATEDBYUSER	CHAR	24
LASTCHANGEDATE	Last Changed On		LASTCHANGEDATE	DATS	16
LASTCHANGEDBYUSER	Changed By		LASTCHANGEDBYUSER	CHAR	24
ISMARKEDFORDELETION	Deletion Indicator		ISMARKEDFORDELETION	CHAR	2
CROSSPLANTSTATUS	Cross-Plant Product Status		CROSSPLANTSTATUS	CHAR	4	*
CROSSPLANTSTATUSVALIDITYDATE	Valid From Date for Status		CROSSPLANTSTATUSVALIDITYDATE	DATS	16
PRODUCTOLDID	Old Product Number		PRODUCTOLDID	CHAR	80
GROSSWEIGHT	Gross Weight		GROSSWEIGHT	QUAN	7
PURCHASEORDERQUANTITYUNIT	Order Unit		PURORDERQUANTITYUNIT	UNIT	6	*
SOURCEOFSUPPLY	Source of Supply		PRODUCTSOURCEOFSUPPLY	CHAR	2	*
WEIGHTUNIT	Weight Unit		WEIGHTUNIT	UNIT	6	*
COMPETITORID	Customer Number		COMPETITORID	CHAR	20
COUNTRYOFORIGIN	Ctry/Reg. of Origin of Product (Non-Preferential Origin)		COUNTRYOFORIGIN	CHAR	6	*
PRODUCTGROUP	Product Group		PRODUCTGROUP	CHAR	18
BASEUNIT	Base Unit of Measure		PRODUCTBASEUNIT	UNIT	6	*
ITEMCATEGORYGROUP	General Item Category Group		ITEMCATEGORYGROUP	CHAR	8	*
NETWEIGHT	Net-Weight		NETWEIGHT	QUAN	7
PRODUCTHIERARCHY	Product Hierarchy		PRODUCTHIERARCHY	CHAR	36	*
DIVISION	Division		PRODUCTDIVISION	CHAR	4
VARBLPURORDUNITISACTIVE	Variable Purchase Order Unit Active		VARBLPURORDUNITISACTIVE	CHAR	2
VOLUMEUNIT	Volume unit		VOLUMEUNIT	UNIT	6	*
MATERIALVOLUME	Volume		MATERIALVOLUME	QUAN	7
ANPCODE	ANP Code		ANPCODE	NUMC	18	*
PRODUCTCATEGORY	Product Category		PRODCATEGORY	CHAR	4
BRAND	Brand		PRODUCTBRAND	CHAR	8	*
PROCUREMENTRULE	Procurement rule		PROCUREMENTRULE	CHAR	2	*
VALIDITYSTARTDATE	Valid-From Date		VALIDITYSTARTDATE	DATS	16
LOWLEVELCODE	Low-Level Code		LOWLEVELCODE	CHAR	6
PRODNOINGENPRODINPREPACKPROD	Internal license number		PRODNOINGENPRODINPREPACKPROD	CHAR	20
SERIALIDENTIFIERASSGMTPROFILE	Serial Number Profile		SERIALIDENTIFIERASSGMTPROFILE	CHAR	8
SIZEORDIMENSIONTEXT	Size/dimensions		SIZEORDIMENSIONTEXT	CHAR	64
INDUSTRYSTANDARDNAME	Industry Standard Description		INDUSTRYSTANDARDNAME	CHAR	36
PRODUCTSTANDARDID	International Article Number (EAN/UPC)		PRODUCTSTANDARDID	CHAR	36
INTERNATIONALARTICLENUMBERCAT	Category of Global Trade Item Number (GTIN)		INTERNATIONALARTICLENUMBERCAT	CHAR	4	*
PRODUCTISCONFIGURABLE	Product is Configurable		PRODUCTISCONFIGURABLE	CHAR	2
ISBATCHMANAGEMENTREQUIRED	Is Batch Management Required?		ISBATCHMANAGEMENTREQUIRED	CHAR	2
EXTERNALPRODUCTGROUP	External Product Group		EXTERNALPRODUCTGROUP	CHAR	36	*
CROSSPLANTCONFIGURABLEPRODUCT	Cross-Plant Configurable Product		CROSSPLANTCONFIGURABLEPRODUCT	CHAR	80	*
SERIALNOEXPLICITNESSLEVEL	Level of Explicitness for Serial Number		SERIALNOEXPLICITNESSLEVEL	CHAR	2
PRODUCTMANUFACTURERNUMBER	Manufacturer Part Number		PRODUCTMANUFACTURERNUMBER	CHAR	80
MANUFACTURERPARTPROFILE	Manufacturer Part Profile		MANUFACTURERPARTPROFILE	CHAR	8	*
BASEUNITSPECIFICPRODUCTLENGTH	Length		BASEUNITSPECIFICPRODUCTLENGTH	QUAN	7
BASEUNITSPECIFICPRODUCTWIDTH	Width		BASEUNITSPECIFICPRODUCTWIDTH	QUAN	7
BASEUNITSPECIFICPRODUCTHEIGHT	Height		BASEUNITSPECIFICPRODUCTHEIGHT	QUAN	7
PRODUCTMEASUREMENTUNIT	Unit of Dimension for Length/Width/Height		PRODUCTMEASUREMENTUNIT	UNIT	6	*
PRODUCTVALIDSTARTDATE	Valid-From Date		PRODUCTVALIDSTARTDATE	DATS	16
ARTICLECATEGORY	Product Category		ARTICLECATEGORY	CHAR	4
CONTENTUNIT	Content unit		CONTENTUNIT	UNIT	6	*
NETCONTENT	Net contents		NETCONTENT	QUAN	7
COMPARISONPRICEQUANTITY	Comparison price unit		COMPARISONPRICEQUANTITY	DEC	3
GROSSCONTENT	Gross contents		GROSSCONTENT	QUAN	7
PRODUCTVALIDENDDATE	Deletion date		PRODUCTVALIDENDDATE	DATS	16
ASSORTMENTLISTTYPE	Assortment List Type		ASSORTMENTLISTTYPE	CHAR	2	*
HASTEXTILEPARTSWTHANIMALORIGIN	Indicator: Contains Non-Textile Parts of Animal Origin		HASTEXTILEPARTSWTHANIMALORIGIN	CHAR	2
PRODUCTSEASONUSAGECATEGORY	Indicator: Use of Season		PRODUCTSEASONUSAGECATEGORY	CHAR	2
SERVICEAGREEMENT	Service agreement for a retail material		SERVICEAGREEMENT	CHAR	4	*
ASSORTMENTGRADE	Assortment Grade		ASSORTMENTGRADE	CHAR	4	*
STORELISTINGPROCEDURE	Listing procedure for store or other assortment categories		STORELISTINGPROCEDURE	CHAR	4	*
DISTRCNTRLISTINGPROCEDURE	Listing procedure for distr. center assortment categories		DISTRCNTRLISTINGPROCEDURE	CHAR	4	*
STORELISTINGSTARTDATE	Date from which listed in the store		STORELISTINGSTARTDATE	DATS	16
STORELISTINGENDDATE	Date to which listed in the store		STORELISTINGENDDATE	DATS	16
DISTRCNTRLISTINGSTARTDATE	Date from which listed in the distribution center		DISTRCNTRLISTINGSTARTDATE	DATS	16
DISTRCNTRLISTINGENDDATE	Date to which listed in the central warehouse/distr. center		DISTRCNTRLISTINGENDDATE	DATS	16
STORESALESTARTDATE	Date from which sold in the store		STORESALESTARTDATE	DATS	16
STORESALEENDDATE	Date to which sold in the store		STORESALEENDDATE	DATS	16
DISTRCNTRSALESTARTDATE	Date from which sold in the distribution center		DISTRCNTRSALESTARTDATE	DATS	16
DISTRCNTRSALEENDDATE	Date to which sold in the distribution center		DISTRCNTRSALEENDDATE	DATS	16
COMMODITIYCODENUMBERUNIT	Unit of measure for commodity code (foreign trade)		COMMODITIYCODENUMBERUNIT	UNIT	6	*
COMMODITYCODE	Commodity Code		COMMODITYCODENUMBER	CHAR	34	*
CONSUMPTIONVALUECATEGORY	ABC Indicator		CONSUMPTIONVALUECATEGORY	CHAR	2	*
GOODSISSUEUNIT	Unit of Issue		GOODSISSUEUNIT	UNIT	6	*
REGIONOFORIGIN	Region of Origin		REGIONOFORIGIN	CHAR	6	*
VALUATIONCLASS	Valuation Class		VALUATIONCLASS	CHAR	8	*
COMMODITYCODENUMBER	Commodity Code		COMMODITYCODENUMBER	CHAR	34	*
VALUATIONMARGIN	Valuation margin		VALUATIONMARGIN	DEC	4
.INCLUDE				PRD_INCL_EEW_PS	0
DUMMY_PRD_INCL_EEW_PS	Dummy Field		PRD_INCL_EEW	CHAR	2