ESH_S_SALESORDER

Search view -SALESORDER | view: ESH_U_SALESORDER | 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, TVAU, TVAUT, CVI_VEND_LINK, USR21, TVBST, TVBST, TVBST, TVBST

🔑 Keys (1)
💰 Amounts (1)
∑ Quantities
📅 Dates (1)
☰ Categorical (5)
Other (19)
🔗 Relations (9)

Column Name	Description
SALESORDER	Sales Order

Column Name	Description
💲 SD Document Currency (TRANSACTIONCURRENCY):
TOTALNETAMOUNT	Net Value of the Sales Order in Document Currency

Column Name	Description

Column Name	Description
SALESORDERDATE	Document Date (Date Received/Sent)

Column Name	Description
OVERALLDELIVERYSTATUS	Delivery Status (All Items)	Show values
OVERALLSDDOCUMENTREJECTIONSTS	Rejection Status (All Items)	Show values
OVERALLSDPROCESSSTATUS	Overall Processing Status (Header/All Items)	Show values
OVERALLTOTALDELIVERYSTATUS	Overall Delivery Status (All Items)	Show values
TOTALCREDITCHECKSTATUS	Overall Status of Credit Checks	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
DISTRIBUTIONCHANNELNAME	Distribution Channel Description
DIVISIONNAME	Division Description
MATERIALBYCUSTOMER	Material Number Used by Customer	IDNEX
MATERIALNAME	Material Description
OVERALLDELIVERYSTATUSDESC	Status Description
OVERALLSDPROCESSSTATUSDESC	Status Description
OVRLSDDOCUMENTREJECTIONSTSDESC	Status Description
PURCHASEORDERBYCUSTOMER	Customer Reference	BSTKD
SALESDOCUMENTTYPENAME	Sales Document Type Description
SALESORDERITEMTEXT	Short text for sales order item	TEXT40
SALESORGANIZATIONNAME	Sales Organization Description
SDDOCUMENTREASONTEXT	Description
TOTALCREDITCHECKSTATUSDESC	Status Description
CREATEDBYUSERNAME	User Description

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