ESH_S_CUSTOMERRETURN

Search view -CUSTOMERRETURN | view: ESH_U_CUSTRETURN | TRAN | Extraction: Not supported | Component: Sales
Column Name Description
CUSTOMERRETURN Customer Return
Column Name Description
💲 SD Document Currency (TRANSACTIONCURRENCY):
TOTALNETAMOUNT Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
CUSTOMERRETURNDATE 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
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 TEXT20
MATERIALBYCUSTOMER Material Number Used by Customer IDNEX
MATERIALNAME Material Description TEXT40
OVERALLDELIVERYSTATUSDESC Status Description
OVERALLSDPROCESSSTATUSDESC Status Description
OVRLSDDOCUMENTREJECTIONSTSDESC Status Description
PURCHASEORDERBYCUSTOMER Customer Reference BSTKD
SALESDOCUMENTTYPENAME Sales Document Type Description TEXT20
SALESORGANIZATIONNAME Sales Organization Description
USERDESCRIPTION User Description SUIDTECHDESC
Master Data Relations Join Conditions
Order type in order header
  • Customer Return Type
  • Client
  • ESH_S_CUSTOMERRETURN.CUSTOMERRETURNTYPE == TVAK.AUART
  • ESH_S_CUSTOMERRETURN.MANDT == TVAK.MANDT
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • ESH_S_CUSTOMERRETURN.SALESORGANIZATION == TVKOV.VKORG
  • ESH_S_CUSTOMERRETURN.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • ESH_S_CUSTOMERRETURN.MANDT == TVKOV.MANDT
Material: order item
  • Material Number
  • Client
  • ESH_S_CUSTOMERRETURN.MATERIAL == MARA.MATNR
  • ESH_S_CUSTOMERRETURN.MANDT == MARA.MANDT
Division in order header
  • Division
  • Sales Organization
  • Distribution Channel
  • Client
  • ESH_S_CUSTOMERRETURN.ORGANIZATIONDIVISION == TVTA.SPART
  • ESH_S_CUSTOMERRETURN.SALESORGANIZATION == TVTA.VKORG
  • ESH_S_CUSTOMERRETURN.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • ESH_S_CUSTOMERRETURN.MANDT == TVTA.MANDT
Return Reason
  • Return Reason
  • Client
Sales organization in order header
  • Sales Organization
  • Client
  • ESH_S_CUSTOMERRETURN.SALESORGANIZATION == TVKO.VKORG
  • ESH_S_CUSTOMERRETURN.MANDT == TVKO.MANDT
Customer - Document Customer
  • Ship-to Party
  • Sold-to Party
  • Client
  • ESH_S_CUSTOMERRETURN.SHIPTOPARTY == KNA1.KUNNR
  • ESH_S_CUSTOMERRETURN.SOLDTOPARTY == KNA1.KUNNR
  • ESH_S_CUSTOMERRETURN.MANDT == KNA1.MANDT
Sold-to Party
  • Ship-to Party
  • Sold-to Party
  • Client
  • ESH_S_CUSTOMERRETURN.SHIPTOPARTY == KNA1.KUNNR
  • ESH_S_CUSTOMERRETURN.SOLDTOPARTY == KNA1.KUNNR
  • ESH_S_CUSTOMERRETURN.MANDT == KNA1.MANDT
Currency in order header
  • SD Document Currency
  • Client
  • ESH_S_CUSTOMERRETURN.TRANSACTIONCURRENCY == TCURC.WAERS
  • ESH_S_CUSTOMERRETURN.MANDT == TCURC.MANDT