I_EWM_HandlingUnitHeaderC
Handling Unit Header - Cube
I_EWM_HandlingUnitHeaderC is a Composite CDS View (Cube) that provides data about "Handling Unit Header - Cube" in SAP S/4HANA. It reads from 2 data sources (P_EWM_HandlingUnitHeader05, P_EWM_HandlingUnitHeader02) and exposes 72 fields with key fields HandlingUnitExternalID, Warehouse, Warehouse. It has 1 association to related views.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| P_EWM_HandlingUnitHeader05 | _HandlingUnitUnion | from |
| P_EWM_HandlingUnitHeader02 | P_EWM_HandlingUnitHeader02 | union_all |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | P_EWM_HandlingUnitHeaderLog04 | _SnapshotHandlingUnit | _HandlingUnitUnion.HandlingUnitExternalID = _SnapshotHandlingUnit.HandlingUnitExternalID and _HandlingUnitUnion.Warehouse = _SnapshotHandlingUnit.Warehouse |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IEWMHUHDRC | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| EndUserText.label | Handling Unit Header - Cube | view | |
| Analytics.internalName | #LOCAL | view | |
| Analytics.dataCategory | #CUBE | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Metadata.allowExtensions | true | view | |
| VDM.lifecycle.status | #DEPRECATED | view |
Fields (72)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | HandlingUnitExternalID | _SnapshotHandlingUnit | HandlingUnitExternalID | |
| KEY | Warehouse | _SnapshotHandlingUnit | Warehouse | |
| PackagingMaterial | _SnapshotHandlingUnit | PackagingMaterial | ||
| PackagingMaterialType | _SnapshotHandlingUnit | PackagingMaterialType | ||
| StorageType | _SnapshotHandlingUnit | StorageType | ||
| HandlingUnitStatus | _SnapshotHandlingUnit | HandlingUnitStatus | ||
| StorageSection | _SnapshotHandlingUnit | StorageSection | ||
| StorageBin | _SnapshotHandlingUnit | StorageBin | ||
| HandlingUnitType | _SnapshotHandlingUnit | HandlingUnitType | ||
| GrossWeight | _SnapshotHandlingUnit | GrossWeight | ||
| NetWeight | _SnapshotHandlingUnit | NetWeight | ||
| HandlingUnitMaxWeight | _SnapshotHandlingUnit | HandlingUnitMaxWeight | ||
| WeightUnit | _SnapshotHandlingUnit | WeightUnit | ||
| HandlingUnitTareWeight | _SnapshotHandlingUnit | HandlingUnitTareWeight | ||
| HandlingUnitTareWeightUnit | _SnapshotHandlingUnit | HandlingUnitTareWeightUnit | ||
| GrossVolume | _SnapshotHandlingUnit | GrossVolume | ||
| HandlingUnitNetVolume | _SnapshotHandlingUnit | HandlingUnitNetVolume | ||
| HandlingUnitMaxVolume | _SnapshotHandlingUnit | HandlingUnitMaxVolume | ||
| VolumeUnit | _SnapshotHandlingUnit | VolumeUnit | ||
| HandlingUnitTareVolume | _SnapshotHandlingUnit | HandlingUnitTareVolume | ||
| HandlingUnitVolumeTolerance | _SnapshotHandlingUnit | HandlingUnitVolumeTolerance | ||
| HandlingUnitTareVolumeUnit | _SnapshotHandlingUnit | HandlingUnitTareVolumeUnit | ||
| HandlingUnitLength | _SnapshotHandlingUnit | HandlingUnitLength | ||
| HandlingUnitWidth | _SnapshotHandlingUnit | HandlingUnitWidth | ||
| HandlingUnitHeight | _SnapshotHandlingUnit | HandlingUnitHeight | ||
| UnitOfMeasureDimension | _SnapshotHandlingUnit | UnitOfMeasureDimension | ||
| HandlingUnitMaxLength | _SnapshotHandlingUnit | HandlingUnitMaxLength | ||
| HandlingUnitMaxWidth | _SnapshotHandlingUnit | HandlingUnitMaxWidth | ||
| HandlingUnitMaxHeight | _SnapshotHandlingUnit | HandlingUnitMaxHeight | ||
| HandlingUnitMaxDimensionUnit | _SnapshotHandlingUnit | HandlingUnitMaxDimensionUnit | ||
| ReferenceDocumentNumber | _SnapshotHandlingUnit | ReferenceDocumentNumber | ||
| CreatedByUser | _SnapshotHandlingUnit | CreatedByUser | ||
| CreationUTCDateTime | _SnapshotHandlingUnit | CreationUTCDateTime | ||
| LastChangedByUser | _SnapshotHandlingUnit | LastChangedByUser | ||
| LastChangeUTCDateTime | ||||
| ParentHandlingUnitNumber | _SnapshotHandlingUnit | ParentHandlingUnitNumber | ||
| KEY | Warehouse | Warehouse | ||
| PackagingMaterial | PackagingMaterial | |||
| PackagingMaterialType | PackagingMaterialType | |||
| StorageType | StorageType | |||
| HandlingUnitStatus | HandlingUnitStatus | |||
| StorageSection | StorageSection | |||
| StorageBin | StorageBin | |||
| HandlingUnitType | HandlingUnitType | |||
| GrossWeight | GrossWeight | |||
| NetWeight | NetWeight | |||
| HandlingUnitMaxWeight | HandlingUnitMaxWeight | |||
| WeightUnit | WeightUnit | |||
| HandlingUnitTareWeight | HandlingUnitTareWeight | |||
| HandlingUnitTareWeightUnit | HandlingUnitTareWeightUnit | |||
| GrossVolume | GrossVolume | |||
| HandlingUnitNetVolume | HandlingUnitNetVolume | |||
| HandlingUnitMaxVolume | HandlingUnitMaxVolume | |||
| VolumeUnit | VolumeUnit | |||
| HandlingUnitTareVolume | HandlingUnitTareVolume | |||
| HandlingUnitVolumeTolerance | HandlingUnitVolumeTolerance | |||
| HandlingUnitTareVolumeUnit | HandlingUnitTareVolumeUnit | |||
| HandlingUnitLength | HandlingUnitLength | |||
| HandlingUnitWidth | HandlingUnitWidth | |||
| HandlingUnitHeight | HandlingUnitHeight | |||
| UnitOfMeasureDimension | UnitOfMeasureDimension | |||
| HandlingUnitMaxLength | HandlingUnitMaxLength | |||
| HandlingUnitMaxWidth | HandlingUnitMaxWidth | |||
| HandlingUnitMaxHeight | HandlingUnitMaxHeight | |||
| HandlingUnitMaxDimensionUnit | HandlingUnitMaxDimensionUnit | |||
| ReferenceDocumentNumber | ReferenceDocumentNumber | |||
| CreatedByUser | CreatedByUser | |||
| CreationUTCDateTime | CreationUTCDateTime | |||
| LastChangedByUser | LastChangedByUser | |||
| LastChangeUTCDateTime | ||||
| ParentHandlingUnitNumber | ParentHandlingUnitNumber | |||
| HandlingUnitUUID | HandlingUnitUUID |
@AbapCatalog.sqlViewName: 'IEWMHUHDRC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Handling Unit Header - Cube'
@Analytics.internalName: #LOCAL
@Analytics.dataCategory: #CUBE
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions: true
@VDM.lifecycle.status: #DEPRECATED
// P_EWM_HandlingUnitHeader05 --> Distinguished Active HU from Snap HU
// P_EWM_HandlingUnitHeaderLog04 --> Returns the latest Snapshot of an HU with all required info
// P_EWM_HandlingUnitHeader02 --> Returns an active HU with all required info
define view I_EWM_HandlingUnitHeaderC
as select from P_EWM_HandlingUnitHeader05 as _HandlingUnitUnion
association [0..1] to P_EWM_HandlingUnitHeaderLog04 as _SnapshotHandlingUnit on _HandlingUnitUnion.HandlingUnitExternalID = _SnapshotHandlingUnit.HandlingUnitExternalID
and _HandlingUnitUnion.Warehouse = _SnapshotHandlingUnit.Warehouse
{
key _SnapshotHandlingUnit.HandlingUnitExternalID,
key _SnapshotHandlingUnit.Warehouse,
_SnapshotHandlingUnit.PackagingMaterial,
_SnapshotHandlingUnit.PackagingMaterialType,
_SnapshotHandlingUnit.StorageType,
_SnapshotHandlingUnit.HandlingUnitStatus, //Not Used By A-View for 1911
_SnapshotHandlingUnit.StorageSection, // Not Used By A-View for 1911
_SnapshotHandlingUnit.StorageBin, // No Used By A-View for 1911
_SnapshotHandlingUnit.HandlingUnitType,
/* Weight */
@Semantics.quantity.unitOfMeasure: 'WeightUnit'
_SnapshotHandlingUnit.GrossWeight,
@Semantics.quantity.unitOfMeasure: 'WeightUnit'
_SnapshotHandlingUnit.NetWeight,
@Semantics.quantity.unitOfMeasure: 'WeightUnit'
_SnapshotHandlingUnit.HandlingUnitMaxWeight,
@Semantics.unitOfMeasure: true
_SnapshotHandlingUnit.WeightUnit,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitTareWeightUnit'
_SnapshotHandlingUnit.HandlingUnitTareWeight,
@Semantics.unitOfMeasure: true
_SnapshotHandlingUnit.HandlingUnitTareWeightUnit,
/* Volume */
@Semantics.quantity.unitOfMeasure: 'VolumeUnit'
_SnapshotHandlingUnit.GrossVolume,
@Semantics.quantity.unitOfMeasure: 'VolumeUnit'
_SnapshotHandlingUnit.HandlingUnitNetVolume,
@Semantics.quantity.unitOfMeasure: 'VolumeUnit'
_SnapshotHandlingUnit.HandlingUnitMaxVolume,
@Semantics.unitOfMeasure: true
_SnapshotHandlingUnit.VolumeUnit,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitTareVolumeUnit'
_SnapshotHandlingUnit.HandlingUnitTareVolume,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitTareVolumeUnit'
_SnapshotHandlingUnit.HandlingUnitVolumeTolerance,
@Semantics.unitOfMeasure: true
_SnapshotHandlingUnit.HandlingUnitTareVolumeUnit,
/* Dimensions */
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'
_SnapshotHandlingUnit.HandlingUnitLength,
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'
_SnapshotHandlingUnit.HandlingUnitWidth,
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'
_SnapshotHandlingUnit.HandlingUnitHeight,
@Semantics.unitOfMeasure: true
_SnapshotHandlingUnit.UnitOfMeasureDimension,
/* Max Dimensions */
@Semantics.quantity.unitOfMeasure: 'HandlingUnitMaxDimensionUnit'
_SnapshotHandlingUnit.HandlingUnitMaxLength,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitMaxDimensionUnit'
_SnapshotHandlingUnit.HandlingUnitMaxWidth,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitMaxDimensionUnit'
_SnapshotHandlingUnit.HandlingUnitMaxHeight,
@Semantics.unitOfMeasure: true
_SnapshotHandlingUnit.HandlingUnitMaxDimensionUnit,
_SnapshotHandlingUnit.ReferenceDocumentNumber,
/* Admin DateTime and User */
_SnapshotHandlingUnit.CreatedByUser,
_SnapshotHandlingUnit.CreationUTCDateTime,
_SnapshotHandlingUnit.LastChangedByUser,
cast( _SnapshotHandlingUnit.LastChangeUTCDateTime as tzntstmps preserving type ) as LastChangeUTCDateTime,
_SnapshotHandlingUnit.ParentHandlingUnitNumber,
_SnapshotHandlingUnit.HandlingUnitUUID
}
where
ActiveEntries = 0 // Filter ony Snapshots
union all select from P_EWM_HandlingUnitHeader02
{
//Active HUs
key HandlingUnitExternalID,
key Warehouse,
PackagingMaterial,
PackagingMaterialType,
StorageType,
HandlingUnitStatus,
//Not Used By A-View for 1911
StorageSection, // Not Used By A-View for 1911
StorageBin, // No Used By A-View for 1911
HandlingUnitType,
/* Weight */
@Semantics.quantity.unitOfMeasure: 'WeightUnit'
GrossWeight,
@Semantics.quantity.unitOfMeasure: 'WeightUnit'
NetWeight,
@Semantics.quantity.unitOfMeasure: 'WeightUnit'
HandlingUnitMaxWeight,
@Semantics.unitOfMeasure: true
WeightUnit,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitTareWeightUnit'
HandlingUnitTareWeight,
@Semantics.unitOfMeasure: true
HandlingUnitTareWeightUnit,
/* Volume */
@Semantics.quantity.unitOfMeasure: 'VolumeUnit'
GrossVolume,
@Semantics.quantity.unitOfMeasure: 'VolumeUnit'
HandlingUnitNetVolume,
@Semantics.quantity.unitOfMeasure: 'VolumeUnit'
HandlingUnitMaxVolume,
@Semantics.unitOfMeasure: true
VolumeUnit,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitTareVolumeUnit'
HandlingUnitTareVolume,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitTareVolumeUnit'
HandlingUnitVolumeTolerance,
@Semantics.unitOfMeasure: true
HandlingUnitTareVolumeUnit,
/* Dimensions */
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'
HandlingUnitLength,
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'
HandlingUnitWidth,
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'
HandlingUnitHeight,
@Semantics.unitOfMeasure: true
UnitOfMeasureDimension,
/* Max Dimensions */
@Semantics.quantity.unitOfMeasure: 'HandlingUnitMaxDimensionUnit'
HandlingUnitMaxLength,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitMaxDimensionUnit'
HandlingUnitMaxWidth,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitMaxDimensionUnit'
HandlingUnitMaxHeight,
@Semantics.unitOfMeasure: true
HandlingUnitMaxDimensionUnit,
ReferenceDocumentNumber,
/* Admin DateTime and User */
CreatedByUser,
CreationUTCDateTime,
LastChangedByUser,
cast( LastChangeUTCDateTime as tzntstmps preserving type ) as LastChangeUTCDateTime,
ParentHandlingUnitNumber,
HandlingUnitUUID
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA