ESH_N_SALESORDER

Anchor view -SALESORDER | view: ESH_L_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	TEXT40
SHIPTOPARTYNAME1	Name 1	TEXT40
BUSINESSPARTNERNAME2	Name 2	TEXT40
SHIPTOPARTYNAME2	Name 2	TEXT40
CREATEDBYUSER	Name of Person Responsible for Creating the Object	USNAM
DISTRIBUTIONCHANNELNAME	Distribution Channel Description	TEXT20
DIVISIONNAME	Division Description	TEXT20
MATERIALBYCUSTOMER	Material Number Used by Customer	IDNEX
MATERIALNAME	Material Description	TEXT40
OVERALLDELIVERYSTATUSDESC	Status Description	TEXT20
OVERALLSDPROCESSSTATUSDESC	Status Description	TEXT20
OVRLSDDOCUMENTREJECTIONSTSDESC	Status Description	TEXT20
PURCHASEORDERBYCUSTOMER	Customer Reference	BSTKD
SALESDOCUMENTTYPENAME	Sales Document Type Description	TEXT20
SALESORDERITEMTEXT	Short text for sales order item	TEXT40
SALESORGANIZATIONNAME	Sales Organization Description	TEXT20
SDDOCUMENTREASONTEXT	Description	TEXT40
TOTALCREDITCHECKSTATUSDESC	Status Description	TEXT20
CREATEDBYUSERNAME	User Description	SUIDTECHDESC

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