A_CustProjSlsOrd

Sales Order Header | view: ACUSTPROJSO | 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
  • A_CUSTPROJSLSORD.MANDT == TVKT.MANDT
  • A_CUSTPROJSLSORD.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • A_CUSTPROJSLSORD.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • A_CUSTPROJSLSORD.MANDT == TVKOV.MANDT
  • A_CUSTPROJSLSORD.SALESORGANIZATION == TVKOV.VKORG
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • A_CUSTPROJSLSORD.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • A_CUSTPROJSLSORD.MANDT == TVFS.MANDT
Division in order header
  • Division
  • Distribution Channel
  • Client
  • Sales Organization
  • A_CUSTPROJSLSORD.ORGANIZATIONDIVISION == TVTA.SPART
  • A_CUSTPROJSLSORD.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • A_CUSTPROJSLSORD.MANDT == TVTA.MANDT
  • A_CUSTPROJSLSORD.SALESORGANIZATION == TVTA.VKORG
Sales group
  • Sales group
  • Client
  • Sales office
  • A_CUSTPROJSLSORD.SALESGROUP == TVBVK.VKGRP
  • A_CUSTPROJSLSORD.MANDT == TVBVK.MANDT
  • A_CUSTPROJSLSORD.SALESOFFICE == TVBVK.VKBUR
Order type in order header
  • Client
  • Sales Order Type
  • A_CUSTPROJSLSORD.MANDT == TVAK.MANDT
  • A_CUSTPROJSLSORD.SALESORDERTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • A_CUSTPROJSLSORD.MANDT == TVKO.MANDT
  • A_CUSTPROJSLSORD.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Sold-to Party
  • Client
  • A_CUSTPROJSLSORD.SOLDTOPARTY == KNA1.KUNNR
  • A_CUSTPROJSLSORD.MANDT == KNA1.MANDT
Currency in order header
  • SD Document Currency
  • Client
  • A_CUSTPROJSLSORD.TRANSACTIONCURRENCY == TCURC.WAERS
  • A_CUSTPROJSLSORD.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Distribution Channel
  • Client
  • Sales office
  • Sales Organization
  • A_CUSTPROJSLSORD.ORGANIZATIONDIVISION == TVKBZ.SPART
  • A_CUSTPROJSLSORD.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • A_CUSTPROJSLSORD.MANDT == TVKBZ.MANDT
  • A_CUSTPROJSLSORD.SALESOFFICE == TVKBZ.VKBUR
  • A_CUSTPROJSLSORD.SALESORGANIZATION == TVKBZ.VKORG