I_BusSolPrtfloSlsOrdItmEnhcd

BSP Sales Order Item Enhanced | view: IBSPSLOITMENHCD | TRAN | Extraction: Not supported | Component: S4CRM: Business Solution Portfolio
Tables used: VBAPCRMS4D_BSP_HCRMS4D_BSP_I_SLOVBKDVEDAVBAKVBAKVBAPVBKDVEDAVBEPMARAKNMTMAKTMARAMVKETVAPTVAPTTVBST
Column Name Description
BusinessSolutionPortfolio Transaction ID
SalesOrder Sales Document
SalesOrderItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
BusSolnPrtfloAssgdDocItmNetAmt null
Column Name Description
Column Name Description
RequestedDeliveryDate Requested Delivery Date
Column Name Description
SDProcessStatus Overall Processing Status (Item) Show values
Column Name Description Domain name
CreationDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
CreatedByUser User Name SYCHAR12
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
LastChangedByUser User Name SYCHAR12
SDProcessStatusDesc Name of the controlling area TEXT25
MaterialName Material Description TEXT40
SalesDocumentItemCategoryName Description TEXT20
BusSolnPrtfloLastChgDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • I_BUSSOLPRTFLOSLSORDITMENHCD.MANDT == TVKOV.MANDT
  • I_BUSSOLPRTFLOSLSORDITMENHCD.SALESORGANIZATION == TVKOV.VKORG
  • I_BUSSOLPRTFLOSLSORDITMENHCD.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Material: order item
  • Client
  • Material Number
  • I_BUSSOLPRTFLOSLSORDITMENHCD.MANDT == MARA.MANDT
  • I_BUSSOLPRTFLOSLSORDITMENHCD.MATERIAL == MARA.MATNR
Division in order header
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • I_BUSSOLPRTFLOSLSORDITMENHCD.MANDT == TVTA.MANDT
  • I_BUSSOLPRTFLOSLSORDITMENHCD.ORGANIZATIONDIVISION == TVTA.SPART
  • I_BUSSOLPRTFLOSLSORDITMENHCD.SALESORGANIZATION == TVTA.VKORG
  • I_BUSSOLPRTFLOSLSORDITMENHCD.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Sales document item category
  • Client
  • Sales document item category
  • I_BUSSOLPRTFLOSLSORDITMENHCD.MANDT == TVPT.MANDT
  • I_BUSSOLPRTFLOSLSORDITMENHCD.SALESORDERITEMCATEGORY == TVPT.PSTYV
Order type in order header
  • Sales Order Type
  • Client
  • I_BUSSOLPRTFLOSLSORDITMENHCD.SALESORDERTYPE == TVAK.AUART
  • I_BUSSOLPRTFLOSLSORDITMENHCD.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • I_BUSSOLPRTFLOSLSORDITMENHCD.MANDT == TVKO.MANDT
  • I_BUSSOLPRTFLOSLSORDITMENHCD.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • I_BUSSOLPRTFLOSLSORDITMENHCD.MANDT == KNA1.MANDT
  • I_BUSSOLPRTFLOSLSORDITMENHCD.SOLDTOPARTY == KNA1.KUNNR
SD Document Currency
  • Client
  • SD Document Currency
  • I_BUSSOLPRTFLOSLSORDITMENHCD.MANDT == TCURC.MANDT
  • I_BUSSOLPRTFLOSLSORDITMENHCD.TRANSACTIONCURRENCY == TCURC.WAERS