I_SalesContractSituation

Sales Contract Situation | view: ISDSLESCONTST | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBAK, VBAP, VBKD, VEDA, VBPA, VBPA, CVI_CUST_CT_LINK, BUT0ID, BUT000, USR21, CVI_CUST_LINK, TVKO, CVI_VEND_LINK, ADRP, BUT000, BUT0ID, TB039A, TB003, BUT100, BPU_ROLECAT_WHL, BPU_ROLECAT_WHL
Column Name Description
SalesContract Sales Contract
SalesDocumentType FK Sales Document Type
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
SalesContractReleasedAmount Released Value in Sales Contracts in Transaction Currency
Column Name Description
Column Name Description
CreationDate Date on which the record was created
SalesContractDate Document Date (Date Received/Sent)
SalesContractValidityStartDate Sales Contract Valid-From Date
SalesContractValidityEndDate Sales Contract Valid-To Date
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallSDDocReferenceStatus Reference Status (All Items) Show values
Column Name Description Domain name
ResponsibleEmployee Employee Responsible PERNR
SalesEmployee Sales Employee PERNR
CreatedByUser Name of Person Responsible for Creating the Object USNAM
SalesContractFulfillmentRate Contract Fulfillment Rate in percentage
DueDays Days Before Expiry of Contract INT4
SlsContrPeriodElapsedPercent Sales Contract Period Elapsed Percent
SlsContrFulfillToTimeRatio Relative Contract Fulfillment Pace
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • I_SALESCONTRACTSITUATION.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • I_SALESCONTRACTSITUATION.MANDT == TVV1.MANDT
Customer Group 2
  • Client
  • Customer Group 2
  • I_SALESCONTRACTSITUATION.MANDT == TVV2.MANDT
  • I_SALESCONTRACTSITUATION.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • I_SALESCONTRACTSITUATION.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • I_SALESCONTRACTSITUATION.MANDT == TVV3.MANDT
Customer Group 4
  • Client
  • Customer Group 4
  • I_SALESCONTRACTSITUATION.MANDT == TVV4.MANDT
  • I_SALESCONTRACTSITUATION.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Customer Group 5
  • Client
  • I_SALESCONTRACTSITUATION.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • I_SALESCONTRACTSITUATION.MANDT == TVV5.MANDT
Customer Group
  • Customer Group
  • Client
  • I_SALESCONTRACTSITUATION.CUSTOMERGROUP == T151.KDGRP
  • I_SALESCONTRACTSITUATION.MANDT == T151.MANDT
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • I_SALESCONTRACTSITUATION.MANDT == TVKOV.MANDT
  • I_SALESCONTRACTSITUATION.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_SALESCONTRACTSITUATION.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Division
  • Client
  • Distribution Channel
  • Sales Organization
  • I_SALESCONTRACTSITUATION.DIVISION == TVTA.SPART
  • I_SALESCONTRACTSITUATION.MANDT == TVTA.MANDT
  • I_SALESCONTRACTSITUATION.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_SALESCONTRACTSITUATION.SALESORGANIZATION == TVTA.VKORG
Address key assignment to users
  • Sales Employee User ID
  • Sales Employee User ID
  • Client
  • I_SALESCONTRACTSITUATION.SALESEMPLOYEEUSERID == USR02.BNAME
  • I_SALESCONTRACTSITUATION.RESPONSIBLEEMPLOYEEUSERID == USR02.BNAME
  • I_SALESCONTRACTSITUATION.MANDT == USR02.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • I_SALESCONTRACTSITUATION.SALESDOCUMENTTYPE == TVAK.AUART
  • I_SALESCONTRACTSITUATION.MANDT == TVAK.MANDT
Address key assignment to users
  • Sales Employee User ID
  • Sales Employee User ID
  • Client
  • I_SALESCONTRACTSITUATION.SALESEMPLOYEEUSERID == USR02.BNAME
  • I_SALESCONTRACTSITUATION.RESPONSIBLEEMPLOYEEUSERID == USR02.BNAME
  • I_SALESCONTRACTSITUATION.MANDT == USR02.MANDT
Sales group
  • Client
  • Sales office
  • Sales group
  • I_SALESCONTRACTSITUATION.MANDT == TVBVK.MANDT
  • I_SALESCONTRACTSITUATION.SALESOFFICE == TVBVK.VKBUR
  • I_SALESCONTRACTSITUATION.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • I_SALESCONTRACTSITUATION.MANDT == TVKO.MANDT
  • I_SALESCONTRACTSITUATION.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • I_SALESCONTRACTSITUATION.MANDT == KNA1.MANDT
  • I_SALESCONTRACTSITUATION.SOLDTOPARTY == KNA1.KUNNR
Currency in order header
  • SD Document Currency
  • Client
  • I_SALESCONTRACTSITUATION.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_SALESCONTRACTSITUATION.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Client
  • Sales office
  • Distribution Channel
  • Sales Organization
  • I_SALESCONTRACTSITUATION.DIVISION == TVKBZ.SPART
  • I_SALESCONTRACTSITUATION.MANDT == TVKBZ.MANDT
  • I_SALESCONTRACTSITUATION.SALESOFFICE == TVKBZ.VKBUR
  • I_SALESCONTRACTSITUATION.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_SALESCONTRACTSITUATION.SALESORGANIZATION == TVKBZ.VKORG