I_FldLogsShptHandlingUnitItem

DDL: I_FLDLOGSSHPTHANDLINGUNITITEM Type: view_entity COMPOSITE
24 Fields 2 Data Sources 1 Associations

Pack Container Handling Unit Items

I_FldLogsShptHandlingUnitItem is a Composite CDS View that provides data about "Pack Container Handling Unit Items" in SAP S/4HANA. It reads from 2 data sources (I_FldLogsShptHndlgUnitHdrItm, I_HandlingUnitHeaderCombined) and exposes 24 fields with key fields HandlingUnitExternalID, Warehouse, StockItemUUID, Warehouse, StockItemUUID. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_FldLogsShptHndlgUnitHdrItm I_FldLogsShptHndlgUnitHdrItm from
I_HandlingUnitHeaderCombined I_HandlingUnitHeaderCombined union

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_DeliveryDocumentItem _Item $projection.HandlingUnitReferenceDocument = _Item.DeliveryDocument and $projection.HandlingUnitRefDocumentItem = _Item.DeliveryDocumentItem

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Pack Container Handling Unit Items view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.typeName Product view
UI.headerInfo.typeNamePlural Products view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitExternalID HandlingUnitExternalID Handling Unit
KEY Warehouse Warehouse No.
KEY StockItemUUID StockItemUUID
ParentHandlingUnitNumber HandlingUnitExternalID Handling Unit
DeliveryDocumentItemTextendasMaterial
MaterialName MaterialName Handling Unit
PackagingMaterial PackagingMaterial Packaging Materials
HandlingUnitQuantity HandlingUnitQuantity
HandlingUnitQuantityUnit HandlingUnitQuantityUnit UoM of HU item
HandlingUnitReferenceDocument HandlingUnitReferenceDocument
HandlingUnitRefDocumentItem HandlingUnitRefDocumentItem
Plant Plant Valuation Area
KEY Warehouse Warehouse No.
KEY StockItemUUID
ParentHandlingUnitNumber ParentHandlingUnitNumber Handling Unit
Material
MaterialName Handling Unit
PackagingMaterial PackagingMaterial Packaging Materials
HandlingUnitQuantity
HandlingUnitQuantityUnit UoM of HU item
HandlingUnitReferenceDocument
HandlingUnitRefDocumentItem
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation

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_FldLogsShptHandlingUnitItem.
-- 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_FldLogsShptHandlingUnitItem AS
SELECT
  HandlingUnitExternalID,
  cast(Warehouse as lgnum) AS Warehouse,
  StockItemUUID,
  HandlingUnitExternalID AS ParentHandlingUnitNumber,
  case when Material <> '' then Material else _Item.DeliveryDocumentItemText end as Material AS DeliveryDocumentItemTextendasMaterial,
  MaterialName,
  PackagingMaterial,
  HandlingUnitQuantity,
  HandlingUnitQuantityUnit,
  HandlingUnitReferenceDocument,
  HandlingUnitRefDocumentItem,
  Plant,
  cast(' ' as matnr) AS Material,
  StorageLocation
FROM I_FldLogsShptHndlgUnitHdrItm
LEFT OUTER JOIN I_DeliveryDocumentItem AS _Item ON HandlingUnitReferenceDocument = _Item.DeliveryDocument AND HandlingUnitRefDocumentItem = _Item.DeliveryDocumentItem  -- association [1..1]
-- UNION with additional select branch(es): I_HandlingUnitHeaderCombined
;

Learn More