C_Productsalesdelivery

Product Master Distribution Chains | view: CPRDSALESDELIVWD | Extraction: Not supported | Component: Material Master
Tables used: MARA, MARA, MVKE
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
HasActiveHierarchy Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') 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
  • C_PRODUCTSALESDELIVERY.MANDT == TVKM.MANDT
  • C_PRODUCTSALESDELIVERY.ACCOUNTDETNPRODUCTGROUP == TVKM.KTGRM
Assortment grade
  • Client
  • Assortment grade
  • C_PRODUCTSALESDELIVERY.MANDT == TWSS.MANDT
  • C_PRODUCTSALESDELIVERY.ASSORTMENTGRADE == TWSS.SSTUF
Unit of Measure
  • Client
  • Base Unit of Measure
  • C_PRODUCTSALESDELIVERY.MANDT == T006.MANDT
  • C_PRODUCTSALESDELIVERY.BASEUNIT == T006.MSEHI
Unit of measure
  • Client
  • Unit of measure of delivery unit
  • C_PRODUCTSALESDELIVERY.MANDT == T006.MANDT
  • C_PRODUCTSALESDELIVERY.DELIVERYQUANTITYUNIT == T006.MSEHI
Listing procedure for distr. center assortment categories
  • Client
  • Listing procedure for distr. center assortment categories
  • C_PRODUCTSALESDELIVERY.MANDT == TWLV.MANDT
  • C_PRODUCTSALESDELIVERY.DISTRCNTRLISTINGPROCEDURE == TWLV.LSTFL
Product Group 5
  • Client
  • Product Group 5
  • C_PRODUCTSALESDELIVERY.MANDT == TVM5.MANDT
  • C_PRODUCTSALESDELIVERY.FIFTHSALESSPECPRODUCTGROUP == TVM5.MVGR5
Product Group 1
  • Client
  • Product Group 1
  • C_PRODUCTSALESDELIVERY.MANDT == TVM1.MANDT
  • C_PRODUCTSALESDELIVERY.FIRSTSALESSPECPRODUCTGROUP == TVM1.MVGR1
Product Group 4
  • Client
  • Product Group 4
  • C_PRODUCTSALESDELIVERY.MANDT == TVM4.MANDT
  • C_PRODUCTSALESDELIVERY.FOURTHSALESSPECPRODUCTGROUP == TVM4.MVGR4
Item category group
  • Client
  • Item Category Group from Material Master
  • C_PRODUCTSALESDELIVERY.MANDT == TPTM.MANDT
  • C_PRODUCTSALESDELIVERY.ITEMCATEGORYGROUP == TPTM.MTPOS
Shipping statistics group
  • Client
  • Material statistics group
  • C_PRODUCTSALESDELIVERY.MANDT == TVSM.MANDT
  • C_PRODUCTSALESDELIVERY.LOGISTICSSTATISTICSGROUP == TVSM.STGMA
Condition group
  • Product Pricing Group
  • Client
  • C_PRODUCTSALESDELIVERY.PRICESPECIFICATIONPRODUCTGROUP == T178.KONDM
  • C_PRODUCTSALESDELIVERY.MANDT == T178.MANDT
Price group
  • Client
  • Pricing Reference Material
  • C_PRODUCTSALESDELIVERY.MANDT == MARA.MANDT
  • C_PRODUCTSALESDELIVERY.PRICINGREFERENCEPRODUCT == MARA.MATNR
External assortment priority
  • Client
  • External assortment priority
  • C_PRODUCTSALESDELIVERY.MANDT == TWSP.MANDT
  • C_PRODUCTSALESDELIVERY.PRODEXTASSORTMENTPRIORITY == TWSP.PFLKS
Material No.
  • Client
  • Product Number
  • Product Number
  • C_PRODUCTSALESDELIVERY.MANDT == MARA.MANDT
  • C_PRODUCTSALESDELIVERY.PRODUCT == MARA.MATNR
  • C_PRODUCTSALESDELIVERY.PRODUCTFOREDIT == MARA.MATNR
Commission group
  • Client
  • Commission Group
  • C_PRODUCTSALESDELIVERY.MANDT == TVPR.MANDT
  • C_PRODUCTSALESDELIVERY.PRODUCTCOMMISSIONGROUP == TVPR.PROVG
Distribution channel
  • Client
  • Distribution Channel
  • Distribution Channel
  • C_PRODUCTSALESDELIVERY.MANDT == TVTW.MANDT
  • C_PRODUCTSALESDELIVERY.PRODUCTDISTRIBUTIONCHNLFOREDIT == TVTW.VTWEG
  • C_PRODUCTSALESDELIVERY.PRODUCTDISTRIBUTIONCHNL == TVTW.VTWEG
Distribution channel
  • Client
  • Distribution Channel
  • Distribution Channel
  • C_PRODUCTSALESDELIVERY.MANDT == TVTW.MANDT
  • C_PRODUCTSALESDELIVERY.PRODUCTDISTRIBUTIONCHNLFOREDIT == TVTW.VTWEG
  • C_PRODUCTSALESDELIVERY.PRODUCTDISTRIBUTIONCHNL == TVTW.VTWEG
