I_SubscrpnProdSlsDelivery

Sales delivery data for subscription product | view: ISPRDSALESDELIV | Extraction: Not supported | Component: S4CRM: Subscription Order Management
Tables used: MVKE
Column Name Description
Product FK Material Number
ProductSalesOrg FK Sales Organization
ProductDistributionChnl FK Distribution Channel
Column Name Description
Column Name Description
Column Name Description
Column Name Description
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
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
Item category group
  • Item Category Group from Material Master
  • Client
  • I_SUBSCRPNPRODSLSDELIVERY.ITEMCATEGORYGROUP == TPTM.MTPOS
  • I_SUBSCRPNPRODSLSDELIVERY.MANDT == TPTM.MANDT
Material No.
  • Material Number
  • Client
  • I_SUBSCRPNPRODSLSDELIVERY.PRODUCT == MARA.MATNR
  • I_SUBSCRPNPRODSLSDELIVERY.MANDT == MARA.MANDT
Distribution channel
  • Distribution Channel
  • Client
  • I_SUBSCRPNPRODSLSDELIVERY.PRODUCTDISTRIBUTIONCHNL == TVTW.VTWEG
  • I_SUBSCRPNPRODSLSDELIVERY.MANDT == TVTW.MANDT
Sales organization
  • Client
  • Sales Organization
  • I_SUBSCRPNPRODSLSDELIVERY.MANDT == TVKO.MANDT
  • I_SUBSCRPNPRODSLSDELIVERY.PRODUCTSALESORG == TVKO.VKORG