R_HandlingUnitTP
Handling Unit TP View
R_HandlingUnitTP is a Transactional CDS View that provides data about "Handling Unit TP View" in SAP S/4HANA. It reads from 1 data source (I_HandlingUnitHeaderCombined) and exposes 81 fields with key fields HandlingUnitExternalID, Warehouse. It has 4 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_HandlingUnitHeaderCombined | I_HandlingUnitHeaderCombined | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_HandlingUnitHeader | _Extension | $projection.HandlingUnitExternalID = _Extension.HandlingUnitExternalID |
| [0..*] | R_HandlingUnitItemTP | _HandlingUnitItem | |
| [0..*] | R_HandlingUnitReferenceDocTP | _HandlingUnitReferenceDoc | |
| [0..*] | R_HandlingUnitAlternativeIdTP | _HandlingUnitAlternativeID | |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Handling Unit TP View | view | |
| Search.searchable | true | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.sapObjectNodeType.name | HandlingUnit | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| VDM.viewType | #TRANSACTIONAL | view |
Fields (81)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | HandlingUnitExternalID | HandlingUnitExternalID | ||
| KEY | Warehouse | Warehouse | ||
| HandlingUnitCharUUID | ||||
| HandlingUnitExternalIdType | HandlingUnitExternalIdType | |||
| HndlgUnitExtIDCheckIsDisabled | ||||
| Plant | Plant | |||
| StorageLocation | StorageLocation | |||
| ShippingPoint | ShippingPoint | |||
| HandlingUnitInternalID | HandlingUnitInternalID | |||
| HandlingUnitLowerLevelRefer | HandlingUnitLowerLevelRefer | |||
| ParentHandlingUnitNumber | ParentHandlingUnitNumber | |||
| HighestLevelHandlingUnitNumber | HighestLevelHandlingUnitNumber | |||
| PackagingMaterial | PackagingMaterial | |||
| PackagingMaterialType | PackagingMaterialType | |||
| GrossWeight | GrossWeight | |||
| NetWeight | NetWeight | |||
| HandlingUnitMaxWeight | HandlingUnitMaxWeight | |||
| WeightUnit | WeightUnit | |||
| HandlingUnitTareWeight | HandlingUnitTareWeight | |||
| HandlingUnitTareWeightUnit | HandlingUnitTareWeightUnit | |||
| GrossVolume | GrossVolume | |||
| HandlingUnitNetVolume | HandlingUnitNetVolume | |||
| HandlingUnitMaxVolume | HandlingUnitMaxVolume | |||
| VolumeUnit | VolumeUnit | |||
| HandlingUnitTareVolume | HandlingUnitTareVolume | |||
| HandlingUnitTareVolumeUnit | HandlingUnitTareVolumeUnit | |||
| HandlingUnitLength | HandlingUnitLength | |||
| HandlingUnitWidth | HandlingUnitWidth | |||
| HandlingUnitHeight | HandlingUnitHeight | |||
| UnitOfMeasureDimension | UnitOfMeasureDimension | |||
| HandlingUnitPackingObjectType | HandlingUnitPackingObjectType | |||
| HandlingUnitReferenceDocument | ||||
| HandlingUnitHasCrossRefDoc | HandlingUnitHasCrossRefDoc | |||
| CreatedByUser | CreatedByUser | |||
| CreationDateTime | ||||
| LastChangedByUser | LastChangedByUser | |||
| LastChangeDateTime | ||||
| HandlingUnitInternalStatus | HandlingUnitInternalStatus | |||
| HandlingUnitProcessStatus | HandlingUnitProcessStatus | |||
| SourceHandlingUnitUUID | SourceHandlingUnitUUID | |||
| PackingInstruction | PackingInstruction | |||
| HandlingUnitSecondExternalId | HandlingUnitSecondExternalId | |||
| HandlingUnitSlotNumber | HandlingUnitSlotNumber | |||
| HndlgUnitRlvnceForJIT | HndlgUnitRlvnceForJIT | |||
| StorageType | StorageType | |||
| StorageSection | StorageSection | |||
| StorageBin | StorageBin | |||
| EWMResource | EWMResource | |||
| EWMConsolidationGroup | EWMConsolidationGroup | |||
| HandlingUnitIsClosed | HandlingUnitIsClosed | |||
| ExternalStorageProcessStep | ExternalStorageProcessStep | |||
| StorageProcess | StorageProcess | |||
| EWMHUProcessStepIsCompleted | EWMHUProcessStepIsCompleted | |||
| EWMHandlingUnitIsPlanned | EWMHandlingUnitIsPlanned | |||
| EWMHandlingUnitIsInStock | EWMHandlingUnitIsInStock | |||
| EWMHandlingUnitIsUnloaded | EWMHandlingUnitIsUnloaded | |||
| EWMHandlingUnitIsLoaded | EWMHandlingUnitIsLoaded | |||
| EWMTranspUnitIsAssigned | EWMTranspUnitIsAssigned | |||
| EWMHUContentChangeIsBlocked | EWMHUContentChangeIsBlocked | |||
| EWMHUMovementChangeIsBlocked | EWMHUMovementChangeIsBlocked | |||
| EWMHUAttributeChangeIsBlocked | EWMHUAttributeChangeIsBlocked | |||
| EWMHUPostingChangeIsBlocked | EWMHUPostingChangeIsBlocked | |||
| EWMHUIsBlockedByCustoms | EWMHUIsBlockedByCustoms | |||
| EWMHUIsPackedForShipping | EWMHUIsPackedForShipping | |||
| EWMHandlingUnitType | HandlingUnitType | |||
| EWMSrlNmbrForPackagingMaterial | EWMSrlNmbrForPackagingMaterial | |||
| HandlingUnitMaxLength | HandlingUnitMaxLength | |||
| HandlingUnitMaxWidth | HandlingUnitMaxWidth | |||
| HandlingUnitMaxHeight | HandlingUnitMaxHeight | |||
| HandlingUnitMaxDimensionUnit | HandlingUnitMaxDimensionUnit | |||
| EWMHUIsJITUpdateRelevant | EWMHUIsJITUpdateRelevant | |||
| EWMHUDestinationProdnSupArea | EWMHUDestinationProdnSupArea | |||
| EWMHUDestinationStorageBin | EWMHUDestinationStorageBin | |||
| _HandlingUnitItem | _HandlingUnitItem | |||
| _HandlingUnitReferenceDoc | _HandlingUnitReferenceDoc | |||
| _HandlingUnitAlternativeID | _HandlingUnitAlternativeID | |||
| _UnitOfMeasureDimension | _UnitOfMeasureDimension | |||
| _VolumeUnit | _VolumeUnit | |||
| _VolumeUnitTare | _VolumeUnitTare | |||
| _WeightUnit | _WeightUnit | |||
| _WeightUnitTare | _WeightUnitTare |
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Handling Unit TP View'
@Search.searchable: true
@ObjectModel: {
usageType: {
serviceQuality: #C,
dataClass: #MIXED,
sizeCategory: #XL
}
}
@ObjectModel.sapObjectNodeType.name:'HandlingUnit'
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
define root view entity R_HandlingUnitTP
as select from I_HandlingUnitHeaderCombined
composition [0..*] of R_HandlingUnitItemTP as _HandlingUnitItem
composition [0..*] of R_HandlingUnitReferenceDocTP as _HandlingUnitReferenceDoc
composition [0..*] of R_HandlingUnitAlternativeIdTP as _HandlingUnitAlternativeID
//Extensibility
association [0..1] to E_HandlingUnitHeader as _Extension on $projection.HandlingUnitExternalID = _Extension.HandlingUnitExternalID
{
@Search.defaultSearchElement : true
@Search.fuzzinessThreshold : 0.8
@Search.ranking : #HIGH
key HandlingUnitExternalID,
key Warehouse,
cast(HandlingUnitCharUUID as char32) as HandlingUnitCharUUID, //proper casting needs to be implemented | Edm.GUID
HandlingUnitExternalIdType,
cast( '' as lohum_hu_extid_check_disabled preserving type ) as HndlgUnitExtIDCheckIsDisabled,
Plant,
StorageLocation,
ShippingPoint,
HandlingUnitInternalID,
HandlingUnitLowerLevelRefer,
ParentHandlingUnitNumber,
HighestLevelHandlingUnitNumber,
PackagingMaterial,
PackagingMaterialType,
@Semantics.quantity.unitOfMeasure: 'WeightUnit'
GrossWeight,
@Semantics.quantity.unitOfMeasure: 'WeightUnit'
NetWeight,
@Semantics.quantity.unitOfMeasure: 'WeightUnit'
HandlingUnitMaxWeight,
WeightUnit,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitTareWeightUnit'
HandlingUnitTareWeight,
HandlingUnitTareWeightUnit,
@Semantics.quantity.unitOfMeasure: 'VolumeUnit'
GrossVolume,
@Semantics.quantity.unitOfMeasure: 'VolumeUnit'
HandlingUnitNetVolume,
@Semantics.quantity.unitOfMeasure: 'VolumeUnit'
HandlingUnitMaxVolume,
VolumeUnit,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitTareVolumeUnit'
HandlingUnitTareVolume,
HandlingUnitTareVolumeUnit,
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'
HandlingUnitLength,
HandlingUnitWidth,
HandlingUnitHeight,
UnitOfMeasureDimension,
HandlingUnitPackingObjectType,
//remove leading zeros
ltrim( HandlingUnitReferenceDocument, '0' ) as HandlingUnitReferenceDocument,
HandlingUnitHasCrossRefDoc,
CreatedByUser,
@Semantics.systemDateTime.createdAt: true
cast( CreationDateTime as tzntstmps) as CreationDateTime,
LastChangedByUser,
@Semantics.systemDateTime.lastChangedAt: true
cast( LastChangeDateTime as tzntstmps) as LastChangeDateTime,
HandlingUnitInternalStatus,
HandlingUnitProcessStatus,
SourceHandlingUnitUUID,
PackingInstruction,
HandlingUnitSecondExternalId,
HandlingUnitSlotNumber,
HndlgUnitRlvnceForJIT,
// EWM fields
StorageType,
StorageSection,
StorageBin,
EWMResource,
EWMConsolidationGroup,
HandlingUnitIsClosed,
// EWM fields Process Oriented Storage Control (POSC)
// E.g., After packing create a warehouse task to move a HU from a work center to the staging/goods issue area
ExternalStorageProcessStep,
StorageProcess,
EWMHUProcessStepIsCompleted,
// EWM fields HU Process Status
EWMHandlingUnitIsPlanned,
EWMHandlingUnitIsInStock,
EWMHandlingUnitIsUnloaded,
EWMHandlingUnitIsLoaded,
EWMTranspUnitIsAssigned,
// EWM fields HU Blocked Status
EWMHUContentChangeIsBlocked,
EWMHUMovementChangeIsBlocked,
EWMHUAttributeChangeIsBlocked,
EWMHUPostingChangeIsBlocked,
EWMHUIsBlockedByCustoms,
EWMHUIsPackedForShipping,
HandlingUnitType as EWMHandlingUnitType,
EWMSrlNmbrForPackagingMaterial,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitMaxDimensionUnit'
HandlingUnitMaxLength,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitMaxDimensionUnit'
HandlingUnitMaxWidth,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitMaxDimensionUnit'
HandlingUnitMaxHeight,
HandlingUnitMaxDimensionUnit,
// Multifitment Point
EWMHUIsJITUpdateRelevant,
EWMHUDestinationProdnSupArea,
EWMHUDestinationStorageBin,
/* Associations */
_HandlingUnitItem,
_HandlingUnitReferenceDoc,
_HandlingUnitAlternativeID,
_UnitOfMeasureDimension,
_VolumeUnit,
_VolumeUnitTare,
_WeightUnit,
_WeightUnitTare
}
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