CIC_OUTBOUNDDELIVERYITEM

DDL: CIC_OUTBOUNDDELIVERYITEM Type: view_entity
12 Fields 1 Data Sources 1 Associations

Projection on Outbound Delivery Items

CIC_OUTBOUNDDELIVERYITEM is a CDS View that provides data about "Projection on Outbound Delivery Items" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocumentItem) and exposes 12 fields with key fields DeliveryDocument, DeliveryDocumentItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocumentItem I_DeliveryDocumentItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Batch _Batch $projection.Batch = _Batch.Batch and $projection.Material = _Batch.Material and $projection.Plant = _Batch.Plant and $projection.StockSegment = _Batch.StockSegment and $projection.StockSegment <> ' '

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Projection on Outbound Delivery Items view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument DeliveryDocument Outbound Delivery
KEY DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
DeliveryDocumentItemText DeliveryDocumentItemText Short Text
Material Material Vehicle Model
ActualDeliveryQuantity ActualDeliveryQuantity Base quantity
DeliveryQuantityUnit DeliveryQuantityUnit Unit of measure
ReferenceSDDocument ReferenceSDDocument Reference Doc.
ReferenceSDDocumentItem ReferenceSDDocumentItem Reference Item
Plant Plant Valuation Area
Batch Batch Lot No.
StockSegment StockSegment Stock Segment
CountryOfOrigin _Batch CountryOfOrigin Country/Region of Origin

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 CIC_OUTBOUNDDELIVERYITEM.
-- 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.

CREATE VIEW CIC_OUTBOUNDDELIVERYITEM AS
SELECT
  DeliveryDocument,
  DeliveryDocumentItem,
  DeliveryDocumentItemText,
  Material,
  ActualDeliveryQuantity,
  DeliveryQuantityUnit,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  Plant,
  Batch,
  StockSegment,
  _Batch.CountryOfOrigin AS CountryOfOrigin
FROM I_DeliveryDocumentItem
LEFT OUTER JOIN I_Batch AS _Batch ON Batch = _Batch.Batch AND Material = _Batch.Material AND Plant = _Batch.Plant AND StockSegment = _Batch.StockSegment AND StockSegment <> ' '  -- association [0..1]
;

Learn More