I_FldLogsRcvdInboundDelivery

DDL: I_FLDLOGSRCVDINBOUNDDELIVERY Type: view_entity COMPOSITE
6 Fields 2 Data Sources

FL Received Inbound Delivery

I_FldLogsRcvdInboundDelivery is a Composite CDS View that provides data about "FL Received Inbound Delivery" in SAP S/4HANA. It reads from 2 data sources (I_DeliveryDocumentItem, I_FieldLogisticsPlantAll) and exposes 6 fields with key fields DeliveryDocument, DeliveryDocumentItem.

Data Sources (2)

SourceAliasJoin Type
I_DeliveryDocumentItem _DeliveryDocumentItem from
I_FieldLogisticsPlantAll _FldLogsAllPlants inner

Annotations (6)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument I_DeliveryDocumentItem DeliveryDocument Outbound Delivery
KEY DeliveryDocumentItem I_DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
DeliveryDocumentItemCategory I_DeliveryDocumentItem DeliveryDocumentItemCategory Item Category
Warehouse I_DeliveryDocumentItem Warehouse Warehouse No.
GoodsMovementStatus I_DeliveryDocumentItem GoodsMovementStatus Gds Movemt Status
SDDocumentCategory I_DeliveryDocumentItem SDDocumentCategory Document Cat.

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_FldLogsRcvdInboundDelivery.
-- 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_FldLogsRcvdInboundDelivery AS
SELECT
  _DeliveryDocumentItem.DeliveryDocument AS DeliveryDocument,
  _DeliveryDocumentItem.DeliveryDocumentItem AS DeliveryDocumentItem,
  _DeliveryDocumentItem.DeliveryDocumentItemCategory AS DeliveryDocumentItemCategory,
  _DeliveryDocumentItem.Warehouse AS Warehouse,
  _DeliveryDocumentItem.GoodsMovementStatus AS GoodsMovementStatus,
  _DeliveryDocumentItem.SDDocumentCategory AS SDDocumentCategory
FROM I_DeliveryDocumentItem AS _DeliveryDocumentItem
INNER JOIN I_FieldLogisticsPlantAll AS _FldLogsAllPlants ON /* join condition not captured in parsed metadata */
;

Learn More