C_ESJIOutboundDeliveryQuery

DDL: C_ESJIOUTBOUNDDELIVERYQUERY SQL: CESJILEOUTBDELIV Type: view CONSUMPTION

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.

1 data source(s) 60 fields

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
ObjectType
DeliveryDocumentType DeliveryDocumentType
DeliveryDocumentTypeName
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
ShippingPoint ShippingPoint
ShippingPointName
StorageType
DeliveryBlockReason DeliveryBlockReason
DeliveryBlockReasonText
PickingDate PickingDate
PickingTime PickingTime
LoadingDate LoadingDate
LoadingTime LoadingTime
ShipToParty ShipToParty
ShipToPartyName _ShipToParty CustomerName
ShippingType ShippingType
DeliveryDate DeliveryDate
DeliveryTime DeliveryTime
TransportationPlanningDate TransportationPlanningDate
TransportationPlanningTime TransportationPlanningTime
PlannedGoodsIssueDate PlannedGoodsIssueDate
GoodsIssueTime GoodsIssueTime
ActualGoodsMovementDate ActualGoodsMovementDate
ActualGoodsMovementTime ActualGoodsMovementTime
IncotermsClassification IncotermsClassification
IncotermsClassificationName
BillingDocumentDate BillingDocumentDate
HeaderBillingBlockReason HeaderBillingBlockReason
BillingBlockReasonDescription
SoldToParty SoldToParty
OverallSDProcessStatus OverallSDProcessStatus
OverallPickingConfStatus OverallPickingConfStatus
OverallPickingStatus OverallPickingStatus
OverallGoodsMovementStatus OverallGoodsMovementStatus
TotalBlockStatus TotalBlockStatus
OverallDelivConfStatus OverallDelivConfStatus
OverallDelivReltdBillgStatus OverallDelivReltdBillgStatus
TotalCreditCheckStatus TotalCreditCheckStatus
TransportationPlanningStatus TransportationPlanningStatus
OverallWarehouseActivityStatus OverallWarehouseActivityStatus
OverallPackingStatus OverallPackingStatus
Warehouse Warehouse
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 
@AbapCatalog.sqlViewName: 'CESJILEOUTBDELIV'
@EndUserText.label: 'Outbound Deliveries'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view C_ESJIOutboundDeliveryQuery
with parameters P_Language : sylangu
as select from I_OutboundDelivery
//Associations

association[0..*] to C_ESJIOtbndDlvryItemQuery as _ESJIOtbndDlvryItemQuery on $projection.OutboundDelivery = _ESJIOtbndDlvryItemQuery.OutboundDelivery
{
//key  

   key OutboundDelivery,
   'LIKP' as ObjectType,
//category

   DeliveryDocumentType,
   _DeliveryDocumentType._Text[1:Language = $parameters.P_Language ].DeliveryDocumentTypeName,
   //SDDocumentCategory,

//admin

   CreatedByUser,
   @Semantics.businessDate.createdAt: true
   CreationDate,
   CreationTime,
   LastChangedByUser,
   @Semantics.businessDate.lastChangedAt: true
   LastChangeDate,
//organization

   ShippingPoint,
   _ShippingPoint._Text[1: Language = $parameters.P_Language].ShippingPointName,
      '' as StorageType,
//delivery

   DeliveryBlockReason,
   _DeliveryBlockReason._Text[1: Language = $parameters.P_Language].DeliveryBlockReasonText,
//pick pack load

   PickingDate,
   PickingTime,
   LoadingDate,
   LoadingTime,
//shipping

   ShipToParty,
   _ShipToParty.CustomerName as ShipToPartyName,
   ShippingType,
   DeliveryDate,
   DeliveryTime,
   TransportationPlanningDate,
   TransportationPlanningTime,
   PlannedGoodsIssueDate,
   GoodsIssueTime,
   ActualGoodsMovementDate,
   ActualGoodsMovementTime,
   IncotermsClassification,
   _IncotermsClassification._Text[1: Language = $parameters.P_Language].IncotermsClassificationName,
//billing

   BillingDocumentDate,
   HeaderBillingBlockReason,
   _HeaderBillingBlockReason._Text[1: Language = $parameters.P_Language].BillingBlockReasonDescription,
//sales

   SoldToParty,
//status

   OverallSDProcessStatus,
   OverallPickingConfStatus,
   OverallPickingStatus,
   OverallGoodsMovementStatus,
   TotalBlockStatus,
   OverallDelivConfStatus,
   OverallDelivReltdBillgStatus,
   TotalCreditCheckStatus,
   TransportationPlanningStatus,
   OverallWarehouseActivityStatus,
   OverallPackingStatus,
   Warehouse,
   _Warehouse._Text[1: Language = $parameters.P_Language].WarehouseName,
//   Associations

    _ESJIOtbndDlvryItemQuery,
    _Partner,
//Category

    _DeliveryDocumentType,
//Admin

    _CreatedByUser,
    _LastChangedByUser,
//Organization

    _ShippingPoint,
//Delivery

    _DeliveryBlockReason,
//Shipping

    _ShipToParty,
    _ShippingType,
    _IncotermsClassification,
//Billing

    _HeaderBillingBlockReason,
//Sales

    _SoldToParty
//Status

//    _OverallSDProcessStatus,

//    _OverallPickingConfStatus,

//    _OverallPickingStatus,

//    _OverallGoodsMovementStatus,

//    _TotalBlockStatus,

//    _SDDocStandardPartner

//    _OverallDelivConfStatus,

//    _OverallDelivReltdBillgStatus

}

Learn More