I_FldLogsReturnHandlingUnit

DDL: I_FLDLOGSRETURNHANDLINGUNIT SQL: IFLRETHU Type: view COMPOSITE Package: FLOG_RETURN
31 Fields 2 Data Sources 1 Associations

Field logistics Return handling units

I_FldLogsReturnHandlingUnit is a Composite CDS View that provides data about "Field logistics Return handling units" in SAP S/4HANA. It reads from 2 data sources (I_FldLogsReturnItem, I_FldLogsReturnItem) and exposes 31 fields with key fields Material, FldLogsRemotePlant, RemoteStorageLocation, FldLogsReferenceDocumentNumber, ReferenceDocumentItem. It has 1 association to related views. Part of development package FLOG_RETURN.

Data Sources (2)

SourceAliasJoin Type
I_FldLogsReturnItem _FldLogsReturnItem union_all
I_FldLogsReturnItem _ReturnItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FldLogsSuplrItmEWMHndlgUnt _LeHUToEWMHU $projection.HandlingUnitExternalID = _LeHUToEWMHU.IntrLogsOpHandlingUnitAltvIdn

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IFLRETHU view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.dataMaintenance #RESTRICTED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Field logistics Return handling units view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY Material I_FldLogsReturnItem Material Vehicle Model
KEY FldLogsRemotePlant I_FldLogsReturnItem FldLogsRemotePlant Plant
KEY RemoteStorageLocation I_FldLogsReturnItem RemoteStorageLocation
KEY FldLogsReferenceDocumentNumber I_FldLogsReturnItem FldLogsReferenceDocumentNumber Reference Doc Number
KEY ReferenceDocumentItem I_FldLogsReturnItem ReferenceDocumentItem Reference item
KEY FldLogsMaintenanceOrder I_FldLogsReturnItem FldLogsMaintenanceOrder
KEY HandlingUnitExternalID _HandlingUnitHistory HandlingUnitExternalID
DeliveryDocument I_FldLogsReturnItem OutboundDelivery LE Delivery
HandlingUnitLowerLevelRefer _HandlingUnitHistory HandlingUnitLowerLevelRefer
Product _HandlingUnitHistory PackagingMaterial Packaging Materials
HandlingUnitQuantity _HandlingUnitHistory HandlingUnitQuantity Packed Quantity
HandlingUnitQuantityUnit _HandlingUnitHistory HandlingUnitQuantityUnit UoM of HU item
HandlingUnitNumber Handling Unit
HandlingUnitInternalID _HandlingUnitHistory HandlingUnitInternalID
HandlingUnitNestedInternalID _HandlingUnitHistory HandlingUnitNestedInternalID
Material Vehicle Model
KEY FldLogsRemotePlant I_FldLogsReturnItem FldLogsRemotePlant Plant
KEY RemoteStorageLocation I_FldLogsReturnItem RemoteStorageLocation
KEY FldLogsReferenceDocumentNumber I_FldLogsReturnItem FldLogsReferenceDocumentNumber Reference Doc Number
KEY ReferenceDocumentItem I_FldLogsReturnItem ReferenceDocumentItem Reference item
KEY FldLogsMaintenanceOrder I_FldLogsReturnItem FldLogsMaintenanceOrder
KEY HandlingUnitExternalID _LeHUToEWMHU HandlingUnitNumber
DeliveryDocument I_FldLogsReturnItem OutboundDelivery LE Delivery
HandlingUnitLowerLevelRefer _HandlingUnitHistory HandlingUnitLowerLevelRefer
Product _HandlingUnitHistory PackagingMaterial Packaging Materials
HandlingUnitQuantity _HandlingUnitHistory HandlingUnitQuantity Packed Quantity
HandlingUnitQuantityUnit _HandlingUnitHistory HandlingUnitQuantityUnit UoM of HU item
HandlingUnitNumber _HandlingUnitHistory HandlingUnitExternalID Handling Unit
HandlingUnitInternalID _HandlingUnitHistory HandlingUnitInternalID
HandlingUnitNestedInternalID _HandlingUnitHistory HandlingUnitNestedInternalID
EWMWarehouse I_FldLogsReturnItem EWMWarehouse Warehouse No.

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_FldLogsReturnHandlingUnit.
-- 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.
-- SQL view name: IFLRETHU

CREATE VIEW I_FldLogsReturnHandlingUnit AS
SELECT
  _ReturnItem.Material AS Material,
  _ReturnItem.FldLogsRemotePlant AS FldLogsRemotePlant,
  _ReturnItem.RemoteStorageLocation AS RemoteStorageLocation,
  _ReturnItem.FldLogsReferenceDocumentNumber AS FldLogsReferenceDocumentNumber,
  _ReturnItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  _ReturnItem.FldLogsMaintenanceOrder AS FldLogsMaintenanceOrder,
  _HandlingUnitHistory.HandlingUnitExternalID AS HandlingUnitExternalID,
  _ReturnItem.OutboundDelivery AS DeliveryDocument,
  _HandlingUnitHistory.HandlingUnitLowerLevelRefer AS HandlingUnitLowerLevelRefer,
  _HandlingUnitHistory.PackagingMaterial AS Product,
  _HandlingUnitHistory.HandlingUnitQuantity AS HandlingUnitQuantity,
  _HandlingUnitHistory.HandlingUnitQuantityUnit AS HandlingUnitQuantityUnit,
  ' ' AS HandlingUnitNumber,
  _HandlingUnitHistory.HandlingUnitInternalID AS HandlingUnitInternalID,
  _HandlingUnitHistory.HandlingUnitNestedInternalID AS HandlingUnitNestedInternalID,
  _FldLogsReturnItem.EWMWarehouse AS EWMWarehouse
FROM I_FldLogsReturnItem AS _ReturnItem
LEFT OUTER JOIN I_FldLogsSuplrItmEWMHndlgUnt AS _LeHUToEWMHU ON HandlingUnitExternalID = _LeHUToEWMHU.IntrLogsOpHandlingUnitAltvIdn  -- association [0..1]
-- UNION ALL with additional select branch(es): I_FldLogsReturnItem
;

Learn More