I_FldLogsShptHandlingUnitItem

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Pack Container Handling Unit Items'
@Metadata.ignorePropagatedAnnotations: true
@UI.headerInfo: {
typeName: 'Product',
 typeNamePlural:'Products'}
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
define view entity I_FldLogsShptHandlingUnitItem
  //as select from I_HandlingUnitItemCombined

  as select from I_FldLogsShptHndlgUnitHdrItm
  //association [1..1] to I_HandlingUnitHeaderCombined as _HuHeader on $projection.HandlingUnitExternalID = _HuHeader.HandlingUnitExternalID

  association [1..1] to I_DeliveryDocumentItem as _Item on  $projection.HandlingUnitReferenceDocument = _Item.DeliveryDocument
                                                        and $projection.HandlingUnitRefDocumentItem   = _Item.DeliveryDocumentItem
{
      @UI.hidden: true
  key HandlingUnitExternalID,
      @UI.hidden: true
  key cast(Warehouse as lgnum) as Warehouse,
      @UI.hidden: true
  key StockItemUUID,
      @UI.hidden: true
      HandlingUnitExternalID   as ParentHandlingUnitNumber,
      @UI.lineItem: [{position: 10, label: 'Product' }]
      @ObjectModel.text.element: ['MaterialName']
      @UI.textArrangement: #TEXT_FIRST
      case when Material <> ''
      then Material
      else _Item.DeliveryDocumentItemText
      end                      as Material,
      //Material,

      @Semantics.text: true
      MaterialName,
      @UI.lineItem: [{position: 20, label: 'Packaging Material' }]
      //cast ('' as vhilm )                              as PackagingMaterial,

      //_HuHeader.PackagingMaterial as PackagingMaterial,

      PackagingMaterial,
      @UI.lineItem: [{position: 30, label: 'Packed Quantity' }]
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitQuantityUnit'
      HandlingUnitQuantity,
      @UI.hidden: true
      HandlingUnitQuantityUnit,
      @UI.lineItem: [{position: 40, label: 'Reference Document' }]
      //cast( HandlingUnitReferenceDocument as vpobjkey) as HandlingUnitReferenceDocument,

      HandlingUnitReferenceDocument,
      @UI.lineItem: [{position: 50, label: 'Reference Document Item' }]
      //cast( ltrim(HandlingUnitRefDocumentItem, '0') as posnr_vl )   as HandlingUnitRefDocumentItem,

      HandlingUnitRefDocumentItem,
      @UI.lineItem: [{position: 60, label: 'Plant' }]
      Plant,
      @UI.lineItem: [{position: 70, label: 'Storage Location' }]
      StorageLocation
}
union select from I_HandlingUnitHeaderCombined
{
  key HandlingUnitExternalID,
  key cast(' ' as lgnum )                            as Warehouse,
  key hextobin( '00000000000000000000000000000000' ) as StockItemUUID,
      ParentHandlingUnitNumber,
      cast(' ' as matnr)                             as Material,
      cast(HandlingUnitExternalID as maktx )         as MaterialName,
      PackagingMaterial,
      cast(1 as vemng )                              as HandlingUnitQuantity,
      cast ('' as vemeh )                            as HandlingUnitQuantityUnit,
      ltrim(HandlingUnitReferenceDocument, '0')      as HandlingUnitReferenceDocument,
      cast('' as posnr_vl )                          as HandlingUnitRefDocumentItem,
      Plant,
      StorageLocation
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENTITEM",
"I_FLDLOGSSHPTHNDLGUNITHDRITM",
"I_HANDLINGUNITHEADERCOMBINED"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/