ESH_N_CUSTOMERRETURN

Anchor view -CUSTOMERRETURN | view: ESH_L_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 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
SALESORGANIZATIONNAME Sales Organization Description TEXT20
USERDESCRIPTION User Description SUIDTECHDESC
Master Data Relations Join Conditions
Order type in order header
  • Customer Return Type
  • Client
  • ESH_N_CUSTOMERRETURN.CUSTOMERRETURNTYPE == TVAK.AUART
  • ESH_N_CUSTOMERRETURN.MANDT == TVAK.MANDT
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • ESH_N_CUSTOMERRETURN.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • ESH_N_CUSTOMERRETURN.MANDT == TVKOV.MANDT
  • ESH_N_CUSTOMERRETURN.SALESORGANIZATION == TVKOV.VKORG
Material: order item
  • Material Number
  • Client
  • ESH_N_CUSTOMERRETURN.MATERIAL == MARA.MATNR
  • ESH_N_CUSTOMERRETURN.MANDT == MARA.MANDT
Division in order header
  • Division
  • Distribution Channel
  • Client
  • Sales Organization
  • ESH_N_CUSTOMERRETURN.ORGANIZATIONDIVISION == TVTA.SPART
  • ESH_N_CUSTOMERRETURN.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • ESH_N_CUSTOMERRETURN.MANDT == TVTA.MANDT
  • ESH_N_CUSTOMERRETURN.SALESORGANIZATION == TVTA.VKORG
Return Reason
  • Return Reason
  • Client
Sales organization in order header
  • Client
  • Sales Organization
  • ESH_N_CUSTOMERRETURN.MANDT == TVKO.MANDT
  • ESH_N_CUSTOMERRETURN.SALESORGANIZATION == TVKO.VKORG
Customer - Document Customer
  • Sold-to Party
  • Ship-to Party
  • Client
  • ESH_N_CUSTOMERRETURN.SOLDTOPARTY == KNA1.KUNNR
  • ESH_N_CUSTOMERRETURN.SHIPTOPARTY == KNA1.KUNNR
  • ESH_N_CUSTOMERRETURN.MANDT == KNA1.MANDT
Sold-to Party
  • Sold-to Party
  • Ship-to Party
  • Client
  • ESH_N_CUSTOMERRETURN.SOLDTOPARTY == KNA1.KUNNR
  • ESH_N_CUSTOMERRETURN.SHIPTOPARTY == KNA1.KUNNR
  • ESH_N_CUSTOMERRETURN.MANDT == KNA1.MANDT
Currency in order header
  • SD Document Currency
  • Client
  • ESH_N_CUSTOMERRETURN.TRANSACTIONCURRENCY == TCURC.WAERS
  • ESH_N_CUSTOMERRETURN.MANDT == TCURC.MANDT