I_CustProjSlsOrdItem

Sales Order Item for Customer Project | view: ICUSTPROJSOI | TRAN | Extraction: Not supported | Component: Project-Based Services in Sales Documents
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, /CPD/D_MP_HDR, /CPD/D_MP_ITEM
Column Name Description
CustomerProject Commercial Project ID
SalesOrderItem Sales Order Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
CappedNetAmount Net Amount Cap
NetAmount Net Value of the Order Item in Document Currency
TotalStandAloneSellingPrice IFRS 15: Standalone Selling Price
Column Name Description
Column Name Description
Column Name Description
SDDocumentRejectionStatus Rejection Status (Item) Show values
SDProcessStatus Overall Processing Status (Item) Show values
Column Name Description Domain name
SalesOrderItemText Short text for sales order item TEXT40
ProfitCenter Profit Center PRCTR
CappedNetAmtAlertThldInPct Notification Threshold (in Pct) for Exceeded Net Amount Cap CAPPED_NET_AMOUNT_ALERT_THLD
MaterialByCustomer Material Number Used by Customer IDNEX
PurchaseOrderByCustomer Customer Reference BSTKD
UnderlyingPurchaseOrderItem Item Number of the Underlying Purchase Order POSEX
Master Data Relations Join Conditions
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • I_CUSTPROJSLSORDITEM.SALESORGANIZATION == TVKOV.VKORG
  • I_CUSTPROJSLSORDITEM.MANDT == TVKOV.MANDT
  • I_CUSTPROJSLSORDITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Billing Block for Item
  • Billing Block for Item
  • Client
  • I_CUSTPROJSLSORDITEM.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • I_CUSTPROJSLSORDITEM.MANDT == TVFS.MANDT
Material: order item
  • Material Number
  • Product Number
  • Client
  • I_CUSTPROJSLSORDITEM.MATERIAL == MARA.MATNR
  • I_CUSTPROJSLSORDITEM.PRODUCT == MARA.MATNR
  • I_CUSTPROJSLSORDITEM.MANDT == MARA.MANDT
Division in order header
  • Sales Organization
  • Division
  • Client
  • Distribution Channel
  • I_CUSTPROJSLSORDITEM.SALESORGANIZATION == TVTA.VKORG
  • I_CUSTPROJSLSORDITEM.ORGANIZATIONDIVISION == TVTA.SPART
  • I_CUSTPROJSLSORDITEM.MANDT == TVTA.MANDT
  • I_CUSTPROJSLSORDITEM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Material: order item
  • Material Number
  • Product Number
  • Client
  • I_CUSTPROJSLSORDITEM.MATERIAL == MARA.MATNR
  • I_CUSTPROJSLSORDITEM.PRODUCT == MARA.MATNR
  • I_CUSTPROJSLSORDITEM.MANDT == MARA.MANDT
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • I_CUSTPROJSLSORDITEM.MANDT == TVAG.MANDT
  • I_CUSTPROJSLSORDITEM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Sales document item category
  • Sales document item category
  • Client
  • I_CUSTPROJSLSORDITEM.SALESORDERITEMCATEGORY == TVPT.PSTYV
  • I_CUSTPROJSLSORDITEM.MANDT == TVPT.MANDT
Order type in order header
  • Sales Order Type
  • Client
  • I_CUSTPROJSLSORDITEM.SALESORDERTYPE == TVAK.AUART
  • I_CUSTPROJSLSORDITEM.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • I_CUSTPROJSLSORDITEM.SALESORGANIZATION == TVKO.VKORG
  • I_CUSTPROJSLSORDITEM.MANDT == TVKO.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • I_CUSTPROJSLSORDITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_CUSTPROJSLSORDITEM.MANDT == TCURC.MANDT