Crms4v_ProductSales

Product Sales | view: CRMS4VPRODSALES | Extraction: Not supported | Component: S4CRM: Products
Tables used: MARA, MARA, MVKE
Column Name Description
ProductUUID Internal Key for Product
SalesOrganization FK Sales Organization
DistributionChannel FK Distribution Channel
Column Name Description
Column Name Description
MinimumOrderQuantity Minimum order quantity in base unit of measure
📏 Unit of measure of delivery unit (DeliveryQuantityUnit):
DeliveryQuantity Delivery unit
Column Name Description
ProductSalesStatusValidityDate Date from which distr.-chain-spec. material status is valid
Column Name Description
CashDiscountIsDeductible Cash Discount Indicator Show values
VariableSalesUnitIsNotAllowed Variable Sales Unit Not Allowed Show values
IsMarkedForDeletion Ind.: Flag material for deletion at distribution chain level Show values
SubscrpnContrDurationUnit Unit for Contract Term Show values
SubscrpnContrExtnDurnUnit Unit for Extension Period Show values
Column Name Description Domain name
Product Product Number MATNR
ProductAuthorizationGroup Authorization Group BEGRU
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
Language null
Master Data Relations Join Conditions
Account assignment group for the material
  • Account Assignment Group for Material
  • Client
  • CRMS4V_PRODUCTSALES.ACCOUNTDETNPRODUCTGROUP == TVKM.KTGRM
  • CRMS4V_PRODUCTSALES.MANDT == TVKM.MANDT
Unit of measure
  • Unit of measure of delivery unit
  • Client
  • CRMS4V_PRODUCTSALES.DELIVERYQUANTITYUNIT == T006.MSEHI
  • CRMS4V_PRODUCTSALES.MANDT == T006.MANDT
Distribution channel
  • Distribution Channel
  • Client
  • CRMS4V_PRODUCTSALES.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • CRMS4V_PRODUCTSALES.MANDT == TVTW.MANDT
Item category group
  • Item Category Group from Material Master
  • Client
  • CRMS4V_PRODUCTSALES.ITEMCATEGORYGROUP == TPTM.MTPOS
  • CRMS4V_PRODUCTSALES.MANDT == TPTM.MANDT
Price group
  • Pricing Reference Material
  • Client
  • CRMS4V_PRODUCTSALES.PRICINGREFERENCEPRODUCT == MARA.MATNR
  • CRMS4V_PRODUCTSALES.MANDT == MARA.MANDT
Commission group
  • Client
  • Commission Group
  • CRMS4V_PRODUCTSALES.MANDT == TVPR.MANDT
  • CRMS4V_PRODUCTSALES.PRODUCTCOMMISSIONGROUP == TVPR.PROVG
Condition group
  • Product Pricing Group
  • Client
  • CRMS4V_PRODUCTSALES.PRODUCTGROUP == T178.KONDM
  • CRMS4V_PRODUCTSALES.MANDT == T178.MANDT
Product Group 1
  • Product Group 1
  • Client
  • CRMS4V_PRODUCTSALES.PRODUCTGROUP1 == TVM1.MVGR1
  • CRMS4V_PRODUCTSALES.MANDT == TVM1.MANDT
Product Group 2
  • Product Group 2
  • Client
  • CRMS4V_PRODUCTSALES.PRODUCTGROUP2 == TVM2.MVGR2
  • CRMS4V_PRODUCTSALES.MANDT == TVM2.MANDT
Product Group 3
  • Product Group 3
  • Client
  • CRMS4V_PRODUCTSALES.PRODUCTGROUP3 == TVM3.MVGR3
  • CRMS4V_PRODUCTSALES.MANDT == TVM3.MANDT
Product Group 4
  • Product Group 4
  • Client
  • CRMS4V_PRODUCTSALES.PRODUCTGROUP4 == TVM4.MVGR4
  • CRMS4V_PRODUCTSALES.MANDT == TVM4.MANDT
Product Group 5
  • Product Group 5
  • Client
  • CRMS4V_PRODUCTSALES.PRODUCTGROUP5 == TVM5.MVGR5
  • CRMS4V_PRODUCTSALES.MANDT == TVM5.MANDT
Product hierarchy
  • Product hierarchy
  • Client
  • CRMS4V_PRODUCTSALES.PRODUCTHIERARCHY == T179.PRODH
  • CRMS4V_PRODUCTSALES.MANDT == T179.MANDT
Material status for sales
  • Distribution-chain-specific material status
  • Client
  • CRMS4V_PRODUCTSALES.PRODUCTSALESSTATUS == TVMS.VMSTA
  • CRMS4V_PRODUCTSALES.MANDT == TVMS.MANDT
Unit of measure
  • Sales unit
  • Client
  • CRMS4V_PRODUCTSALES.SALESMEASUREUNIT == T006.MSEHI
  • CRMS4V_PRODUCTSALES.MANDT == T006.MANDT
Sales organization
  • Client
  • Sales Organization
  • CRMS4V_PRODUCTSALES.MANDT == TVKO.MANDT
  • CRMS4V_PRODUCTSALES.SALESORGANIZATION == TVKO.VKORG
Default plant
  • Delivering Plant (Own or External)
  • Distribution Channel
  • Client
  • Sales Organization
  • CRMS4V_PRODUCTSALES.SUPPLYINGPLANT == TVKWZ.WERKS
  • CRMS4V_PRODUCTSALES.DISTRIBUTIONCHANNEL == TVKWZ.VTWEG
  • CRMS4V_PRODUCTSALES.MANDT == TVKWZ.MANDT
  • CRMS4V_PRODUCTSALES.SALESORGANIZATION == TVKWZ.VKORG
Volume rebate group
  • Volume rebate group
  • Client
  • CRMS4V_PRODUCTSALES.VOLUMEREBATEGROUP == TVBO.BONUS
  • CRMS4V_PRODUCTSALES.MANDT == TVBO.MANDT