I_ProductSalesDelivery

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