ESH_S_SALESCONTRACT

Search view -SALESCONTRACT | view: ESH_U_SLSCONTRCT | TRAN | Extraction: Not supported | Component: Sales
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBPA, VBPA, ADCP, ADRC, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, TVTW, TVTWT, TSPA, TSPAT, MARA, MAKT, TVAK, TVAKT, TVKO, TVKOT, CVI_VEND_LINK, USR21, TVBST, TVBST, TVBST
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
SALESCONTRACTDATE Document Date (Date Received/Sent)
SALESCONTRACTVALIDITYENDDATE Valid-To Date (Outline Agreements, Product Proposals)
SALESCONTRACTVALIDITYSTARTDATE Valid-From Date (Outline Agreements, Product Proposals)
Column Name Description
OVERALLSDDOCREFERENCESTATUS Reference Status (All Items) Show values
OVERALLSDDOCUMENTREJECTIONSTS Rejection Status (All Items) Show values
OVERALLSDPROCESSSTATUS Overall Processing Status (Header/All Items) Show values
Column Name Description Domain name
BUSINESSPARTNERNAME1 Name 1
SHIPTOPARTYNAME1 Name 1
BUSINESSPARTNERNAME2 Name 2
SHIPTOPARTYNAME2 Name 2
CREATEDBYUSER Name of Person Responsible for Creating the Object USNAM
DISTRIBUTIONCHANNELNAME Distribution Channel Description
DIVISIONNAME Division Description
MASTERSALESCONTRACT Master Contract Number VBELN
MATERIALBYCUSTOMER Material Number Used by Customer IDNEX
MATERIALNAME Material Description
OVERALLSDDOCREFSTATUSDESC Status Description
OVERALLSDPROCESSSTATUSDESC Status Description
OVRLSDDOCUMENTREJECTIONSTSDESC Status Description
PURCHASEORDERBYCUSTOMER Customer Reference BSTKD
SALESCONTRACTITEMTEXT Short text for sales order item TEXT40
SALESDOCUMENTTYPENAME Sales Document Type Description
SALESORGANIZATIONNAME Sales Organization Description
USERDESCRIPTION User Description
Master Data Relations Join Conditions
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • ESH_S_SALESCONTRACT.SALESORGANIZATION == TVKOV.VKORG
  • ESH_S_SALESCONTRACT.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • ESH_S_SALESCONTRACT.MANDT == TVKOV.MANDT
Material: order item
  • Material Number
  • Client
  • ESH_S_SALESCONTRACT.MATERIAL == MARA.MATNR
  • ESH_S_SALESCONTRACT.MANDT == MARA.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • ESH_S_SALESCONTRACT.SALESORGANIZATION == TVTA.VKORG
  • ESH_S_SALESCONTRACT.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • ESH_S_SALESCONTRACT.MANDT == TVTA.MANDT
  • ESH_S_SALESCONTRACT.ORGANIZATIONDIVISION == TVTA.SPART
Order type in order header
  • Sales Contract Type
  • Client
  • ESH_S_SALESCONTRACT.SALESCONTRACTTYPE == TVAK.AUART
  • ESH_S_SALESCONTRACT.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • ESH_S_SALESCONTRACT.SALESORGANIZATION == TVKO.VKORG
  • ESH_S_SALESCONTRACT.MANDT == TVKO.MANDT
Customer - Document Customer
  • Client
  • Sold-to Party
  • Ship-to Party
  • ESH_S_SALESCONTRACT.MANDT == KNA1.MANDT
  • ESH_S_SALESCONTRACT.SOLDTOPARTY == KNA1.KUNNR
  • ESH_S_SALESCONTRACT.SHIPTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Sold-to Party
  • Ship-to Party
  • ESH_S_SALESCONTRACT.MANDT == KNA1.MANDT
  • ESH_S_SALESCONTRACT.SOLDTOPARTY == KNA1.KUNNR
  • ESH_S_SALESCONTRACT.SHIPTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • ESH_S_SALESCONTRACT.MANDT == TCURC.MANDT
  • ESH_S_SALESCONTRACT.TRANSACTIONCURRENCY == TCURC.WAERS