A_ProductSalesDelivery

Sales Organization Data | view: APRODSALESDELIV | 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
📏 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
IsMarkedForDeletion Ind.: Flag material for deletion at distribution chain level Show values
CashDiscountIsDeductible Cash Discount Indicator Show values
VariableSalesUnitIsNotAllowed Variable Sales Unit Not Allowed Show values
ProductHasAttributeID01 ID for product attribute 1 Show values
ProductHasAttributeID02 ID for product attribute 2 Show values
ProductHasAttributeID03 ID for product attribute 3 Show values
ProductHasAttributeID04 ID for product attribute 4 Show values
ProductHasAttributeID05 ID for product attribute 5 Show values
ProductHasAttributeID06 ID for product attribute 6 Show values
ProductHasAttributeID07 ID for product attribute 7 Show values
ProductHasAttributeID08 ID for product attribute 8 Show values
ProductHasAttributeID09 ID for product attribute 9 Show values
ProductHasAttributeID10 ID for product attribute 10 Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Account assignment group for the material
  • Account Assignment Group for Material
  • Client
  • A_PRODUCTSALESDELIVERY.ACCOUNTDETNPRODUCTGROUP == TVKM.KTGRM
  • A_PRODUCTSALESDELIVERY.MANDT == TVKM.MANDT
Unit of Measure
  • Client
  • Base Unit of Measure
  • A_PRODUCTSALESDELIVERY.MANDT == T006.MANDT
  • A_PRODUCTSALESDELIVERY.BASEUNIT == T006.MSEHI
Unit of measure
  • Client
  • Unit of measure of delivery unit
  • A_PRODUCTSALESDELIVERY.MANDT == T006.MANDT
  • A_PRODUCTSALESDELIVERY.DELIVERYQUANTITYUNIT == T006.MSEHI
Product Group 5
  • Product Group 5
  • Client
  • A_PRODUCTSALESDELIVERY.FIFTHSALESSPECPRODUCTGROUP == TVM5.MVGR5
  • A_PRODUCTSALESDELIVERY.MANDT == TVM5.MANDT
Product Group 1
  • Product Group 1
  • Client
  • A_PRODUCTSALESDELIVERY.FIRSTSALESSPECPRODUCTGROUP == TVM1.MVGR1
  • A_PRODUCTSALESDELIVERY.MANDT == TVM1.MANDT
Product Group 4
  • Client
  • Product Group 4
  • A_PRODUCTSALESDELIVERY.MANDT == TVM4.MANDT
  • A_PRODUCTSALESDELIVERY.FOURTHSALESSPECPRODUCTGROUP == TVM4.MVGR4
Item category group
  • Client
  • Item Category Group from Material Master
  • A_PRODUCTSALESDELIVERY.MANDT == TPTM.MANDT
  • A_PRODUCTSALESDELIVERY.ITEMCATEGORYGROUP == TPTM.MTPOS
Shipping statistics group
  • Client
  • Material statistics group
  • A_PRODUCTSALESDELIVERY.MANDT == TVSM.MANDT
  • A_PRODUCTSALESDELIVERY.LOGISTICSSTATISTICSGROUP == TVSM.STGMA
Condition group
  • Client
  • Product Pricing Group
  • A_PRODUCTSALESDELIVERY.MANDT == T178.MANDT
  • A_PRODUCTSALESDELIVERY.PRICESPECIFICATIONPRODUCTGROUP == T178.KONDM
Price group
  • Client
  • Pricing Reference Material
  • A_PRODUCTSALESDELIVERY.MANDT == MARA.MANDT
  • A_PRODUCTSALESDELIVERY.PRICINGREFERENCEPRODUCT == MARA.MATNR
Material No.
  • Product Number
  • Client
  • A_PRODUCTSALESDELIVERY.PRODUCT == MARA.MATNR
  • A_PRODUCTSALESDELIVERY.MANDT == MARA.MANDT
