PRD_SALES_DEL - Product: Draft Sales Delivery Node

Product: Draft Sales Delivery Node information is stored in SAP table PRD_SALES_DEL.
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_SALES_DEL

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
PARENTDRAFTKEY	NodeID		/BOBF/CONF_KEY	RAW	16
HASACTIVEENTITY	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')		BOOLE_D	CHAR	2
.INCLUDE				PRD_S_SALES_DELIVERY_D	0
ACTIVEPRODUCT	Product Number		PRODUCTNUMBER	CHAR	80
ACTIVEPRODUCTSALESORG	Sales Organization		PRODUCTSALESORGANIZATION	CHAR	8
ACTIVEPRODUCTSALESCHANNEL	Distribution Channel		PRODUCTDISTRIBUTIONCHANNEL	CHAR	4
ACTIVEPRODUCTDISTRIBUTIONCHNL	Distribution Channel		PRODUCTDISTRIBUTIONCHANNEL	CHAR	4
PRODUCTSALESORGANIZATION	Sales Organization		PRODUCTSALESORGANIZATION	CHAR	8
PRODUCTDISTRIBUTIONCHANNEL	Distribution Channel		PRODUCTDISTRIBUTIONCHANNEL	CHAR	4
MINIMUMORDERQUANTITY	Minimum Order Quantity		MINIMUMORDERQUANTITY	QUAN	7
SUPPLYINGPLANT	Delivery Plant		SUPPLYINGPLANT	CHAR	8
PRICESPECIFICATIONPRODUCTGROUP	Product Pricing Group		PRICESPECIFICATIONPRODUCTGROUP	CHAR	4	*
ACCOUNTDETNPRODUCTGROUP	Accounting Assignment Group		ACCOUNTDETNPRODUCTGROUP	CHAR	4	*
DELIVERYNOTEPROCMINDELIVQTY	Minimum Delivery Quantity		DELIVERYNOTEPROCMINDELIVQTY	QUAN	7
ITEMCATEGORYGROUP	General Item Category Group		ITEMCATEGORYGROUP	CHAR	8	*
DELIVERYQUANTITYUNIT	Unit of measure of delivery unit		DELIVERYQUANTITYUNIT	UNIT	6	*
DELIVERYQUANTITY	Delivery Unit		DELIVERYQUANTITY	QUAN	7
PRODUCTSALESSTATUS	Dist.chain-specific Product Status		PRODUCTSALESSTATUS	CHAR	4	*
PRODUCTSALESSTATUSVALIDITYDATE	Valid From Date for Status		PRODUCTSALESSTATUSVALIDITYDATE	DATS	16
SALESMEASUREUNIT	Sales Unit		SALESMEASUREUNIT	UNIT	6	*
ISMARKEDFORDELETION	Deletion Indicator		ISMARKEDFORDELETION	CHAR	2
PRODUCTHIERARCHY	Product Hierarchy		PRODUCTHIERARCHY	CHAR	36	*
FIRSTSALESSPECPRODUCTGROUP	Product Group 1		FIRSTSALESSPECPRODUCTGROUP	CHAR	6	*
SECONDSALESSPECPRODUCTGROUP	Product Group 2		SECONDSALESSPECPRODUCTGROUP	CHAR	6	*
THIRDSALESSPECPRODUCTGROUP	Product Group 3		THIRDSALESSPECPRODUCTGROUP	CHAR	6	*
FOURTHSALESSPECPRODUCTGROUP	Product Group 4		FOURTHSALESSPECPRODUCTGROUP	CHAR	6	*
FIFTHSALESSPECPRODUCTGROUP	Product Group 5		FIFTHSALESSPECPRODUCTGROUP	CHAR	6	*
MINIMUMMAKETOORDERORDERQTY	Minimum Make-to-Order Quantity		MINIMUMMAKETOORDERORDERQTY	QUAN	7
LOGISTICSSTATISTICSGROUP	Statistics group		LOGISTICSSTATISTICSGROUP	CHAR	2	*
VOLUMEREBATEGROUP	Volume rebate group		VOLUMEREBATEGROUP	CHAR	4	*
PRODUCTCOMMISSIONGROUP	Commission group		PRODUCTCOMMISSIONGROUP	CHAR	4	*
CASHDISCOUNTISDEDUCTIBLE	Cash discount indicator		CASHDISCOUNTISDEDUCTIBLE	CHAR	2
PRICINGREFERENCEPRODUCT	Cross-Distribution-Chain Pricing Reference Material		PRICINGREFERENCEPRODUCT	CHAR	80	*
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
ROUNDINGPROFILE	Rounding Profile		ROUNDINGPROFILE	CHAR	8	*
PRODUCTUNITGROUP	Unit of Measure Group		PRODUCTUNITGROUP	CHAR	8	*
MAXDELIVERYQTYSTOREORDER	Maximum delivery quantity in store order processing		MAXDELIVERYQTYSTOREORDER	QUAN	7
PRICEFIXINGCATEGORY	Indicator for price fixing		PRICEFIXINGCATEGORY	CHAR	2
VARIABLESALESUNITISNOTALLOWED	Variable Sales Unit Not Allowed		VARIABLESALESUNITISNOTALLOWED	CHAR	2
COMPETITIONPRESSURECATEGORY	Competition characterization of a product		COMPETITIONPRESSURECATEGORY	CHAR	2
.INCLUDE				SALD_INCL_EEW_PS	0
DUMMY_SALD_INCL_EEW_PS	MD Product Sales Delivery		SALD_INCL_EEW	CHAR	2