ESH_N_SALESSCHEDULINGAGREEMENT

Anchor view -SALESSCHEDULINGAGREEMENT | view: ESH_L_SALESCHEDG | TRAN | Extraction: Not supported | Component: Customer Scheduling Agreement

Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBPA, VBPA, ADCP, ADRC, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, MARA, MAKT, T001W, TVKO, TVKOT, T001L, CVI_VEND_LINK, USR21

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities
📅 Dates (1)
☰ Categorical (1)
Other (13)
🔗 Relations (10)

Column Name	Description
SALESSCHEDULINGAGREEMENT FK	Sales Scheduling Agreement
SALESSCHEDULINGAGREEMENTITEM	Sales Scheduling Agreement Item

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

Column Name	Description

Column Name	Description
CREATIONDATE	Date on which the record was created

Column Name	Description
DELIVSCHEDTYPEMRPRLVNCECODE	MRP for delivery schedule types	Show values

Column Name	Description	Domain name
SHIPTOPARTYNAME1	Name 1	TEXT40
SOLDTOPARTYNAME1	Name 1	TEXT40
SHIPTOPARTYNAME2	Name 2	TEXT40
SOLDTOPARTYNAME2	Name 2	TEXT40
CREATEDBYUSER	Name of Person Responsible for Creating the Object	USNAM
MATERIALBYCUSTOMER	Material Number Used by Customer	IDNEX
MATERIALNAME	Material Description	TEXT40
PLANT	Plant (Own or External)	WERKS
PLANTNAME	Plant Name	TEXT30
PURCHASEORDERBYCUSTOMER	Customer Reference	BSTKD
SALESORGANIZATIONNAME	Sales Organization Description	TEXT20
STORAGELOCATIONNAME	Storage Location Name	TEXT16
USERDESCRIPTION	User Description	SUIDTECHDESC

Master Data Relations	Join Conditions
Distribution channel in order header Client Sales Organization Distribution Channel	`ESH_N_SALESSCHEDULINGAGREEMENT.MANDT == TVKOV.MANDT` `ESH_N_SALESSCHEDULINGAGREEMENT.SALESORGANIZATION == TVKOV.VKORG` `ESH_N_SALESSCHEDULINGAGREEMENT.DISTRIBUTIONCHANNEL == TVKOV.VTWEG`
Material: order item Client Material Number	`ESH_N_SALESSCHEDULINGAGREEMENT.MANDT == MARA.MANDT` `ESH_N_SALESSCHEDULINGAGREEMENT.MATERIAL == MARA.MATNR`
Division in order header Client Sales Organization Distribution Channel Division	`ESH_N_SALESSCHEDULINGAGREEMENT.MANDT == TVTA.MANDT` `ESH_N_SALESSCHEDULINGAGREEMENT.SALESORGANIZATION == TVTA.VKORG` `ESH_N_SALESSCHEDULINGAGREEMENT.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `ESH_N_SALESSCHEDULINGAGREEMENT.ORGANIZATIONDIVISION == TVTA.SPART`
Sales organization in order header Client Sales Organization	`ESH_N_SALESSCHEDULINGAGREEMENT.MANDT == TVKO.MANDT` `ESH_N_SALESSCHEDULINGAGREEMENT.SALESORGANIZATION == TVKO.VKORG`
Order type in order header Sales Scheduling Agreement Type Client	`ESH_N_SALESSCHEDULINGAGREEMENT.SALESSCHEDGAGRMTTYPE == TVAK.AUART` `ESH_N_SALESSCHEDULINGAGREEMENT.MANDT == TVAK.MANDT`
Customer - Document Customer Client Ship-to Party Sold-to Party	`ESH_N_SALESSCHEDULINGAGREEMENT.MANDT == KNA1.MANDT` `ESH_N_SALESSCHEDULINGAGREEMENT.SHIPTOPARTY == KNA1.KUNNR` `ESH_N_SALESSCHEDULINGAGREEMENT.SOLDTOPARTY == KNA1.KUNNR`
Sold-to Party Client Ship-to Party Sold-to Party	`ESH_N_SALESSCHEDULINGAGREEMENT.MANDT == KNA1.MANDT` `ESH_N_SALESSCHEDULINGAGREEMENT.SHIPTOPARTY == KNA1.KUNNR` `ESH_N_SALESSCHEDULINGAGREEMENT.SOLDTOPARTY == KNA1.KUNNR`
Storage location Client Plant (Own or External) Storage location	`ESH_N_SALESSCHEDULINGAGREEMENT.MANDT == T001L.MANDT` `ESH_N_SALESSCHEDULINGAGREEMENT.PLANT == T001L.WERKS` `ESH_N_SALESSCHEDULINGAGREEMENT.STORAGELOCATION == T001L.LGORT`
Currency in order header Client SD Document Currency	`ESH_N_SALESSCHEDULINGAGREEMENT.MANDT == TCURC.MANDT` `ESH_N_SALESSCHEDULINGAGREEMENT.TRANSACTIONCURRENCY == TCURC.WAERS`