I_FldLogsRcvdItmInbDelivery

DDL: I_FLDLOGSRCVDITMINBDELIVERY Type: view_entity COMPOSITE Package: FLOG_RETURN_PROCG_BASE
20 Fields 1 Data Sources 1 Associations

FL Received Item Inbound Delivery

I_FldLogsRcvdItmInbDelivery is a Composite CDS View that provides data about "FL Received Item Inbound Delivery" in SAP S/4HANA. It reads from 1 data source (I_FldLogsRetCtnItemEnhanced) and exposes 20 fields with key fields InboundDelivery, InboundDeliveryItem, FieldLogisticsReceivingPlant. It has 1 association to related views. Part of development package FLOG_RETURN_PROCG_BASE.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsRetCtnItemEnhanced I_FldLogsRetCtnItemEnhanced from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FldLogsRcvdInboundDelivery _InboundDelivery _InboundDelivery.DeliveryDocument = $projection.InboundDelivery and _InboundDelivery.DeliveryDocumentItem = $projection.InboundDeliveryItem

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FL Received Item Inbound Delivery view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY InboundDelivery InboundDelivery LE Delivery
KEY InboundDeliveryItem InboundDeliveryItem Item
KEY FieldLogisticsReceivingPlant FieldLogisticsReceivingPlant
GoodsMovementStatus _InboundDelivery GoodsMovementStatus Gds Movemt Status
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
EWMDelivery LE Delivery
EWMDeliveryItem
WarehouseTask WarehouseTask Warehouse Task
PurchasingDocument PurchasingDocument Purchasing Document
StockTransportOrder StockTransportOrder STO Number
FldLogsRetServicePurOrd FldLogsRetServicePurOrd
FldLogsSubcontractingPO FldLogsSubcontractingPO Purchasing Doc.
OutboundDelivery OutboundDelivery LE Delivery
OutboundDeliveryItem OutboundDeliveryItem Logistics Execution Delivery Item
SDDocumentCategory _InboundDelivery SDDocumentCategory Document Cat.
MaterialDocument MaterialDocument Material Doc.
MaterialDocumentItem MaterialDocumentItem Material Document Item
MaterialDocumentYear MaterialDocumentYear Material Document Year
_OutboundDelivery _OutboundDelivery
_InboundDelivery _InboundDelivery

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 I_FldLogsRcvdItmInbDelivery.
-- 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 I_FldLogsRcvdItmInbDelivery AS
SELECT
  InboundDelivery,
  InboundDeliveryItem,
  FieldLogisticsReceivingPlant,
  _InboundDelivery.GoodsMovementStatus AS GoodsMovementStatus,
  FldLogsReferenceDocumentNumber,
  cast( InboundDelivery as /scdl/dl_docno_int ) AS EWMDelivery,
  cast( lpad( InboundDeliveryItem,10,'0') as /scdl/dl_itemno) AS EWMDeliveryItem,
  WarehouseTask,
  PurchasingDocument,
  StockTransportOrder,
  FldLogsRetServicePurOrd,
  FldLogsSubcontractingPO,
  OutboundDelivery,
  OutboundDeliveryItem,
  _InboundDelivery.SDDocumentCategory AS SDDocumentCategory,
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentYear
FROM I_FldLogsRetCtnItemEnhanced
LEFT OUTER JOIN I_FldLogsRcvdInboundDelivery AS _InboundDelivery ON _InboundDelivery.DeliveryDocument = InboundDelivery AND _InboundDelivery.DeliveryDocumentItem = InboundDeliveryItem  -- association [0..1]
;

Learn More