R_HandlingUnitItemTP
Handling Unit Item TP View
R_HandlingUnitItemTP is a Transactional CDS View that provides data about "Handling Unit Item TP View" in SAP S/4HANA. It reads from 1 data source (I_HandlingUnitItemCombined) and exposes 29 fields with key fields HandlingUnitExternalID, Warehouse, StockItemUUID. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_HandlingUnitItemCombined | I_HandlingUnitItemCombined | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | R_HandlingUnitItemSerialNoTP | _HandlingUnitItemSerialNumber | |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Handling Unit Item TP View | view | |
| Search.searchable | true | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| VDM.viewType | #TRANSACTIONAL | view |
Fields (29)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | HandlingUnitExternalID | HandlingUnitExternalID | ||
| KEY | Warehouse | Warehouse | ||
| KEY | StockItemUUID | StockItemUUID | ||
| HandlingUnitItem | HandlingUnitItem | |||
| Material | Material | |||
| HandlingUnitInternalID | HandlingUnitInternalID | |||
| HandlingUnitTypeOfContent | HandlingUnitTypeOfContent | |||
| HandlingUnitNestedExternalID | ||||
| HandlingUnitReferenceDocument | HandlingUnitReferenceDocument | |||
| HandlingUnitRefDocumentItem | HandlingUnitRefDocumentItem | |||
| HandlingUnitQuantity | ||||
| HandlingUnitQuantityUnit | HandlingUnitQuantityUnit | |||
| HandlingUnitAltUnitOfMeasure | HandlingUnitAltUnitOfMeasure | |||
| MaterialName | MaterialName | |||
| Batch | Batch | |||
| Plant | Plant | |||
| StorageLocation | StorageLocation | |||
| ShelfLifeExpirationDate | ShelfLifeExpirationDate | |||
| HandlingUnitGoodsReceiptDate | HandlingUnitGoodsReceiptDate | |||
| CountryOfOrigin | CountryOfOrigin | |||
| HandlingUnitNrOfAuxPackgMat | HandlingUnitNrOfAuxPackgMat | |||
| HandlingUnitNumberOfSerialNumb | HandlingUnitNumberOfSerialNumb | |||
| SerialNumberProfile | SerialNumberProfile | |||
| InternalJITCallNumber | InternalJITCallNumber | |||
| JITCallComponentGrpItemNumber | JITCallComponentGrpItemNumber | |||
| _HandlingUnit | _HandlingUnit | |||
| _HandlingUnitAltUnitOfMeasure | _HandlingUnitAltUnitOfMeasure | |||
| _HandlingUnitQuantityUnit | _HandlingUnitQuantityUnit | |||
| _HandlingUnitItemSerialNumber | _HandlingUnitItemSerialNumber |
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Handling Unit Item TP View'
@Search.searchable: true
@ObjectModel: {
usageType: {
serviceQuality: #C,
dataClass: #MIXED,
sizeCategory: #XL
}
}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
define view entity R_HandlingUnitItemTP
as select from I_HandlingUnitItemCombined
association to parent R_HandlingUnitTP as _HandlingUnit on $projection.HandlingUnitExternalID = _HandlingUnit.HandlingUnitExternalID
and $projection.Warehouse = _HandlingUnit.Warehouse
composition [0..*] of R_HandlingUnitItemSerialNoTP as _HandlingUnitItemSerialNumber
{
@Search.defaultSearchElement : true
@Search.fuzzinessThreshold : 0.8
@Search.ranking : #HIGH
key HandlingUnitExternalID,
key Warehouse,
key StockItemUUID,
HandlingUnitItem,
Material,
HandlingUnitInternalID,
HandlingUnitTypeOfContent,
cast( '00000000000000000000' as exidv) as HandlingUnitNestedExternalID,
HandlingUnitReferenceDocument,
HandlingUnitRefDocumentItem,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitQuantityUnit'
cast ( HandlingUnitQuantity as vemng ) as HandlingUnitQuantity,
HandlingUnitQuantityUnit,
HandlingUnitAltUnitOfMeasure,
MaterialName,
Batch,
Plant,
StorageLocation,
ShelfLifeExpirationDate,
HandlingUnitGoodsReceiptDate,
CountryOfOrigin,
HandlingUnitNrOfAuxPackgMat,
HandlingUnitNumberOfSerialNumb,
SerialNumberProfile,
// Extension for JIT Call Reference
InternalJITCallNumber,
JITCallComponentGrpItemNumber,
/* Associations */
_HandlingUnit,
_HandlingUnitAltUnitOfMeasure,
_HandlingUnitQuantityUnit,
_HandlingUnitItemSerialNumber
}
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