ESH_N_SALESCONTRACT

Anchor view -SALESCONTRACT | view: ESH_L_SLSCONTRCT | 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, CVI_VEND_LINK, USR21, TVBST, TVBST, TVBST

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

Column Name	Description
SALESCONTRACT	Sales Contract

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

Column Name	Description

Column Name	Description
SALESCONTRACTDATE	Document Date (Date Received/Sent)
SALESCONTRACTVALIDITYENDDATE	Valid-To Date (Outline Agreements, Product Proposals)
SALESCONTRACTVALIDITYSTARTDATE	Valid-From Date (Outline Agreements, Product Proposals)

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
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
MASTERSALESCONTRACT	Master Contract Number	VBELN
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
SALESCONTRACTITEMTEXT	Short text for sales order item	TEXT40
SALESDOCUMENTTYPENAME	Sales Document Type Description	TEXT20
SALESORGANIZATIONNAME	Sales Organization Description	TEXT20
USERDESCRIPTION	User Description	SUIDTECHDESC

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