I_HUPHandlingUnitSchdAgr

DDL: I_HUPHANDLINGUNITSCHDAGR Type: view_entity COMPOSITE
20 Fields 1 Data Sources 4 Associations

Handling Units related to SchdAgr

I_HUPHandlingUnitSchdAgr is a Composite CDS View that provides data about "Handling Units related to SchdAgr" in SAP S/4HANA. It reads from 1 data source (I_HandlingUnitItemResvnItem) and exposes 20 fields with key fields HandlingUnitInternalID, HandlingUnitItem. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_HandlingUnitItemResvnItem I_HandlingUnitItemResvnItem from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_HandlingUnitHeader _HandlingUnitHeader $projection.HandlingUnitInternalID = _HandlingUnitHeader.HandlingUnitInternalID
[0..1] I_HandlingUnitItem _HandlingUnitItem $projection.HandlingUnitInternalID = _HandlingUnitItem.HandlingUnitInternalID
[0..1] I_HandlingUnitProcessStatus _HandlingUnitProcessStatus $projection.HandlingUnitProcessStatus = _HandlingUnitProcessStatus.HandlingUnitProcessStatus
[0..*] I_MaterialText _PackagingMaterialText _PackagingMaterialText.Material = $projection.packagingmaterial

Annotations (6)

NameValueLevelField
VDM.viewType #COMPOSITE view
EndUserText.label Handling Units related to SchdAgr view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitInternalID HandlingUnitInternalID Internal HU no.
KEY HandlingUnitItem HandlingUnitItem HU item
HandlingUnitExternalID _HandlingUnitHeader HandlingUnitExternalID Handling Unit
HandlingUnitCharUUID _HandlingUnitHeader HandlingUnitCharUUID
ReservationObjectNumber ReservationObjectNumber Push Object Key
ReservationObjectItem ReservationObjectItem Item
Product _HandlingUnitItem Material Vehicle Model
HandlingUnitQuantityUnit _HandlingUnitItem HandlingUnitQuantityUnit UoM of HU item
HandlingUnitQuantity _HandlingUnitItem HandlingUnitQuantity Packed Quantity
HandlingUnitTypeOfContent _HandlingUnitItem HandlingUnitTypeOfContent
PackingInstruction _HandlingUnitHeader PackingInstruction Instructions for Packer
PackagingMaterial _HandlingUnitHeader PackagingMaterial Packaging Materials
HandlingUnitLowerLevelRefer _HandlingUnitHeader HandlingUnitLowerLevelRefer
quan153endasHUPPlannedQty
quan153endasHUPConfirmedQty
ShippingPoint _HandlingUnitHeader ShippingPoint Shipping Point
Plant _HandlingUnitItem Plant Valuation Area
_HandlingUnitProcessStatus _HandlingUnitProcessStatus
_Material _HandlingUnitItem _Material
_PackagingMaterialText _PackagingMaterialText

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_HUPHandlingUnitSchdAgr.
-- 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_HUPHandlingUnitSchdAgr AS
SELECT
  HandlingUnitInternalID,
  HandlingUnitItem,
  _HandlingUnitHeader.HandlingUnitExternalID AS HandlingUnitExternalID,
  _HandlingUnitHeader.HandlingUnitCharUUID AS HandlingUnitCharUUID,
  ReservationObjectNumber,
  ReservationObjectItem,
  _HandlingUnitItem.Material AS Product,
  _HandlingUnitItem.HandlingUnitQuantityUnit AS HandlingUnitQuantityUnit,
  _HandlingUnitItem.HandlingUnitQuantity AS HandlingUnitQuantity,
  _HandlingUnitItem.HandlingUnitTypeOfContent AS HandlingUnitTypeOfContent,
  _HandlingUnitHeader.PackingInstruction AS PackingInstruction,
  _HandlingUnitHeader.PackagingMaterial AS PackagingMaterial,
  _HandlingUnitHeader.HandlingUnitLowerLevelRefer AS HandlingUnitLowerLevelRefer,
  case _HandlingUnitHeader.HandlingUnitInternalStatus when '0001' then _HandlingUnitItem.HandlingUnitQuantity else cast (0 as abap.quan(15,3)) end as HUPPlannedQty AS quan153endasHUPPlannedQty,
  case _HandlingUnitHeader.HandlingUnitInternalStatus when '0015' then _HandlingUnitItem.HandlingUnitQuantity when '0020' then _HandlingUnitItem.HandlingUnitQuantity when '0030' then _HandlingUnitItem.HandlingUnitQuantity when '0031' then _HandlingUnitItem.HandlingUnitQuantity when '0040' then _HandlingUnitItem.HandlingUnitQuantity when '0050' then _HandlingUnitItem.HandlingUnitQuantity else cast (0 as abap.quan(15,3)) end as HUPConfirmedQty AS quan153endasHUPConfirmedQty,
  _HandlingUnitHeader.ShippingPoint AS ShippingPoint,
  _HandlingUnitItem.Plant AS Plant,
  _HandlingUnitItem._Material AS _Material
FROM I_HandlingUnitItemResvnItem
LEFT OUTER JOIN I_HandlingUnitHeader AS _HandlingUnitHeader ON HandlingUnitInternalID = _HandlingUnitHeader.HandlingUnitInternalID  -- association [1..1]
LEFT OUTER JOIN I_HandlingUnitItem AS _HandlingUnitItem ON HandlingUnitInternalID = _HandlingUnitItem.HandlingUnitInternalID  -- association [0..1]
LEFT OUTER JOIN I_HandlingUnitProcessStatus AS _HandlingUnitProcessStatus ON HandlingUnitProcessStatus = _HandlingUnitProcessStatus.HandlingUnitProcessStatus  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _PackagingMaterialText ON _PackagingMaterialText.Material = packagingmaterial  -- association [0..*]
;

Learn More