ESH_N_SALESQUOTATION

Anchor view -SALESQUOTATION | view: ESH_L_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 TEXT40
BUSINESSPARTNERNAME1 Name 1 TEXT40
SHIPTOPARTYNAME2 Name 2 TEXT40
BUSINESSPARTNERNAME2 Name 2 TEXT40
CREATEDBYUSER Name of Person Responsible for Creating the Object USNAM
DISTRIBUTIONCHANNEL Distribution Channel VTWEG
DISTRIBUTIONCHANNELNAME Distribution Channel Description TEXT20
DIVISIONNAME Division Description TEXT20
MATERIALBYCUSTOMER Material Number Used by Customer IDNEX
MATERIALNAME Material Description TEXT40
OVERALLSDDOCREFSTATUSDESC Status Description TEXT20
OVERALLSDPROCESSSTATUSDESC Status Description TEXT20
OVRLSDDOCUMENTREJECTIONSTSDESC Status Description TEXT20
PURCHASEORDERBYCUSTOMER Customer Reference BSTKD
SALESDOCUMENTTYPENAME Sales Document Type Description TEXT20
SALESORGANIZATION Sales Organization VKORG
SALESORGANIZATIONNAME Sales Organization Description TEXT20
SALESQUOTATIONITEMTEXT Short text for sales order item TEXT40
USERDESCRIPTION User Description SUIDTECHDESC
Master Data Relations Join Conditions
Material: order item
  • Client
  • Material Number
  • ESH_N_SALESQUOTATION.MANDT == MARA.MANDT
  • ESH_N_SALESQUOTATION.MATERIAL == MARA.MATNR
Division in order header
  • Client
  • Division
  • Distribution Channel
  • Sales Organization
  • ESH_N_SALESQUOTATION.MANDT == TVTA.MANDT
  • ESH_N_SALESQUOTATION.ORGANIZATIONDIVISION == TVTA.SPART
  • ESH_N_SALESQUOTATION.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • ESH_N_SALESQUOTATION.SALESORGANIZATION == TVTA.VKORG
Order type in order header
  • Client
  • Sales Document Type
  • ESH_N_SALESQUOTATION.MANDT == TVAK.MANDT
  • ESH_N_SALESQUOTATION.SALESQUOTATIONTYPE == TVAK.AUART
Customer - Document Customer
  • Client
  • Ship-to Party
  • Sold-to Party
  • ESH_N_SALESQUOTATION.MANDT == KNA1.MANDT
  • ESH_N_SALESQUOTATION.SHIPTOPARTY == KNA1.KUNNR
  • ESH_N_SALESQUOTATION.SOLDTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Ship-to Party
  • Sold-to Party
  • ESH_N_SALESQUOTATION.MANDT == KNA1.MANDT
  • ESH_N_SALESQUOTATION.SHIPTOPARTY == KNA1.KUNNR
  • ESH_N_SALESQUOTATION.SOLDTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • ESH_N_SALESQUOTATION.MANDT == TCURC.MANDT
  • ESH_N_SALESQUOTATION.TRANSACTIONCURRENCY == TCURC.WAERS