I_ProductSalesDeliveryWD

Product BO - Sales Delivery Node (draft) | view: IPRDSALESDELIVWD | Extraction: Not supported | Component: Material Master

Tables used: MARA, MARA, MVKE

🔑 Keys (3)
💰 Amounts
∑ Quantities (5)
📅 Dates (9)
☰ Categorical (8)
Other (6)
🔗 Relations (30)

Column Name	Description
Product FK	Product Number
ProductSalesOrg FK	Sales Organization
ProductDistributionChnl FK	Distribution Channel

Column Name	Description

Column Name	Description
📏 Base Unit of Measure (BaseUnit):
MinimumOrderQuantity	Minimum order quantity in base unit of measure
DeliveryNoteProcMinDelivQty	Minimum Delivery Quantity in Delivery Note Processing
MinimumMakeToOrderOrderQty	Minimum make-to-order quantity
MaxDeliveryQtyStoreOrder	Maximum delivery quantity in store order processing
📏 Unit of measure of delivery unit (DeliveryQuantityUnit):
DeliveryQuantity	Delivery unit

Column Name	Description
ProductSalesStatusValidityDate	Date from which distr.-chain-spec. material status is valid
StoreListingStartDate	Date from which listed in the store
StoreListingEndDate	Date to which listed in the store
DistrCntrListingStartDate	Date from which listed in the distribution center
DistrCntrListingEndDate	Date to which listed in the central warehouse/distr. center
StoreSaleStartDate	Date from which sold in the store
StoreSaleEndDate	Date to which sold in the store
DistrCntrSaleStartDate	Date from which sold in the distribution center
DistrCntrSaleEndDate	Date to which sold in the distribution center

Column Name	Description
IsMarkedForDeletion	Ind.: Flag material for deletion at distribution chain level	Show values
CashDiscountIsDeductible	Cash Discount Indicator	Show values
PriceFixingCategory	Indicator for price fixing	Show values
VariableSalesUnitIsNotAllowed	Variable Sales Unit Not Allowed	Show values
CompetitionPressureCategory	Competition characterization of a material	Show values
ProdIsEntlmntRlvt	Relevant for Entitlement Generation	Show values
SubscrpnContrDurationUnit	Unit for Contract Term	Show values
SubscrpnContrExtnDurnUnit	Unit for Extension Period	Show values

Column Name	Description	Domain name
SubscrpnContrDfltDuration	Default Contract Term	CRMT_CTR_DUR
SubscrpnContrAltvDuration1	Alternative Contract Term 1	CRMT_CTR_DUR
SubscrpnContrAltvDuration2	Alternative Contract Term 2	CRMT_CTR_DUR
SubscrpnContrDfltExtnDurn	Default Extension Period	CRMT_CTR_TRM_EXT
SubscrpnContrAltvExtnDurn1	Alternative Extension Period 1	CRMT_CTR_TRM_EXT
SubscrpnContrAltvExtnDurn2	Alternative Extension Period 2	CRMT_CTR_TRM_EXT

