A_ClfnProductSalesDelivery

Sales Organization Data | view: ACLFNPRODSLSDELI | Extraction: Not supported | Component: Classification
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
Column Name Description Domain name
Master Data Relations Join Conditions
Account assignment group for the material
  • Account Assignment Group for Material
  • Client
  • A_CLFNPRODUCTSALESDELIVERY.ACCOUNTDETNPRODUCTGROUP == TVKM.KTGRM
  • A_CLFNPRODUCTSALESDELIVERY.MANDT == TVKM.MANDT
Unit of Measure
  • Base Unit of Measure
  • Client
  • A_CLFNPRODUCTSALESDELIVERY.BASEUNIT == T006.MSEHI
  • A_CLFNPRODUCTSALESDELIVERY.MANDT == T006.MANDT
Unit of measure
  • Unit of measure of delivery unit
  • Client
  • A_CLFNPRODUCTSALESDELIVERY.DELIVERYQUANTITYUNIT == T006.MSEHI
  • A_CLFNPRODUCTSALESDELIVERY.MANDT == T006.MANDT
Product Group 5
  • Product Group 5
  • Client
  • A_CLFNPRODUCTSALESDELIVERY.FIFTHSALESSPECPRODUCTGROUP == TVM5.MVGR5
  • A_CLFNPRODUCTSALESDELIVERY.MANDT == TVM5.MANDT
Product Group 1
  • Product Group 1
  • Client
  • A_CLFNPRODUCTSALESDELIVERY.FIRSTSALESSPECPRODUCTGROUP == TVM1.MVGR1
  • A_CLFNPRODUCTSALESDELIVERY.MANDT == TVM1.MANDT
Product Group 4
  • Product Group 4
  • Client
  • A_CLFNPRODUCTSALESDELIVERY.FOURTHSALESSPECPRODUCTGROUP == TVM4.MVGR4
  • A_CLFNPRODUCTSALESDELIVERY.MANDT == TVM4.MANDT
Item category group
  • Item Category Group from Material Master
  • Client
  • A_CLFNPRODUCTSALESDELIVERY.ITEMCATEGORYGROUP == TPTM.MTPOS
  • A_CLFNPRODUCTSALESDELIVERY.MANDT == TPTM.MANDT
Condition group
  • Product Pricing Group
  • Client
  • A_CLFNPRODUCTSALESDELIVERY.PRICESPECIFICATIONPRODUCTGROUP == T178.KONDM
  • A_CLFNPRODUCTSALESDELIVERY.MANDT == T178.MANDT
Material No.
  • Client
  • Product Number
  • A_CLFNPRODUCTSALESDELIVERY.MANDT == MARA.MANDT
  • A_CLFNPRODUCTSALESDELIVERY.PRODUCT == MARA.MATNR
Distribution channel
  • Distribution Channel
  • Client
  • A_CLFNPRODUCTSALESDELIVERY.PRODUCTDISTRIBUTIONCHNL == TVTW.VTWEG
  • A_CLFNPRODUCTSALESDELIVERY.MANDT == TVTW.MANDT
Product hierarchy
  • Product hierarchy
  • Client
  • A_CLFNPRODUCTSALESDELIVERY.PRODUCTHIERARCHY == T179.PRODH
  • A_CLFNPRODUCTSALESDELIVERY.MANDT == T179.MANDT
Sales organization
  • Sales Organization
  • Client
  • A_CLFNPRODUCTSALESDELIVERY.PRODUCTSALESORG == TVKO.VKORG
  • A_CLFNPRODUCTSALESDELIVERY.MANDT == TVKO.MANDT
Material status for sales
  • Distribution-chain-specific material status
  • Client
  • A_CLFNPRODUCTSALESDELIVERY.PRODUCTSALESSTATUS == TVMS.VMSTA
  • A_CLFNPRODUCTSALESDELIVERY.MANDT == TVMS.MANDT
Unit of measure
  • Sales unit
  • Client
  • A_CLFNPRODUCTSALESDELIVERY.SALESMEASUREUNIT == T006.MSEHI
  • A_CLFNPRODUCTSALESDELIVERY.MANDT == T006.MANDT
Product Group 2
  • Product Group 2
  • Client
  • A_CLFNPRODUCTSALESDELIVERY.SECONDSALESSPECPRODUCTGROUP == TVM2.MVGR2
  • A_CLFNPRODUCTSALESDELIVERY.MANDT == TVM2.MANDT
Default plant
  • Delivering Plant (Own or External)
  • Sales Organization
  • Distribution Channel
  • Client
  • A_CLFNPRODUCTSALESDELIVERY.SUPPLYINGPLANT == TVKWZ.WERKS
  • A_CLFNPRODUCTSALESDELIVERY.PRODUCTSALESORG == TVKWZ.VKORG
  • A_CLFNPRODUCTSALESDELIVERY.PRODUCTDISTRIBUTIONCHNL == TVKWZ.VTWEG
  • A_CLFNPRODUCTSALESDELIVERY.MANDT == TVKWZ.MANDT
Product Group 3
  • Product Group 3
  • Client
  • A_CLFNPRODUCTSALESDELIVERY.THIRDSALESSPECPRODUCTGROUP == TVM3.MVGR3
  • A_CLFNPRODUCTSALESDELIVERY.MANDT == TVM3.MANDT