ESH_N_CUSTOMERRETURNDELIVERY

DDL: ESH_N_CUSTOMERRETURNDELIVERY SQL: ESH_L_CSTRETDLV Type: view
43 Fields 1 Data Sources 2 Associations

ESH_N_CUSTOMERRETURNDELIVERY is a CDS View in SAP S/4HANA. It reads from 1 data source (I_CUSTOMERRETURNDELIVERY) and exposes 43 fields with key field CUSTOMERRETURNDELIVERY. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CUSTOMERRETURNDELIVERY I_CUSTOMERRETURNDELIVERY from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (2)

CardinalityTargetAliasCondition
[0..1] N_OVERALLSDPROCESSSTATUS _OVERALLSDPROCESSSTATUS $projection.OverallSDProcessStatus=_OVERALLSDPROCESSSTATUS.OverallSDProcessStatus
[0..*] dd07t _OVERALLPUTAWAYSTATUS $projection.OverallPutawayStatus=_OVERALLPUTAWAYSTATUS.domvalue_l and _OVERALLPUTAWAYSTATUS.domname='LE_PUTAWAY_STATUS' and _OVERALLPUTAWAYSTATUS.as4local='A'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.sqlViewName ESH_L_CSTRETDLV view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY CUSTOMERRETURNDELIVERY CUSTOMERRETURNDELIVERY
ACTUALGOODSMOVEMENTDATE ACTUALGOODSMOVEMENTDATE
CREATEDBYUSER CREATEDBYUSER User Name
CREATIONDATE CREATIONDATE Time Stamp
DELIVERYDATE DELIVERYDATE Delivery Date
DELIVERYDOCUMENTBYSUPPLIER DELIVERYDOCUMENTBYSUPPLIER
DELIVERYDOCUMENTITEMTEXT _ITEM DELIVERYDOCUMENTITEMTEXT
DELIVERYDOCUMENTTYPE DELIVERYDOCUMENTTYPE Delivery Type
DELIVERYDOCUMENTTYPENAME
DELIVERYPRIORITY DELIVERYPRIORITY Delivery Prior.
DELIVERYPRIORITYDESC
HEADERGROSSWEIGHT HEADERGROSSWEIGHT
HEADERNETWEIGHT HEADERNETWEIGHT
HEADERVOLUME HEADERVOLUME
HEADERVOLUMEUNIT HEADERVOLUMEUNIT
HEADERWEIGHTUNIT HEADERWEIGHTUNIT
LOADINGDATE LOADINGDATE Loading Date
MATERIAL _ITEM MATERIAL Vehicle Model
MATERIALDOCUMENT _MATERIALDOCUMENTHEADER MATERIALDOCUMENT Material Doc.
MATERIALDOCUMENTYEAR _MATERIALDOCUMENTHEADER MATERIALDOCUMENTYEAR Material Document Year
SHIPTOORGANIZATIONBPNAME1 _SHIPTOPARTY ORGANIZATIONBPNAME1 Name 1
SOLDTOORGANIZATIONBPNAME1 _SOLDTOPARTY ORGANIZATIONBPNAME1 Name 1
SHIPTOORGANIZATIONBPNAME2 _SHIPTOPARTY ORGANIZATIONBPNAME2 Name 2
SOLDTOORGANIZATIONBPNAME2 _SOLDTOPARTY ORGANIZATIONBPNAME2 Name 2
OVERALLPUTAWAYSTATUS OVERALLPUTAWAYSTATUS
OVERALLSDPROCESSSTATUS OVERALLSDPROCESSSTATUS
OVERALLSDPROCESSSTATUSDESC
PICKINGDATE PICKINGDATE
PLANNEDGOODSISSUEDATE PLANNEDGOODSISSUEDATE
PUTAWAYSTATUSNAME
REFERENCESDDOCUMENT _ITEM REFERENCESDDOCUMENT Reference Doc.
REFERENCESDDOCUMENTCATEGORY _ITEM REFERENCESDDOCUMENTCATEGORY Prec.Doc.Categ.
REFERENCESDDOCUMENTITEM _ITEM REFERENCESDDOCUMENTITEM Reference Item
SALESORGANIZATION SALESORGANIZATION Sales Organization
SALESORGANIZATIONNAME
SHIPPINGPOINT SHIPPINGPOINT Shipping Point
SHIPPINGPOINTNAME
SHIPTOPARTY SHIPTOPARTY Ship-To Party (obsolete)
SOLDTOPARTY SOLDTOPARTY Sold-to Party
TRANSPORTATIONPLANNINGDATE TRANSPORTATIONPLANNINGDATE TranspPlngDate
DELIVWEIGHTUOMCOMMERCIALNAME
DELIVVOLUMEUOMCOMMERCIALNAME
USERDESCRIPTION _CREATEDBYUSER USERDESCRIPTION Full Name

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view ESH_N_CUSTOMERRETURNDELIVERY.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ESH_L_CSTRETDLV
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_CUSTOMERRETURNDELIVERY AS
SELECT
  CUSTOMERRETURNDELIVERY,
  ACTUALGOODSMOVEMENTDATE,
  CREATEDBYUSER,
  CREATIONDATE,
  DELIVERYDATE,
  DELIVERYDOCUMENTBYSUPPLIER,
  _ITEM.DELIVERYDOCUMENTITEMTEXT AS DELIVERYDOCUMENTITEMTEXT,
  DELIVERYDOCUMENTTYPE,
  _DELIVERYDOCUMENTTYPE._TEXT[1: Language = $parameters. P_Language].DELIVERYDOCUMENTTYPENAME AS DELIVERYDOCUMENTTYPENAME,
  DELIVERYPRIORITY,
  _DELIVERYPRIORITY._TEXT._DELIVERYPRIORITY._TEXT[1: Language = $parameters. P_Language].DELIVERYPRIORITYDESC AS DELIVERYPRIORITYDESC,
  HEADERGROSSWEIGHT,
  HEADERNETWEIGHT,
  HEADERVOLUME,
  HEADERVOLUMEUNIT,
  HEADERWEIGHTUNIT,
  LOADINGDATE,
  _ITEM.MATERIAL AS MATERIAL,
  _MATERIALDOCUMENTHEADER.MATERIALDOCUMENT AS MATERIALDOCUMENT,
  _MATERIALDOCUMENTHEADER.MATERIALDOCUMENTYEAR AS MATERIALDOCUMENTYEAR,
  _SHIPTOPARTY.ORGANIZATIONBPNAME1 AS SHIPTOORGANIZATIONBPNAME1,
  _SOLDTOPARTY.ORGANIZATIONBPNAME1 AS SOLDTOORGANIZATIONBPNAME1,
  _SHIPTOPARTY.ORGANIZATIONBPNAME2 AS SHIPTOORGANIZATIONBPNAME2,
  _SOLDTOPARTY.ORGANIZATIONBPNAME2 AS SOLDTOORGANIZATIONBPNAME2,
  OVERALLPUTAWAYSTATUS,
  OVERALLSDPROCESSSTATUS,
  _OVERALLSDPROCESSSTATUS[1: LANGUAGE = $parameters. P_Language].OVERALLSDPROCESSSTATUSDESC AS OVERALLSDPROCESSSTATUSDESC,
  PICKINGDATE,
  PLANNEDGOODSISSUEDATE,
  _OVERALLPUTAWAYSTATUS[1: ddlanguage = $parameters. P_Language].ddtext AS PUTAWAYSTATUSNAME,
  _ITEM.REFERENCESDDOCUMENT AS REFERENCESDDOCUMENT,
  _ITEM.REFERENCESDDOCUMENTCATEGORY AS REFERENCESDDOCUMENTCATEGORY,
  _ITEM.REFERENCESDDOCUMENTITEM AS REFERENCESDDOCUMENTITEM,
  SALESORGANIZATION,
  _SALESORGANIZATION._TEXT[1: Language = $parameters. P_Language].SALESORGANIZATIONNAME AS SALESORGANIZATIONNAME,
  SHIPPINGPOINT,
  _SHIPPINGPOINT._TEXT[1: Language = $parameters. P_Language].SHIPPINGPOINTNAME AS SHIPPINGPOINTNAME,
  SHIPTOPARTY,
  SOLDTOPARTY,
  TRANSPORTATIONPLANNINGDATE,
  _HEADERWEIGHTUNIT._TEXT[1: LANGUAGE = $parameters. P_Language].UNITOFMEASURECOMMERCIALNAME AS DELIVWEIGHTUOMCOMMERCIALNAME,
  _HEADERVOLUMEUNIT._TEXT[1: LANGUAGE = $parameters. P_Language].UNITOFMEASURECOMMERCIALNAME AS DELIVVOLUMEUOMCOMMERCIALNAME,
  _CREATEDBYUSER.USERDESCRIPTION AS USERDESCRIPTION
FROM I_CUSTOMERRETURNDELIVERY
LEFT OUTER JOIN N_OVERALLSDPROCESSSTATUS AS _OVERALLSDPROCESSSTATUS ON OverallSDProcessStatus=_OVERALLSDPROCESSSTATUS.OverallSDProcessStatus  -- association [0..1]
LEFT OUTER JOIN dd07t AS _OVERALLPUTAWAYSTATUS ON OverallPutawayStatus=_OVERALLPUTAWAYSTATUS.domvalue_l AND _OVERALLPUTAWAYSTATUS.domname='LE_PUTAWAY_STATUS' AND _OVERALLPUTAWAYSTATUS.as4local='A'  -- association [0..*]
;

Learn More