I_FldLogsRetHndlgUnitHistory

DDL: I_FLDLOGSRETHNDLGUNITHISTORY Type: view_entity BASIC Package: FLOG_RETURN
11 Fields 1 Data Sources

FL Returns LE OBD Handling Unit History

I_FldLogsRetHndlgUnitHistory is a Basic CDS View that provides data about "FL Returns LE OBD Handling Unit History" in SAP S/4HANA. It reads from 1 data source (I_HandlingUnitHeader) and exposes 11 fields with key fields HandlingUnitInternalID, HandlingUnitItem, HandlingUnitObjectKeyType, HandlingUnitObjectKey, HandlingUnitRefDocumentItem. Part of development package FLOG_RETURN.

Data Sources (1)

SourceAliasJoin Type
I_HandlingUnitHeader I_HandlingUnitHeader from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label FL Returns LE OBD Handling Unit History view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitInternalID I_HandlingUnitHeader HandlingUnitInternalID Internal HU no.
KEY HandlingUnitItem _Item HandlingUnitItem
KEY HandlingUnitObjectKeyType _HandlingUnitHistory HandlingUnitObjectKeyType
KEY HandlingUnitObjectKey _HandlingUnitHistory HandlingUnitObjectKey
KEY HandlingUnitRefDocumentItem _Item HandlingUnitRefDocumentItem
HandlingUnitExternalID HandlingUnitExternalID Handling Unit
HandlingUnitLowerLevelRefer HandlingUnitLowerLevelRefer Higher-level HU
PackagingMaterial PackagingMaterial Packaging Materials
HandlingUnitQuantity _Item HandlingUnitQuantity Packed Quantity
HandlingUnitQuantityUnit _Item HandlingUnitQuantityUnit UoM of HU item
HandlingUnitNestedInternalID _Item HandlingUnitNestedInternalID

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_FldLogsRetHndlgUnitHistory.
-- 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_FldLogsRetHndlgUnitHistory AS
SELECT
  I_HandlingUnitHeader.HandlingUnitInternalID AS HandlingUnitInternalID,
  _Item.HandlingUnitItem AS HandlingUnitItem,
  _HandlingUnitHistory.HandlingUnitObjectKeyType AS HandlingUnitObjectKeyType,
  _HandlingUnitHistory.HandlingUnitObjectKey AS HandlingUnitObjectKey,
  _Item.HandlingUnitRefDocumentItem AS HandlingUnitRefDocumentItem,
  HandlingUnitExternalID,
  HandlingUnitLowerLevelRefer,
  PackagingMaterial,
  _Item.HandlingUnitQuantity AS HandlingUnitQuantity,
  _Item.HandlingUnitQuantityUnit AS HandlingUnitQuantityUnit,
  _Item.HandlingUnitNestedInternalID AS HandlingUnitNestedInternalID
FROM I_HandlingUnitHeader
;

Learn More