ESH_S_SALESQUOTATION

Search view -SALESQUOTATION | view: ESH_U_SLSQUOTN | TRAN | Extraction: Not supported | Component: Sales Inquiries / Sales Quotations
Column Name Description
SALESQUOTATION Sales Quotation
Column Name Description
💲 SD Document Currency (TRANSACTIONCURRENCY):
TOTALNETAMOUNT Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
BINDINGPERIODVALIDITYENDDATE Date Until Which Bid/Quotation is Binding (Valid-To Date)
BINDINGPERIODVALIDITYSTARTDATE Quotation/Inquiry is Valid From
SALESQUOTATIONDATE Document Date (Date Received/Sent)
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
SHIPTOPARTYNAME1 Name 1
BUSINESSPARTNERNAME1 Name 1
SHIPTOPARTYNAME2 Name 2
BUSINESSPARTNERNAME2 Name 2
CREATEDBYUSER Name of Person Responsible for Creating the Object USNAM
DISTRIBUTIONCHANNEL Distribution Channel VTWEG
DISTRIBUTIONCHANNELNAME Distribution Channel Description
DIVISIONNAME Division Description
MATERIALBYCUSTOMER Material Number Used by Customer IDNEX
MATERIALNAME Material Description
OVERALLSDDOCREFSTATUSDESC Status Description
OVERALLSDPROCESSSTATUSDESC Status Description
OVRLSDDOCUMENTREJECTIONSTSDESC Status Description
PURCHASEORDERBYCUSTOMER Customer Reference BSTKD
SALESDOCUMENTTYPENAME Sales Document Type Description
SALESORGANIZATION Sales Organization VKORG
SALESORGANIZATIONNAME Sales Organization Description
SALESQUOTATIONITEMTEXT Short text for sales order item TEXT40
USERDESCRIPTION User Description
Master Data Relations Join Conditions
Material: order item
  • Client
  • Material Number
  • ESH_S_SALESQUOTATION.MANDT == MARA.MANDT
  • ESH_S_SALESQUOTATION.MATERIAL == MARA.MATNR
Division in order header
  • Client
  • Sales Organization
  • Division
  • Distribution Channel
  • ESH_S_SALESQUOTATION.MANDT == TVTA.MANDT
  • ESH_S_SALESQUOTATION.SALESORGANIZATION == TVTA.VKORG
  • ESH_S_SALESQUOTATION.ORGANIZATIONDIVISION == TVTA.SPART
  • ESH_S_SALESQUOTATION.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Order type in order header
  • Sales Document Type
  • Client
  • ESH_S_SALESQUOTATION.SALESQUOTATIONTYPE == TVAK.AUART
  • ESH_S_SALESQUOTATION.MANDT == TVAK.MANDT
Customer - Document Customer
  • Sold-to Party
  • Ship-to Party
  • Client
  • ESH_S_SALESQUOTATION.SOLDTOPARTY == KNA1.KUNNR
  • ESH_S_SALESQUOTATION.SHIPTOPARTY == KNA1.KUNNR
  • ESH_S_SALESQUOTATION.MANDT == KNA1.MANDT
Sold-to Party
  • Sold-to Party
  • Ship-to Party
  • Client
  • ESH_S_SALESQUOTATION.SOLDTOPARTY == KNA1.KUNNR
  • ESH_S_SALESQUOTATION.SHIPTOPARTY == KNA1.KUNNR
  • ESH_S_SALESQUOTATION.MANDT == KNA1.MANDT
Currency in order header
  • SD Document Currency
  • Client
  • ESH_S_SALESQUOTATION.TRANSACTIONCURRENCY == TCURC.WAERS
  • ESH_S_SALESQUOTATION.MANDT == TCURC.MANDT