C_SalesContractWrkflwInbox

Sales Contract Workflow - My Inbox | view: CCONTRWFIN | TRAN | Extraction: Not supported | Component: Outline Agreements (Customer)
Tables used: VBKD, VEDA, VBAK, VBPA2, VBPA, VBPA, ADCP, ADRC, ADRP, ADCP, ADRC, CVI_CUST_CT_LINK, BUT0ID, BUT000, ADRP, KNVK, KNA1, CVI_CUST_LINK, TVTW, TVTWT, TSPA, TSPAT, TPAR, TVAK, TVAKT, TVKO, TVKOT, TVAU, TVAUT, CVI_VEND_LINK, USR21
Column Name Description
SalesContract Sales Contract
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
SalesContractValidityStartDate Valid-From Date (Outline Agreements, Product Proposals)
SalesContractValidityEndDate Valid-To Date (Outline Agreements, Product Proposals)
CreationDate Date on which the record was created
Column Name Description
Column Name Description Domain name
DocumentTitle null
CustomerName Name of Customer TEXT80
ShipToPartyName Name of Customer TEXT80
CityName null
PurchaseOrderByCustomer Customer Reference BSTKD
SDDocumentReasonText Description TEXT40
SalesOrganizationName Sales Organization Description TEXT20
DistributionChannelName Distribution Channel Description TEXT20
DivisionName Division Description TEXT20
UserName User Description SUIDTECHDESC
CreatedByUser Name of Person Responsible for Creating the Object USNAM
UserDescription User Description SUIDTECHDESC
LastChangedByUser User Who Last Changed the Business Document USNAM
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_SALESCONTRACTWRKFLWINBOX.MANDT == TVKOV.MANDT
  • C_SALESCONTRACTWRKFLWINBOX.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESCONTRACTWRKFLWINBOX.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Client
  • Sales Organization
  • Division
  • Distribution Channel
  • C_SALESCONTRACTWRKFLWINBOX.MANDT == TVTA.MANDT
  • C_SALESCONTRACTWRKFLWINBOX.SALESORGANIZATION == TVTA.VKORG
  • C_SALESCONTRACTWRKFLWINBOX.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SALESCONTRACTWRKFLWINBOX.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Approval Request Reason ID
  • Client
  • Approval Request Reason ID
  • C_SALESCONTRACTWRKFLWINBOX.MANDT == SDAPMAPRR.CLIENT
  • C_SALESCONTRACTWRKFLWINBOX.SALESCONTRACTAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
Order type in order header
  • Client
  • Sales Contract Type
  • C_SALESCONTRACTWRKFLWINBOX.MANDT == TVAK.MANDT
  • C_SALESCONTRACTWRKFLWINBOX.SALESCONTRACTTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • C_SALESCONTRACTWRKFLWINBOX.MANDT == TVKO.MANDT
  • C_SALESCONTRACTWRKFLWINBOX.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • C_SALESCONTRACTWRKFLWINBOX.MANDT == TVAU.MANDT
  • C_SALESCONTRACTWRKFLWINBOX.SDDOCUMENTREASON == TVAU.AUGRU
Customer - Document Customer
  • Client
  • Sold-to Party
  • Customer Number
  • C_SALESCONTRACTWRKFLWINBOX.MANDT == KNA1.MANDT
  • C_SALESCONTRACTWRKFLWINBOX.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESCONTRACTWRKFLWINBOX.SHIPTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Sold-to Party
  • Customer Number
  • C_SALESCONTRACTWRKFLWINBOX.MANDT == KNA1.MANDT
  • C_SALESCONTRACTWRKFLWINBOX.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESCONTRACTWRKFLWINBOX.SHIPTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • C_SALESCONTRACTWRKFLWINBOX.MANDT == TCURC.MANDT
  • C_SALESCONTRACTWRKFLWINBOX.TRANSACTIONCURRENCY == TCURC.WAERS