I_FldLogsRcvdItmWarehouseTask

DDL: I_FLDLOGSRCVDITMWAREHOUSETASK Type: view_entity COMPOSITE
8 Fields 1 Data Sources 1 Associations

FL Received Item Warehouse task

I_FldLogsRcvdItmWarehouseTask is a Composite CDS View that provides data about "FL Received Item Warehouse task" in SAP S/4HANA. It reads from 1 data source (I_FldLogsRcvdItmEWMOutbDeliv) and exposes 8 fields with key fields EWMWarehouse, WarehouseTask, WarehouseTaskItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsRcvdItmEWMOutbDeliv I_FldLogsRcvdItmEWMOutbDeliv from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_EWM_WarehouseTask_2 _WarehouseTask _WarehouseTask.ReferenceDocumentUUID = $projection.DeliveryUUID and _WarehouseTask.ReferenceDocumentItemUUID = $projection.DeliveryItemUUID

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FL Received Item Warehouse task view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY EWMWarehouse EWMWarehouse Warehouse No.
KEY WarehouseTask _WarehouseTask WarehouseTask Warehouse Task
KEY WarehouseTaskItem _WarehouseTask WarehouseTaskItem
WarehouseTaskStatus _WarehouseTask WarehouseTaskStatus
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
DeliveryUUID OutboundDeliveryOrderUUID Document ID
DeliveryItemUUID OutboundDeliveryOrderItemUUID Item ID
EWMReferenceDocumentCategory _WarehouseTask EWMReferenceDocumentCategory

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_FldLogsRcvdItmWarehouseTask.
-- 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_FldLogsRcvdItmWarehouseTask AS
SELECT
  EWMWarehouse,
  _WarehouseTask.WarehouseTask AS WarehouseTask,
  _WarehouseTask.WarehouseTaskItem AS WarehouseTaskItem,
  _WarehouseTask.WarehouseTaskStatus AS WarehouseTaskStatus,
  FldLogsReferenceDocumentNumber,
  OutboundDeliveryOrderUUID AS DeliveryUUID,
  OutboundDeliveryOrderItemUUID AS DeliveryItemUUID,
  _WarehouseTask.EWMReferenceDocumentCategory AS EWMReferenceDocumentCategory
FROM I_FldLogsRcvdItmEWMOutbDeliv
LEFT OUTER JOIN I_EWM_WarehouseTask_2 AS _WarehouseTask ON _WarehouseTask.ReferenceDocumentUUID = DeliveryUUID AND _WarehouseTask.ReferenceDocumentItemUUID = DeliveryItemUUID  -- association [0..1]
;

Learn More