C_ESJIOutboundDeliveryQuery

DDL: C_ESJIOUTBOUNDDELIVERYQUERY SQL: CESJILEOUTBDELIV Type: view CONSUMPTION
60 Fields 1 Data Sources

Outbound Deliveries

C_ESJIOutboundDeliveryQuery is a Consumption CDS View that provides data about "Outbound Deliveries" in SAP S/4HANA. It reads from 1 data source (I_OutboundDelivery) and exposes 60 fields with key field OutboundDelivery.

Data Sources (1)

SourceAliasJoin Type
I_OutboundDelivery I_OutboundDelivery from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName CESJILEOUTBDELIV view
EndUserText.label Outbound Deliveries view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY OutboundDelivery OutboundDelivery LE Delivery
ObjectType
DeliveryDocumentType DeliveryDocumentType Delivery Type
DeliveryDocumentTypeName
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
ShippingPoint ShippingPoint Shipping Point
ShippingPointName
StorageType
DeliveryBlockReason DeliveryBlockReason Delivery Block
DeliveryBlockReasonText
PickingDate PickingDate
PickingTime PickingTime
LoadingDate LoadingDate Loading Date
LoadingTime LoadingTime Loading Time
ShipToParty ShipToParty Ship-To Party (obsolete)
ShipToPartyName _ShipToParty CustomerName Name of Customer
ShippingType ShippingType Shipping Type
DeliveryDate DeliveryDate Delivery Date
DeliveryTime DeliveryTime TimeOfDelivery
TransportationPlanningDate TransportationPlanningDate TranspPlngDate
TransportationPlanningTime TransportationPlanningTime Tr. Plan. Time
PlannedGoodsIssueDate PlannedGoodsIssueDate
GoodsIssueTime GoodsIssueTime GI Time
ActualGoodsMovementDate ActualGoodsMovementDate
ActualGoodsMovementTime ActualGoodsMovementTime
IncotermsClassification IncotermsClassification Incoterms
IncotermsClassificationName
BillingDocumentDate BillingDocumentDate Billing Date
HeaderBillingBlockReason HeaderBillingBlockReason Billing Block
BillingBlockReasonDescription
SoldToParty SoldToParty Sold-to Party
OverallSDProcessStatus OverallSDProcessStatus
OverallPickingConfStatus OverallPickingConfStatus
OverallPickingStatus OverallPickingStatus
OverallGoodsMovementStatus OverallGoodsMovementStatus
TotalBlockStatus TotalBlockStatus
OverallDelivConfStatus OverallDelivConfStatus
OverallDelivReltdBillgStatus OverallDelivReltdBillgStatus
TotalCreditCheckStatus TotalCreditCheckStatus
TransportationPlanningStatus TransportationPlanningStatus
OverallWarehouseActivityStatus OverallWarehouseActivityStatus
OverallPackingStatus OverallPackingStatus
Warehouse Warehouse Warehouse No.
WarehouseName
_ESJIOtbndDlvryItemQuery _ESJIOtbndDlvryItemQuery
_Partner _Partner
_DeliveryDocumentType _DeliveryDocumentType
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_ShippingPoint _ShippingPoint
_DeliveryBlockReason _DeliveryBlockReason
_ShipToParty _ShipToParty
_ShippingType _ShippingType
_IncotermsClassification _IncotermsClassification
_HeaderBillingBlockReason _HeaderBillingBlockReason
_SoldToParty _SoldToParty

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 C_ESJIOutboundDeliveryQuery.
-- 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: CESJILEOUTBDELIV
-- Parameters: P_Language : sylangu

CREATE VIEW C_ESJIOutboundDeliveryQuery AS
SELECT
  OutboundDelivery,
  'LIKP' AS ObjectType,
  DeliveryDocumentType,
  _DeliveryDocumentType._Text[1:Language = $parameters.P_Language ].DeliveryDocumentTypeName AS DeliveryDocumentTypeName,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  ShippingPoint,
  _ShippingPoint._Text[1: Language = $parameters.P_Language].ShippingPointName AS ShippingPointName,
  '' AS StorageType,
  DeliveryBlockReason,
  _DeliveryBlockReason._Text[1: Language = $parameters.P_Language].DeliveryBlockReasonText AS DeliveryBlockReasonText,
  PickingDate,
  PickingTime,
  LoadingDate,
  LoadingTime,
  ShipToParty,
  _ShipToParty.CustomerName AS ShipToPartyName,
  ShippingType,
  DeliveryDate,
  DeliveryTime,
  TransportationPlanningDate,
  TransportationPlanningTime,
  PlannedGoodsIssueDate,
  GoodsIssueTime,
  ActualGoodsMovementDate,
  ActualGoodsMovementTime,
  IncotermsClassification,
  _IncotermsClassification._Text[1: Language = $parameters.P_Language].IncotermsClassificationName AS IncotermsClassificationName,
  BillingDocumentDate,
  HeaderBillingBlockReason,
  _HeaderBillingBlockReason._Text[1: Language = $parameters.P_Language].BillingBlockReasonDescription AS BillingBlockReasonDescription,
  SoldToParty,
  OverallSDProcessStatus,
  OverallPickingConfStatus,
  OverallPickingStatus,
  OverallGoodsMovementStatus,
  TotalBlockStatus,
  OverallDelivConfStatus,
  OverallDelivReltdBillgStatus,
  TotalCreditCheckStatus,
  TransportationPlanningStatus,
  OverallWarehouseActivityStatus,
  OverallPackingStatus,
  Warehouse,
  _Warehouse._Text[1: Language = $parameters.P_Language].WarehouseName AS WarehouseName
FROM I_OutboundDelivery
;

Learn More