I_FldLogsRcvdOutboundDelivery

DDL: I_FLDLOGSRCVDOUTBOUNDDELIVERY Type: view_entity COMPOSITE

FL Outbound Delivery

I_FldLogsRcvdOutboundDelivery is a Composite CDS View that provides data about "FL Outbound Delivery" in SAP S/4HANA. It reads from 2 data sources (I_DeliveryDocumentItem, I_FieldLogisticsPlantAll) and exposes 15 fields with key fields DeliveryDocument, DeliveryDocumentItem. It has 1 association to related views.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
I_DeliveryDocumentItem _DeliveryDocumentItem from
I_FieldLogisticsPlantAll _FldLogsAllPlants inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchasingDocument _ReferenceSDDocument _ReferenceSDDocument.PurchasingDocument = $projection.ReferenceSDDocument

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FL Outbound Delivery view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument I_DeliveryDocumentItem DeliveryDocument
KEY DeliveryDocumentItem I_DeliveryDocumentItem DeliveryDocumentItem
Warehouse I_DeliveryDocumentItem Warehouse
ReferenceSDDocument I_DeliveryDocumentItem ReferenceSDDocument
ReferenceSDDocumentItem I_DeliveryDocumentItem ReferenceSDDocumentItem
GoodsMovementStatus I_DeliveryDocumentItem GoodsMovementStatus
OrderID I_DeliveryDocumentItem OrderID
OrderItem I_DeliveryDocumentItem OrderItem
Reservation I_DeliveryDocumentItem Reservation
ReservationItem I_DeliveryDocumentItem ReservationItem
Plant I_DeliveryDocumentItem Plant
StorageLocation I_DeliveryDocumentItem StorageLocation
GoodsMovementType I_DeliveryDocumentItem GoodsMovementType
IsEndOfPurposeBlocked _ReferenceSDDocument IsEndOfPurposeBlocked
_DeliveryDocument I_DeliveryDocumentItem _DeliveryDocument 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'FL Outbound Delivery'
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #COMPOSITE
define view entity I_FldLogsRcvdOutboundDelivery
  as select from I_DeliveryDocumentItem   as _DeliveryDocumentItem
    inner join   I_FieldLogisticsPlantAll as _FldLogsAllPlants on _FldLogsAllPlants.Plant = _DeliveryDocumentItem.Plant

  association [1..1] to I_PurchasingDocument as _ReferenceSDDocument on _ReferenceSDDocument.PurchasingDocument = $projection.ReferenceSDDocument
{
  key _DeliveryDocumentItem.DeliveryDocument,
  key _DeliveryDocumentItem.DeliveryDocumentItem,
      _DeliveryDocumentItem.Warehouse,
      _DeliveryDocumentItem.ReferenceSDDocument,
      _DeliveryDocumentItem.ReferenceSDDocumentItem,
      _DeliveryDocumentItem.GoodsMovementStatus,
      _DeliveryDocumentItem.OrderID,
      _DeliveryDocumentItem.OrderItem,
      _DeliveryDocumentItem.Reservation,
      _DeliveryDocumentItem.ReservationItem,
      _DeliveryDocumentItem.Plant,
      _DeliveryDocumentItem.StorageLocation,
      _DeliveryDocumentItem.GoodsMovementType,
      _ReferenceSDDocument.IsEndOfPurposeBlocked,
      //   cast( substring(_DeliveryDocumentItem.ReferenceSDDocumentItem, 2, 6 ) as ebelp ) as PurchasingDocumentItem,



      /*Association*/
      _DeliveryDocumentItem._DeliveryDocument
}

where
  _DeliveryDocumentItem.SDDocumentCategory = 'J'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENTITEM",
"I_FIELDLOGISTICSPLANTALL",
"I_PURCHASINGDOCUMENT"
],
"ASSOCIATED":
[
"I_DELIVERYDOCUMENT"
],
"BASE":
[
"I_DELIVERYDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More