ESH_N_OUTBOUNDDELIVERY

DDL: ESH_N_OUTBOUNDDELIVERY SQL: ESH_L_OUTBDELIV Type: view Package: VDM_LE_SHP_OBD_ESH
39 Fields 1 Data Sources 2 Associations

Anchor view -OUTBOUNDDELIVERY

ESH_N_OUTBOUNDDELIVERY is a CDS View that provides data about "Anchor view -OUTBOUNDDELIVERY" in SAP S/4HANA. It reads from 1 data source (I_OUTBOUNDDELIVERY) and exposes 39 fields with key field OUTBOUNDDELIVERY. It has 2 associations to related views. Part of development package VDM_LE_SHP_OBD_ESH.

Data Sources (1)

SourceAliasJoin Type
I_OUTBOUNDDELIVERY I_OUTBOUNDDELIVERY from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (2)

CardinalityTargetAliasCondition
[0..1] N_OVERALLPICKINGSTATUS _OVERALLPICKINGSTATUS $projection.OverallPickingStatus=_OVERALLPICKINGSTATUS.OverallPickingStatus
[0..1] N_OVERALLSDPROCESSSTATUS _OVERALLSDPROCESSSTATUS $projection.OverallSDProcessStatus=_OVERALLSDPROCESSSTATUS.OverallSDProcessStatus

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_OUTBDELIV view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY OUTBOUNDDELIVERY OUTBOUNDDELIVERY LE Delivery
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
DOCUMENTDATE DOCUMENTDATE Journal Entry Date
HEADERGROSSWEIGHT HEADERGROSSWEIGHT
HEADERNETWEIGHT HEADERNETWEIGHT
HEADERVOLUME HEADERVOLUME
HEADERVOLUMEUNIT HEADERVOLUMEUNIT
HEADERWEIGHTUNIT HEADERWEIGHTUNIT
MATERIAL _ITEM MATERIAL Vehicle Model
SOLDTOORGANIZATIONBPNAME1 _SOLDTOPARTY ORGANIZATIONBPNAME1 Name 1
SHIPTOORGANIZATIONBPNAME1 _SHIPTOPARTY ORGANIZATIONBPNAME1 Name 1
SOLDTOORGANIZATIONBPNAME2 _SOLDTOPARTY ORGANIZATIONBPNAME2 Name 2
SHIPTOORGANIZATIONBPNAME2 _SHIPTOPARTY ORGANIZATIONBPNAME2 Name 2
OVERALLPICKINGSTATUS OVERALLPICKINGSTATUS
OVERALLPICKINGSTATUSDESC
OVERALLSDPROCESSSTATUS OVERALLSDPROCESSSTATUS
OVERALLSDPROCESSSTATUSDESC
PICKINGDATE PICKINGDATE
PLANNEDGOODSISSUEDATE PLANNEDGOODSISSUEDATE
PROPOSEDDELIVERYROUTE PROPOSEDDELIVERYROUTE
REFERENCESDDOCUMENT _ITEM REFERENCESDDOCUMENT Reference Doc.
SHIPPINGCONDITIONNAME
SHIPPINGPOINT SHIPPINGPOINT Shipping Point
SHIPPINGPOINTNAME
SHIPTOPARTY SHIPTOPARTY Ship-To Party (obsolete)
SOLDTOPARTY SOLDTOPARTY Sold-to Party
TRANSPORTATIONPLANNINGDATE TRANSPORTATIONPLANNINGDATE TranspPlngDate
DELIVVOLUMEUOMCOMMERCIALNAME
DELIVWEIGHTUOMCOMMERCIALNAME
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_OUTBOUNDDELIVERY.
-- 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_OUTBDELIV
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_OUTBOUNDDELIVERY AS
SELECT
  OUTBOUNDDELIVERY,
  ACTUALGOODSMOVEMENTDATE,
  CREATEDBYUSER,
  CREATIONDATE,
  DELIVERYDATE,
  DELIVERYDOCUMENTBYSUPPLIER,
  _ITEM.DELIVERYDOCUMENTITEMTEXT AS DELIVERYDOCUMENTITEMTEXT,
  DELIVERYDOCUMENTTYPE,
  _DELIVERYDOCUMENTTYPE._TEXT[1: Language = $parameters. P_Language].DELIVERYDOCUMENTTYPENAME AS DELIVERYDOCUMENTTYPENAME,
  DELIVERYPRIORITY,
  _DELIVERYPRIORITY._TEXT[1: Language = $parameters. P_Language].DELIVERYPRIORITYDESC AS DELIVERYPRIORITYDESC,
  DOCUMENTDATE,
  HEADERGROSSWEIGHT,
  HEADERNETWEIGHT,
  HEADERVOLUME,
  HEADERVOLUMEUNIT,
  HEADERWEIGHTUNIT,
  _ITEM.MATERIAL AS MATERIAL,
  _SOLDTOPARTY.ORGANIZATIONBPNAME1 AS SOLDTOORGANIZATIONBPNAME1,
  _SHIPTOPARTY.ORGANIZATIONBPNAME1 AS SHIPTOORGANIZATIONBPNAME1,
  _SOLDTOPARTY.ORGANIZATIONBPNAME2 AS SOLDTOORGANIZATIONBPNAME2,
  _SHIPTOPARTY.ORGANIZATIONBPNAME2 AS SHIPTOORGANIZATIONBPNAME2,
  OVERALLPICKINGSTATUS,
  _OVERALLPICKINGSTATUS[1: LANGUAGE = $parameters. P_Language].OVERALLPICKINGSTATUSDESC AS OVERALLPICKINGSTATUSDESC,
  OVERALLSDPROCESSSTATUS,
  _OVERALLSDPROCESSSTATUS[1: LANGUAGE = $parameters. P_Language].OVERALLSDPROCESSSTATUSDESC AS OVERALLSDPROCESSSTATUSDESC,
  PICKINGDATE,
  PLANNEDGOODSISSUEDATE,
  PROPOSEDDELIVERYROUTE,
  _ITEM.REFERENCESDDOCUMENT AS REFERENCESDDOCUMENT,
  _SHIPPINGCONDITION._TEXT[1: Language = $parameters. P_Language].SHIPPINGCONDITIONNAME AS SHIPPINGCONDITIONNAME,
  SHIPPINGPOINT,
  _SHIPPINGPOINT._TEXT[1: Language = $parameters. P_Language].SHIPPINGPOINTNAME AS SHIPPINGPOINTNAME,
  SHIPTOPARTY,
  SOLDTOPARTY,
  TRANSPORTATIONPLANNINGDATE,
  _HEADERVOLUMEUNIT._TEXT[1: LANGUAGE = $parameters. P_Language].UNITOFMEASURECOMMERCIALNAME AS DELIVVOLUMEUOMCOMMERCIALNAME,
  _HEADERWEIGHTUNIT._TEXT[1: LANGUAGE = $parameters. P_Language].UNITOFMEASURECOMMERCIALNAME AS DELIVWEIGHTUOMCOMMERCIALNAME,
  _CREATEDBYUSER.USERDESCRIPTION AS USERDESCRIPTION
FROM I_OUTBOUNDDELIVERY
LEFT OUTER JOIN N_OVERALLPICKINGSTATUS AS _OVERALLPICKINGSTATUS ON OverallPickingStatus=_OVERALLPICKINGSTATUS.OverallPickingStatus  -- association [0..1]
LEFT OUTER JOIN N_OVERALLSDPROCESSSTATUS AS _OVERALLSDPROCESSSTATUS ON OverallSDProcessStatus=_OVERALLSDPROCESSSTATUS.OverallSDProcessStatus  -- association [0..1]
;

Learn More