ESH_N_CUSTOMERRETURNDELIVERY

Anchor view -CUSTOMERRETURNDELIVERY | view: ESH_L_CSTRETDLV | TRAN | Extraction: Not supported | Component: Basic Functions
Tables used: LIKPLIPSMATDOCKNA1TVLKTVLKTTPRIOTPRITTVKOTVKOTTVSTTVSTTT006T006AUSR21TVBST
Column Name Description
CUSTOMERRETURNDELIVERY Customer Return Delivery
Column Name Description
Column Name Description
📏 Weight Unit (HEADERWEIGHTUNIT):
HEADERGROSSWEIGHT Total Weight
HEADERNETWEIGHT Net weight
📏 Volume unit (HEADERVOLUMEUNIT):
HEADERVOLUME Volume
Column Name Description
ACTUALGOODSMOVEMENTDATE Actual Goods Movement Date
CREATIONDATE Date on which the record was created
DELIVERYDATE Delivery Date
LOADINGDATE Loading Date
PICKINGDATE Picking Date
PLANNEDGOODSISSUEDATE Planned Goods Movement Date
TRANSPORTATIONPLANNINGDATE Transportation Planning Date
Column Name Description
OVERALLPUTAWAYSTATUS Picking Status/Putaway Status (All Items) Show values
OVERALLSDPROCESSSTATUS Overall Processing Status (Header/All Items) Show values
REFERENCESDDOCUMENTCATEGORY Document Category of Preceding SD Document Show values
Column Name Description Domain name
CREATEDBYUSER Name of Person Responsible for Creating the Object USNAM
DELIVERYDOCUMENTBYSUPPLIER External Identification of Delivery Note TEXT35
DELIVERYDOCUMENTITEMTEXT Short text for sales order item TEXT40
DELIVERYDOCUMENTTYPENAME Description TEXT20
DELIVERYPRIORITYDESC Description TEXT20
MATERIALDOCUMENT Number of Material Document BELNR
MATERIALDOCUMENTYEAR Material Document Year GJAHR
SOLDTOORGANIZATIONBPNAME1 Name 1 NAME
SHIPTOORGANIZATIONBPNAME1 Name 1 NAME
SOLDTOORGANIZATIONBPNAME2 Name 2 NAME
SHIPTOORGANIZATIONBPNAME2 Name 2 NAME
OVERALLSDPROCESSSTATUSDESC Status Description TEXT20
PUTAWAYSTATUSNAME Short Text for Fixed Values DDTEXT
REFERENCESDDOCUMENT Document number of the reference document VBELN
REFERENCESDDOCUMENTITEM Item number of the reference item POSNR
SALESORGANIZATIONNAME Sales Organization Description TEXT20
SHIPPINGPOINTNAME Description TEXT30
DELIVVOLUMEUOMCOMMERCIALNAME External Unit of Measurement in Commercial Format (3-Char.) MSEH3
DELIVWEIGHTUOMCOMMERCIALNAME External Unit of Measurement in Commercial Format (3-Char.) MSEH3
USERDESCRIPTION User Description SUIDTECHDESC
Master Data Relations Join Conditions
Delivery Type
  • Client
  • Delivery Type
  • ESH_N_CUSTOMERRETURNDELIVERY.MANDT == TVLK.MANDT
  • ESH_N_CUSTOMERRETURNDELIVERY.DELIVERYDOCUMENTTYPE == TVLK.LFART
Delivery Priority
  • Client
  • Delivery Priority
  • ESH_N_CUSTOMERRETURNDELIVERY.MANDT == TPRIO.MANDT
  • ESH_N_CUSTOMERRETURNDELIVERY.DELIVERYPRIORITY == TPRIO.LPRIO
Volume unit
  • Client
  • Volume unit
  • ESH_N_CUSTOMERRETURNDELIVERY.MANDT == T006.MANDT
  • ESH_N_CUSTOMERRETURNDELIVERY.HEADERVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Weight Unit
  • Client
  • ESH_N_CUSTOMERRETURNDELIVERY.HEADERWEIGHTUNIT == T006.MSEHI
  • ESH_N_CUSTOMERRETURNDELIVERY.MANDT == T006.MANDT
Material Number
  • Client
  • Material Number
  • ESH_N_CUSTOMERRETURNDELIVERY.MANDT == MARA.MANDT
  • ESH_N_CUSTOMERRETURNDELIVERY.MATERIAL == MARA.MATNR
Sales Organization
  • Client
  • Sales Organization
  • ESH_N_CUSTOMERRETURNDELIVERY.MANDT == TVKO.MANDT
  • ESH_N_CUSTOMERRETURNDELIVERY.SALESORGANIZATION == TVKO.VKORG
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • ESH_N_CUSTOMERRETURNDELIVERY.MANDT == TVST.MANDT
  • ESH_N_CUSTOMERRETURNDELIVERY.SHIPPINGPOINT == TVST.VSTEL
Ship-to Party
  • Client
  • Ship-to Party
  • ESH_N_CUSTOMERRETURNDELIVERY.MANDT == KNA1.MANDT
  • ESH_N_CUSTOMERRETURNDELIVERY.SHIPTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Sold-to Party
  • ESH_N_CUSTOMERRETURNDELIVERY.MANDT == KNA1.MANDT
  • ESH_N_CUSTOMERRETURNDELIVERY.SOLDTOPARTY == KNA1.KUNNR