ESH_S_SALESINQUIRY

Search view -SALESINQUIRY | view: ESH_U_SLSINQY | Extraction: Not supported | Component: Sales Inquiries / Sales Quotations

Tables used: VBAP, VBKD, VEDA, VBAK, 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

🔑 Keys (1)
💰 Amounts (1)
∑ Quantities
📅 Dates (3)
☰ Categorical (3)
Other (17)
🔗 Relations (8)

Column Name	Description
SALESINQUIRY	Sales Inquiry

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
SALESINQUIRYDATE	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
SOLDTOPARTYNAME1	Name 1	TEXT40
SHIPTOPARTYNAME1	Name 1	TEXT40
SOLDTOPARTYNAME2	Name 2	TEXT40
SHIPTOPARTYNAME2	Name 2	TEXT40
CREATEDBYUSER	Name of Person Responsible for Creating the Object	USNAM
DISTRIBUTIONCHANNELNAME	Distribution Channel Description
DIVISIONNAME	Division Description
MATERIALBYCUSTOMER	Material Number Used by Customer	IDNEX
MATERIALNAME	Material Description	TEXT40
OVERALLSDDOCREFSTATUSDESC	Status Description
OVERALLSDPROCESSSTATUSDESC	Status Description
OVRLSDDOCUMENTREJECTIONSTSDESC	Status Description
PURCHASEORDERBYCUSTOMER	Customer Reference	BSTKD
SALESDOCUMENTTYPENAME	Sales Document Type Description	TEXT20
SALESINQUIRYITEMTEXT	Short text for sales order item	TEXT40
SALESORGANIZATIONNAME	Sales Organization Description
USERDESCRIPTION	User Description	SUIDTECHDESC

Master Data Relations	Join Conditions
Distribution channel in order header Sales Organization Client Distribution Channel	`ESH_S_SALESINQUIRY.SALESORGANIZATION == TVKOV.VKORG` `ESH_S_SALESINQUIRY.MANDT == TVKOV.MANDT` `ESH_S_SALESINQUIRY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG`
Material: order item Client Material Number	`ESH_S_SALESINQUIRY.MANDT == MARA.MANDT` `ESH_S_SALESINQUIRY.MATERIAL == MARA.MATNR`
Division in order header Sales Organization Division Client Distribution Channel	`ESH_S_SALESINQUIRY.SALESORGANIZATION == TVTA.VKORG` `ESH_S_SALESINQUIRY.ORGANIZATIONDIVISION == TVTA.SPART` `ESH_S_SALESINQUIRY.MANDT == TVTA.MANDT` `ESH_S_SALESINQUIRY.DISTRIBUTIONCHANNEL == TVTA.VTWEG`
Order type in order header Sales Document Type Client	`ESH_S_SALESINQUIRY.SALESINQUIRYTYPE == TVAK.AUART` `ESH_S_SALESINQUIRY.MANDT == TVAK.MANDT`
Sales organization in order header Sales Organization Client	`ESH_S_SALESINQUIRY.SALESORGANIZATION == TVKO.VKORG` `ESH_S_SALESINQUIRY.MANDT == TVKO.MANDT`
Customer - Document Customer Sold-to Party Ship-to Party Client	`ESH_S_SALESINQUIRY.SOLDTOPARTY == KNA1.KUNNR` `ESH_S_SALESINQUIRY.SHIPTOPARTY == KNA1.KUNNR` `ESH_S_SALESINQUIRY.MANDT == KNA1.MANDT`
Sold-to Party Sold-to Party Ship-to Party Client	`ESH_S_SALESINQUIRY.SOLDTOPARTY == KNA1.KUNNR` `ESH_S_SALESINQUIRY.SHIPTOPARTY == KNA1.KUNNR` `ESH_S_SALESINQUIRY.MANDT == KNA1.MANDT`
Currency in order header SD Document Currency Client	`ESH_S_SALESINQUIRY.TRANSACTIONCURRENCY == TCURC.WAERS` `ESH_S_SALESINQUIRY.MANDT == TCURC.MANDT`