Commission group
  • Commission Group
  • Client
  • A_PRODUCTSALESDELIVERY.PRODUCTCOMMISSIONGROUP == TVPR.PROVG
  • A_PRODUCTSALESDELIVERY.MANDT == TVPR.MANDT
Distribution channel
  • Client
  • Distribution Channel
  • A_PRODUCTSALESDELIVERY.MANDT == TVTW.MANDT
  • A_PRODUCTSALESDELIVERY.PRODUCTDISTRIBUTIONCHNL == TVTW.VTWEG
Product hierarchy
  • Client
  • Product hierarchy
  • A_PRODUCTSALESDELIVERY.MANDT == T179.MANDT
  • A_PRODUCTSALESDELIVERY.PRODUCTHIERARCHY == T179.PRODH
Sales organization
  • Client
  • Sales Organization
  • A_PRODUCTSALESDELIVERY.MANDT == TVKO.MANDT
  • A_PRODUCTSALESDELIVERY.PRODUCTSALESORG == TVKO.VKORG
Material status for sales
  • Client
  • Distribution-chain-specific material status
  • A_PRODUCTSALESDELIVERY.MANDT == TVMS.MANDT
  • A_PRODUCTSALESDELIVERY.PRODUCTSALESSTATUS == TVMS.VMSTA
Rounding profile
  • Rounding Profile
  • ?
  • Delivering Plant (Own or External)
  • Client
  • A_PRODUCTSALESDELIVERY.ROUNDINGPROFILE == RDPR.RDPRF
  • A_PRODUCTSALESDELIVERY.[column in domain "RDZAE"] == RDPR.RDZAE
  • A_PRODUCTSALESDELIVERY.SUPPLYINGPLANT == RDPR.WERKS
  • A_PRODUCTSALESDELIVERY.MANDT == RDPR.MANDT
Unit of measure
  • Client
  • Sales unit
  • A_PRODUCTSALESDELIVERY.MANDT == T006.MANDT
  • A_PRODUCTSALESDELIVERY.SALESMEASUREUNIT == T006.MSEHI
Product Group 2
  • Client
  • Product Group 2
  • A_PRODUCTSALESDELIVERY.MANDT == TVM2.MANDT
  • A_PRODUCTSALESDELIVERY.SECONDSALESSPECPRODUCTGROUP == TVM2.MVGR2
Default plant
  • Delivering Plant (Own or External)
  • Client
  • Sales Organization
  • Distribution Channel
  • A_PRODUCTSALESDELIVERY.SUPPLYINGPLANT == TVKWZ.WERKS
  • A_PRODUCTSALESDELIVERY.MANDT == TVKWZ.MANDT
  • A_PRODUCTSALESDELIVERY.PRODUCTSALESORG == TVKWZ.VKORG
  • A_PRODUCTSALESDELIVERY.PRODUCTDISTRIBUTIONCHNL == TVKWZ.VTWEG
Product Group 3
  • Client
  • Product Group 3
  • A_PRODUCTSALESDELIVERY.MANDT == TVM3.MANDT
  • A_PRODUCTSALESDELIVERY.THIRDSALESSPECPRODUCTGROUP == TVM3.MVGR3
Volume rebate group
  • Client
  • Volume rebate group
  • A_PRODUCTSALESDELIVERY.MANDT == TVBO.MANDT
  • A_PRODUCTSALESDELIVERY.VOLUMEREBATEGROUP == TVBO.BONUS
Other Relations | to Master Data Relations ↑ Join Conditions
Units of measure group
  • ?
  • Client
  • Unit of Measure Group
  • A_PRODUCTSALESDELIVERY.[column in domain "LRMEI"] == TWMEG.MEINS
  • A_PRODUCTSALESDELIVERY.MANDT == TWMEG.MANDT
  • A_PRODUCTSALESDELIVERY.PRODUCTUNITGROUP == TWMEG.MEGRU