R_HANDLINGUNITITEMTP

CDS View

Handling Unit Item TP View

R_HANDLINGUNITITEMTP is a CDS View in S/4HANA. Handling Unit Item TP View. It contains 3 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 3 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_HandlingUnitItem_2 view_entity projection CONSUMPTION Handling Unit Item
I_HandlingUnitItemTP view_entity projection TRANSACTIONAL Handling Unit Item - TP
R_HandlingUnitItemSerialNoTP view_entity inner TRANSACTIONAL Handling Unit Item Serial Number - TP

Fields (3)

KeyField CDS FieldsUsed in Views
KEY HandlingUnitExternalID HandlingUnitExternalID 1
KEY StockItemUUID StockItemUUID 1
KEY Warehouse Warehouse 1 
@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'
      HandlingUnitQuantity,
      HandlingUnitQuantityUnit,
      HandlingUnitAltUnitOfMeasure,
      

      MaterialName,
      
      Batch,
      
      Plant,
      StorageLocation,
      
      ShelfLifeExpirationDate,
      HandlingUnitGoodsReceiptDate,
      
      CountryOfOrigin,
      
      HandlingUnitNrOfAuxPackgMat,
      
      HandlingUnitNumberOfSerialNumb,
      SerialNumberProfile,
      
      /* Associations */
      _HandlingUnit,
      _HandlingUnitAltUnitOfMeasure,
      _HandlingUnitQuantityUnit,
      _HandlingUnitItemSerialNumber 
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_HANDLINGUNITITEMCOMBINED"
],
"ASSOCIATED":
[
"I_UNITOFMEASURE",
"R_HANDLINGUNITITEMSERIALNOTP",
"R_HANDLINGUNITTP"
],
"BASE":
[
"I_HANDLINGUNITITEMCOMBINED"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More