Master Data Relations	Join Conditions
Account assignment group for the material Client Account Assignment Group for Material	`I_PRODUCTSALESDELIVERYWD.MANDT == TVKM.MANDT` `I_PRODUCTSALESDELIVERYWD.ACCOUNTDETNPRODUCTGROUP == TVKM.KTGRM`
Assortment grade Client Assortment grade	`I_PRODUCTSALESDELIVERYWD.MANDT == TWSS.MANDT` `I_PRODUCTSALESDELIVERYWD.ASSORTMENTGRADE == TWSS.SSTUF`
Unit of Measure Client Base Unit of Measure	`I_PRODUCTSALESDELIVERYWD.MANDT == T006.MANDT` `I_PRODUCTSALESDELIVERYWD.BASEUNIT == T006.MSEHI`
Unit of measure Client Unit of measure of delivery unit	`I_PRODUCTSALESDELIVERYWD.MANDT == T006.MANDT` `I_PRODUCTSALESDELIVERYWD.DELIVERYQUANTITYUNIT == T006.MSEHI`
Listing procedure for distr. center assortment categories Client Listing procedure for distr. center assortment categories	`I_PRODUCTSALESDELIVERYWD.MANDT == TWLV.MANDT` `I_PRODUCTSALESDELIVERYWD.DISTRCNTRLISTINGPROCEDURE == TWLV.LSTFL`
Product Group 5 Client Product Group 5	`I_PRODUCTSALESDELIVERYWD.MANDT == TVM5.MANDT` `I_PRODUCTSALESDELIVERYWD.FIFTHSALESSPECPRODUCTGROUP == TVM5.MVGR5`
Product Group 1 Client Product Group 1	`I_PRODUCTSALESDELIVERYWD.MANDT == TVM1.MANDT` `I_PRODUCTSALESDELIVERYWD.FIRSTSALESSPECPRODUCTGROUP == TVM1.MVGR1`
Product Group 4 Client Product Group 4	`I_PRODUCTSALESDELIVERYWD.MANDT == TVM4.MANDT` `I_PRODUCTSALESDELIVERYWD.FOURTHSALESSPECPRODUCTGROUP == TVM4.MVGR4`
Item category group Client Item Category Group from Material Master	`I_PRODUCTSALESDELIVERYWD.MANDT == TPTM.MANDT` `I_PRODUCTSALESDELIVERYWD.ITEMCATEGORYGROUP == TPTM.MTPOS`
Shipping statistics group Client Material statistics group	`I_PRODUCTSALESDELIVERYWD.MANDT == TVSM.MANDT` `I_PRODUCTSALESDELIVERYWD.LOGISTICSSTATISTICSGROUP == TVSM.STGMA`
Condition group Client Product Pricing Group	`I_PRODUCTSALESDELIVERYWD.MANDT == T178.MANDT` `I_PRODUCTSALESDELIVERYWD.PRICESPECIFICATIONPRODUCTGROUP == T178.KONDM`
Price group Client Pricing Reference Material	`I_PRODUCTSALESDELIVERYWD.MANDT == MARA.MANDT` `I_PRODUCTSALESDELIVERYWD.PRICINGREFERENCEPRODUCT == MARA.MATNR`
External assortment priority Client External assortment priority	`I_PRODUCTSALESDELIVERYWD.MANDT == TWSP.MANDT` `I_PRODUCTSALESDELIVERYWD.PRODEXTASSORTMENTPRIORITY == TWSP.PFLKS`
Material No. Client Product Number Product Number	`I_PRODUCTSALESDELIVERYWD.MANDT == MARA.MANDT` `I_PRODUCTSALESDELIVERYWD.PRODUCT == MARA.MATNR` `I_PRODUCTSALESDELIVERYWD.PRODUCTFOREDIT == MARA.MATNR`
Commission group Client Commission Group	`I_PRODUCTSALESDELIVERYWD.MANDT == TVPR.MANDT` `I_PRODUCTSALESDELIVERYWD.PRODUCTCOMMISSIONGROUP == TVPR.PROVG`
Distribution channel Client Distribution Channel Distribution Channel	`I_PRODUCTSALESDELIVERYWD.MANDT == TVTW.MANDT` `I_PRODUCTSALESDELIVERYWD.PRODUCTDISTRIBUTIONCHNLFOREDIT == TVTW.VTWEG` `I_PRODUCTSALESDELIVERYWD.PRODUCTDISTRIBUTIONCHNL == TVTW.VTWEG`
Distribution channel Client Distribution Channel Distribution Channel	`I_PRODUCTSALESDELIVERYWD.MANDT == TVTW.MANDT` `I_PRODUCTSALESDELIVERYWD.PRODUCTDISTRIBUTIONCHNLFOREDIT == TVTW.VTWEG` `I_PRODUCTSALESDELIVERYWD.PRODUCTDISTRIBUTIONCHNL == TVTW.VTWEG`
Material No. Client Product Number Product Number	`I_PRODUCTSALESDELIVERYWD.MANDT == MARA.MANDT` `I_PRODUCTSALESDELIVERYWD.PRODUCT == MARA.MATNR` `I_PRODUCTSALESDELIVERYWD.PRODUCTFOREDIT == MARA.MATNR`
Product hierarchy Client Product hierarchy	`I_PRODUCTSALESDELIVERYWD.MANDT == T179.MANDT` `I_PRODUCTSALESDELIVERYWD.PRODUCTHIERARCHY == T179.PRODH`
Sales organization Client Sales Organization Sales Organization	`I_PRODUCTSALESDELIVERYWD.MANDT == TVKO.MANDT` `I_PRODUCTSALESDELIVERYWD.PRODUCTSALESORG == TVKO.VKORG` `I_PRODUCTSALESDELIVERYWD.PRODUCTSALESORGFOREDIT == TVKO.VKORG`
Sales organization Client Sales Organization Sales Organization	`I_PRODUCTSALESDELIVERYWD.MANDT == TVKO.MANDT` `I_PRODUCTSALESDELIVERYWD.PRODUCTSALESORG == TVKO.VKORG` `I_PRODUCTSALESDELIVERYWD.PRODUCTSALESORGFOREDIT == TVKO.VKORG`
Material status for sales Client Distribution-chain-specific material status	`I_PRODUCTSALESDELIVERYWD.MANDT == TVMS.MANDT` `I_PRODUCTSALESDELIVERYWD.PRODUCTSALESSTATUS == TVMS.VMSTA`
Rounding profile Client ? Rounding Profile Delivering Plant (Own or External)	`I_PRODUCTSALESDELIVERYWD.MANDT == RDPR.MANDT` `I_PRODUCTSALESDELIVERYWD.[column in domain "RDZAE"] == RDPR.RDZAE` `I_PRODUCTSALESDELIVERYWD.ROUNDINGPROFILE == RDPR.RDPRF` `I_PRODUCTSALESDELIVERYWD.SUPPLYINGPLANT == RDPR.WERKS`
Unit of measure Client Sales unit	`I_PRODUCTSALESDELIVERYWD.MANDT == T006.MANDT` `I_PRODUCTSALESDELIVERYWD.SALESMEASUREUNIT == T006.MSEHI`
Product Group 2 Client Product Group 2	`I_PRODUCTSALESDELIVERYWD.MANDT == TVM2.MANDT` `I_PRODUCTSALESDELIVERYWD.SECONDSALESSPECPRODUCTGROUP == TVM2.MVGR2`
Listing procedure for store or other assortment categories Listing procedure for store or other assortment categories Client	`I_PRODUCTSALESDELIVERYWD.STORELISTINGPROCEDURE == TWLV.LSTFL` `I_PRODUCTSALESDELIVERYWD.MANDT == TWLV.MANDT`
Default plant Client Sales Organization Sales Organization Delivering Plant (Own or External) Distribution Channel Distribution Channel	`I_PRODUCTSALESDELIVERYWD.MANDT == TVKWZ.MANDT` `I_PRODUCTSALESDELIVERYWD.PRODUCTSALESORG == TVKWZ.VKORG` `I_PRODUCTSALESDELIVERYWD.PRODUCTSALESORGFOREDIT == TVKWZ.VKORG` `I_PRODUCTSALESDELIVERYWD.SUPPLYINGPLANT == TVKWZ.WERKS` `I_PRODUCTSALESDELIVERYWD.PRODUCTDISTRIBUTIONCHNLFOREDIT == TVKWZ.VTWEG` `I_PRODUCTSALESDELIVERYWD.PRODUCTDISTRIBUTIONCHNL == TVKWZ.VTWEG`
Product Group 3 Client Product Group 3	`I_PRODUCTSALESDELIVERYWD.MANDT == TVM3.MANDT` `I_PRODUCTSALESDELIVERYWD.THIRDSALESSPECPRODUCTGROUP == TVM3.MVGR3`
Volume rebate group Client Volume rebate group	`I_PRODUCTSALESDELIVERYWD.MANDT == TVBO.MANDT` `I_PRODUCTSALESDELIVERYWD.VOLUMEREBATEGROUP == TVBO.BONUS`

Other Relations \| to Master Data Relations ↑	Join Conditions
Units of measure group Client ? Unit of Measure Group	`I_PRODUCTSALESDELIVERYWD.MANDT == TWMEG.MANDT` `I_PRODUCTSALESDELIVERYWD.[column in domain "LRMEI"] == TWMEG.MEINS` `I_PRODUCTSALESDELIVERYWD.PRODUCTUNITGROUP == TWMEG.MEGRU`