P_EWM_HANDLINGUNITHEADERLOG03

CDS View

P_EWM_HANDLINGUNITHEADERLOG03 is a CDS View in S/4HANA. It contains 38 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 38 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_EWM_HandlingUnitHeaderLog04 view from COMPOSITE

Fields (38)

KeyField CDS FieldsUsed in Views
KEY HandlingUnitExternalID HandlingUnitExternalID 1
KEY Warehouse Warehouse 1
CreatedByUser CreatedByUser 1
CreationUTCDateTime CreationUTCDateTime 1
DeliveryUUID DeliveryUUID 1
GrossVolume GrossVolume 1
GrossWeight GrossWeight 1
HandlingUnitHeight HandlingUnitHeight 1
HandlingUnitLength HandlingUnitLength 1
HandlingUnitLogUUID HandlingUnitLogUUID 1
HandlingUnitMaxDimensionUnit HandlingUnitMaxDimensionUnit 1
HandlingUnitMaxHeight HandlingUnitMaxHeight 1
HandlingUnitMaxLength HandlingUnitMaxLength 1
HandlingUnitMaxVolume HandlingUnitMaxVolume 1
HandlingUnitMaxWeight HandlingUnitMaxWeight 1
HandlingUnitMaxWidth HandlingUnitMaxWidth 1
HandlingUnitNetVolume HandlingUnitNetVolume 1
HandlingUnitStatus HandlingUnitStatus 1
HandlingUnitTareVolume HandlingUnitTareVolume 1
HandlingUnitTareVolumeUnit HandlingUnitTareVolumeUnit 1
HandlingUnitTareWeight HandlingUnitTareWeight 1
HandlingUnitTareWeightUnit HandlingUnitTareWeightUnit 1
HandlingUnitTopLevelInd HandlingUnitTopLevelInd 1
HandlingUnitType HandlingUnitType 1
HandlingUnitUUID HandlingUnitUUID 1
HandlingUnitVolumeTolerance HandlingUnitVolumeTolerance 1
HandlingUnitWidth HandlingUnitWidth 1
LastChangedByUser LastChangedByUser 1
NetWeight NetWeight 1
PackagingMaterialType PackagingMaterialType 1
PackagingMaterialUUID PackagingMaterialUUID 1
ParentHandlingUnitUUID ParentHandlingUnitUUID 1
StorageBin StorageBin 1
StorageSection StorageSection 1
StorageType StorageType 1
UnitOfMeasureDimension UnitOfMeasureDimension 1
VolumeUnit VolumeUnit 1
WeightUnit WeightUnit 1 
@AbapCatalog.sqlViewName: 'PEWMHUHDRLOG03'
@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_HandlingUnitHeaderLog02 --> Returns the latest handling unit header log

// I_EWM_HandlingUnitReferenceLog --> Returns the warehouse request relationship

define view P_EWM_HandlingUnitHeaderLog03 as select from P_EWM_HandlingUnitHeaderLog02 as _HandlingUnitHeaderLog
    
    association[1..1] to I_EWM_HandlingUnitReferenceLog as _HandlingUnitRefLog // No Cross HUs!

      on  _HandlingUnitHeaderLog.HandlingUnitUUID = _HandlingUnitRefLog.HandlingUnitUUID
      and _HandlingUnitHeaderLog.HandlingUnitLogUUID = _HandlingUnitRefLog.HandlingUnitLogUUID
      and _HandlingUnitHeaderLog.HandlingUnitTopLevelInd = 'X'
    
//    association[0..1] to P_EWM_HandlingUnitHeaderLog01 as _ParentHandlingUnit

//      on  _HandlingUnitHeaderLog.ParentHandlingUnitUUID = _ParentHandlingUnit.HandlingUnitUUID

//      and _HandlingUnitHeaderLog.HandlingUnitTopLevelInd <> 'X'

{
  //_HandlingUnitHeaderLog

  key _HandlingUnitHeaderLog.HandlingUnitExternalID,
  key _HandlingUnitHeaderLog.Warehouse,
  _HandlingUnitHeaderLog.HandlingUnitType,
  _HandlingUnitHeaderLog.PackagingMaterialUUID,
  _HandlingUnitHeaderLog.PackagingMaterialType,
  _HandlingUnitHeaderLog.HandlingUnitStatus,
  _HandlingUnitHeaderLog.StorageType,
  _HandlingUnitHeaderLog.StorageSection,
  _HandlingUnitHeaderLog.StorageBin,
  _HandlingUnitHeaderLog.HandlingUnitMaxWeight,
  _HandlingUnitHeaderLog.GrossWeight,
  _HandlingUnitHeaderLog.NetWeight,
  _HandlingUnitHeaderLog.WeightUnit,
  _HandlingUnitHeaderLog.HandlingUnitTareWeight,
  _HandlingUnitHeaderLog.HandlingUnitTareWeightUnit,
  _HandlingUnitHeaderLog.HandlingUnitMaxVolume,
  _HandlingUnitHeaderLog.GrossVolume,
  _HandlingUnitHeaderLog.HandlingUnitNetVolume,
  _HandlingUnitHeaderLog.HandlingUnitVolumeTolerance,
  _HandlingUnitHeaderLog.VolumeUnit,
  _HandlingUnitHeaderLog.HandlingUnitTareVolume,
  _HandlingUnitHeaderLog.HandlingUnitTareVolumeUnit,
  _HandlingUnitHeaderLog.HandlingUnitLength,
  _HandlingUnitHeaderLog.HandlingUnitWidth,
  _HandlingUnitHeaderLog.HandlingUnitHeight,
  _HandlingUnitHeaderLog.UnitOfMeasureDimension,
  _HandlingUnitHeaderLog.HandlingUnitMaxLength,
  _HandlingUnitHeaderLog.HandlingUnitMaxWidth,
  _HandlingUnitHeaderLog.HandlingUnitMaxHeight,
  _HandlingUnitHeaderLog.HandlingUnitMaxDimensionUnit,
  _HandlingUnitHeaderLog.HandlingUnitUUID,
  _HandlingUnitHeaderLog.ParentHandlingUnitUUID,
//  _ParentHandlingUnit.HandlingUnitExternalID as ParentHandlingUnitNumber,

  _HandlingUnitHeaderLog.CreatedByUser,
  _HandlingUnitHeaderLog.CreationUTCDateTime,
  _HandlingUnitHeaderLog.LastChangeUTCDateTime,
  _HandlingUnitHeaderLog.LastChangedByUser,
  _HandlingUnitHeaderLog.HandlingUnitTopLevelInd,
  _HandlingUnitHeaderLog.HandlingUnitLogUUID,
  _HandlingUnitRefLog.DeliveryUUID  
}

Learn More