I_CustProjSlsOrd

Sales Order for Customer Project | view: ICUSTPROJSO | TRAN | Extraction: Not supported | Component: Project-Based Services in Sales Documents
Tables used: VBKD, VEDA, VBAK, /CPD/D_MP_HDR, /CPD/D_MP_ITEM
Column Name Description
CustomerProject Commercial Project ID
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
CustomerPurchaseOrderDate Customer Reference Date
Column Name Description
Column Name Description Domain name
SalesOrder Sales Order VBELN
PurchaseOrderByCustomer Customer Reference BSTKD
CustomerPaymentTerms Terms of payment key ZTERM
Master Data Relations Join Conditions
Account Assignment Group for this Customer
  • Client
  • Account Assignment Group for this Customer
  • I_CUSTPROJSLSORD.MANDT == TVKT.MANDT
  • I_CUSTPROJSLSORD.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • I_CUSTPROJSLSORD.SALESORGANIZATION == TVKOV.VKORG
  • I_CUSTPROJSLSORD.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_CUSTPROJSLSORD.MANDT == TVKOV.MANDT
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • I_CUSTPROJSLSORD.MANDT == TVFS.MANDT
  • I_CUSTPROJSLSORD.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Division in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • I_CUSTPROJSLSORD.SALESORGANIZATION == TVTA.VKORG
  • I_CUSTPROJSLSORD.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_CUSTPROJSLSORD.MANDT == TVTA.MANDT
  • I_CUSTPROJSLSORD.ORGANIZATIONDIVISION == TVTA.SPART
Sales group
  • Sales office
  • Client
  • Sales group
  • I_CUSTPROJSLSORD.SALESOFFICE == TVBVK.VKBUR
  • I_CUSTPROJSLSORD.MANDT == TVBVK.MANDT
  • I_CUSTPROJSLSORD.SALESGROUP == TVBVK.VKGRP
Order type in order header
  • Sales Order Type
  • Client
  • I_CUSTPROJSLSORD.SALESORDERTYPE == TVAK.AUART
  • I_CUSTPROJSLSORD.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • I_CUSTPROJSLSORD.SALESORGANIZATION == TVKO.VKORG
  • I_CUSTPROJSLSORD.MANDT == TVKO.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • I_CUSTPROJSLSORD.SOLDTOPARTY == KNA1.KUNNR
  • I_CUSTPROJSLSORD.MANDT == KNA1.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • I_CUSTPROJSLSORD.MANDT == TCURC.MANDT
  • I_CUSTPROJSLSORD.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales office
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • I_CUSTPROJSLSORD.SALESOFFICE == TVKBZ.VKBUR
  • I_CUSTPROJSLSORD.SALESORGANIZATION == TVKBZ.VKORG
  • I_CUSTPROJSLSORD.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_CUSTPROJSLSORD.MANDT == TVKBZ.MANDT
  • I_CUSTPROJSLSORD.ORGANIZATIONDIVISION == TVKBZ.SPART