P_EWM_HandlingUnitHeaderLog02

@AbapCatalog.sqlViewName: 'PEWMHUHDRLOG02'
@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_HandlingUnitHeaderLog01 returns the latest snapshot readable keys and with latest LastChangeUTCDateTime

//I_EWM_HandlingUnitHeaderLog is used to retrieve relevant business data

define view P_EWM_HandlingUnitHeaderLog02
  as select from P_EWM_HandlingUnitHeaderLog01 as _LatestSnapshot
    inner join   I_EWM_HandlingUnitHeaderLog   as _gmHuHdr on  _gmHuHdr.HandlingUnitExternalID = _LatestSnapshot.HandlingUnitExternalID
                                                           and _gmHuHdr.Warehouse              = _LatestSnapshot.Warehouse
                                                           and _gmHuHdr.LastChangeUTCDateTime  = _LatestSnapshot.LastChangeUTCDateTime
{
  key _gmHuHdr.HandlingUnitExternalID,
  key _gmHuHdr.Warehouse,
      _gmHuHdr.HandlingUnitType,
      _gmHuHdr.PackagingMaterialUUID,
      _gmHuHdr.PackagingMaterialType,
      _gmHuHdr.HandlingUnitStatus,
      _gmHuHdr.StorageType,
      _gmHuHdr.StorageSection,
      _gmHuHdr.StorageBin,
      _gmHuHdr.HandlingUnitMaxWeight,
      _gmHuHdr.GrossWeight,
      _gmHuHdr.NetWeight,
      _gmHuHdr.WeightUnit,
      _gmHuHdr.HandlingUnitTareWeight,
      _gmHuHdr.HandlingUnitTareWeightUnit,
      _gmHuHdr.HandlingUnitMaxVolume,
      _gmHuHdr.GrossVolume,
      _gmHuHdr.HandlingUnitNetVolume,
      _gmHuHdr.HandlingUnitVolumeTolerance,
      _gmHuHdr.VolumeUnit,
      _gmHuHdr.HandlingUnitTareVolume,
      _gmHuHdr.HandlingUnitTareVolumeUnit,
      _gmHuHdr.HandlingUnitLength,
      _gmHuHdr.HandlingUnitWidth,
      _gmHuHdr.HandlingUnitHeight,
      _gmHuHdr.UnitOfMeasureDimension,
      _gmHuHdr.HandlingUnitMaxLength,
      _gmHuHdr.HandlingUnitMaxWidth,
      _gmHuHdr.HandlingUnitMaxHeight,
      _gmHuHdr.HandlingUnitMaxDimensionUnit,
      _gmHuHdr.HandlingUnitUUID,
      _gmHuHdr.ParentHandlingUnitUUID,
      _gmHuHdr.CreatedByUser,
      _gmHuHdr.CreationUTCDateTime,
      _gmHuHdr.LastChangeUTCDateTime,
      _gmHuHdr.LastChangedByUser,
      _gmHuHdr.HandlingUnitTopLevelInd,
      _gmHuHdr.HandlingUnitLogUUID
}