P_EWM_HandlingUnitHeaderLog04

@AbapCatalog.sqlViewName: 'PEWMHUHDRLOG04'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private: true
@VDM.lifecycle.status: #DEPRECATED
//P_EWM_HandlingUnitHeaderLog03 --> Returns latest Handling Unit Header Log with Dlv Reference and Parent HU

//P_EWM_HandlingUnitHeadDlvRef01 --> Returns Delivery Number

//P_EWM_HandlingUnitHeaderLog02 --> Get Readable ParentHandlingUnit

define view P_EWM_HandlingUnitHeaderLog04
  as select from P_EWM_HandlingUnitHeaderLog03 as _HeaderLog

  association [1..1] to P_EWM_HandlingUnitHeadDlvRef01 as _ReferenceDocument  on  $projection.DeliveryUUID = _ReferenceDocument.DeliveryUUID

  association [1..1] to I_Product                      as _PackagingMaterial  on  $projection.PackagingMaterialUUID = _PackagingMaterial.ProductUUID

  association [0..1] to P_EWM_HandlingUnitHeaderLog02  as _ParentHandlingUnit on  _HeaderLog.ParentHandlingUnitUUID  =  _ParentHandlingUnit.HandlingUnitUUID
                                                                              and _HeaderLog.HandlingUnitTopLevelInd <> 'X'
{
  key _HeaderLog.HandlingUnitExternalID,
  key _HeaderLog.Warehouse,
      _HeaderLog.HandlingUnitType,
      _HeaderLog.PackagingMaterialUUID,
      _PackagingMaterial.Product                 as PackagingMaterial,
      _HeaderLog.PackagingMaterialType,
      _HeaderLog.HandlingUnitStatus,
      _HeaderLog.StorageType,
      _HeaderLog.StorageSection,
      _HeaderLog.StorageBin,
      _HeaderLog.HandlingUnitMaxWeight,
      _HeaderLog.GrossWeight,
      _HeaderLog.NetWeight,
      _HeaderLog.WeightUnit,
      _HeaderLog.HandlingUnitTareWeight,
      _HeaderLog.HandlingUnitTareWeightUnit,
      _HeaderLog.HandlingUnitMaxVolume,
      _HeaderLog.GrossVolume,
      _HeaderLog.HandlingUnitNetVolume,
      _HeaderLog.HandlingUnitVolumeTolerance,
      _HeaderLog.VolumeUnit,
      _HeaderLog.HandlingUnitTareVolume,
      _HeaderLog.HandlingUnitTareVolumeUnit,
      _HeaderLog.HandlingUnitLength,
      _HeaderLog.HandlingUnitWidth,
      _HeaderLog.HandlingUnitHeight,
      _HeaderLog.UnitOfMeasureDimension,
      _HeaderLog.HandlingUnitMaxLength,
      _HeaderLog.HandlingUnitMaxWidth,
      _HeaderLog.HandlingUnitMaxHeight,
      _HeaderLog.HandlingUnitMaxDimensionUnit,
      _HeaderLog.HandlingUnitUUID,
      _HeaderLog.ParentHandlingUnitUUID,
      _ParentHandlingUnit.HandlingUnitExternalID as ParentHandlingUnitNumber,
      _HeaderLog.CreatedByUser,
      _HeaderLog.CreationUTCDateTime,
      //ETAG

      case
        when LastChangeUTCDateTime is initial then CreationUTCDateTime
        else LastChangeUTCDateTime end           as LastChangeUTCDateTime,
      _HeaderLog.LastChangedByUser,
      _HeaderLog.HandlingUnitTopLevelInd,
      _HeaderLog.HandlingUnitLogUUID,
      _HeaderLog.DeliveryUUID,
      _ReferenceDocument.ReferenceDocumentNumber
}