Material No.
  • Client
  • Product Number
  • Product Number
  • C_PRODUCTSALESDELIVERY.MANDT == MARA.MANDT
  • C_PRODUCTSALESDELIVERY.PRODUCT == MARA.MATNR
  • C_PRODUCTSALESDELIVERY.PRODUCTFOREDIT == MARA.MATNR
Product hierarchy
  • Client
  • Product hierarchy
  • C_PRODUCTSALESDELIVERY.MANDT == T179.MANDT
  • C_PRODUCTSALESDELIVERY.PRODUCTHIERARCHY == T179.PRODH
Sales organization
  • Client
  • Sales Organization
  • Sales Organization
  • C_PRODUCTSALESDELIVERY.MANDT == TVKO.MANDT
  • C_PRODUCTSALESDELIVERY.PRODUCTSALESORG == TVKO.VKORG
  • C_PRODUCTSALESDELIVERY.PRODUCTSALESORGFOREDIT == TVKO.VKORG
Sales organization
  • Client
  • Sales Organization
  • Sales Organization
  • C_PRODUCTSALESDELIVERY.MANDT == TVKO.MANDT
  • C_PRODUCTSALESDELIVERY.PRODUCTSALESORG == TVKO.VKORG
  • C_PRODUCTSALESDELIVERY.PRODUCTSALESORGFOREDIT == TVKO.VKORG
Material status for sales
  • Client
  • Distribution-chain-specific material status
  • C_PRODUCTSALESDELIVERY.MANDT == TVMS.MANDT
  • C_PRODUCTSALESDELIVERY.PRODUCTSALESSTATUS == TVMS.VMSTA
Rounding profile
  • ?
  • Client
  • Rounding Profile
  • Delivering Plant (Own or External)
  • C_PRODUCTSALESDELIVERY.[column in domain "RDZAE"] == RDPR.RDZAE
  • C_PRODUCTSALESDELIVERY.MANDT == RDPR.MANDT
  • C_PRODUCTSALESDELIVERY.ROUNDINGPROFILE == RDPR.RDPRF
  • C_PRODUCTSALESDELIVERY.SUPPLYINGPLANT == RDPR.WERKS
Unit of measure
  • Client
  • Sales unit
  • C_PRODUCTSALESDELIVERY.MANDT == T006.MANDT
  • C_PRODUCTSALESDELIVERY.SALESMEASUREUNIT == T006.MSEHI
Product Group 2
  • Client
  • Product Group 2
  • C_PRODUCTSALESDELIVERY.MANDT == TVM2.MANDT
  • C_PRODUCTSALESDELIVERY.SECONDSALESSPECPRODUCTGROUP == TVM2.MVGR2
Listing procedure for store or other assortment categories
  • Client
  • Listing procedure for store or other assortment categories
  • C_PRODUCTSALESDELIVERY.MANDT == TWLV.MANDT
  • C_PRODUCTSALESDELIVERY.STORELISTINGPROCEDURE == TWLV.LSTFL
Default plant
  • Client
  • Sales Organization
  • Sales Organization
  • Distribution Channel
  • Distribution Channel
  • Delivering Plant (Own or External)
  • C_PRODUCTSALESDELIVERY.MANDT == TVKWZ.MANDT
  • C_PRODUCTSALESDELIVERY.PRODUCTSALESORG == TVKWZ.VKORG
  • C_PRODUCTSALESDELIVERY.PRODUCTSALESORGFOREDIT == TVKWZ.VKORG
  • C_PRODUCTSALESDELIVERY.PRODUCTDISTRIBUTIONCHNLFOREDIT == TVKWZ.VTWEG
  • C_PRODUCTSALESDELIVERY.PRODUCTDISTRIBUTIONCHNL == TVKWZ.VTWEG
  • C_PRODUCTSALESDELIVERY.SUPPLYINGPLANT == TVKWZ.WERKS
Product Group 3
  • Client
  • Product Group 3
  • C_PRODUCTSALESDELIVERY.MANDT == TVM3.MANDT
  • C_PRODUCTSALESDELIVERY.THIRDSALESSPECPRODUCTGROUP == TVM3.MVGR3
Volume rebate group
  • Client
  • Volume rebate group
  • C_PRODUCTSALESDELIVERY.MANDT == TVBO.MANDT
  • C_PRODUCTSALESDELIVERY.VOLUMEREBATEGROUP == TVBO.BONUS
Other Relations | to Master Data Relations ↑ Join Conditions
Units of measure group
  • ?
  • Client
  • Unit of Measure Group
  • C_PRODUCTSALESDELIVERY.[column in domain "LRMEI"] == TWMEG.MEINS
  • C_PRODUCTSALESDELIVERY.MANDT == TWMEG.MANDT
  • C_PRODUCTSALESDELIVERY.PRODUCTUNITGROUP == TWMEG.MEGRU