R_HandlingUnitItemTP

DDL: R_HANDLINGUNITITEMTP Type: view_entity TRANSACTIONAL

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)

SourceAliasJoin Type
I_HandlingUnitItemCombined I_HandlingUnitItemCombined from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_HandlingUnitItemSerialNoTP _HandlingUnitItemSerialNumber

Annotations (8)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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 
}