I_EWM_HANDLINGUNITHDR

@AbapCatalog.sqlViewName: 'IEWMHUHDR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'EWM Handling Unit Header'
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType:#BASIC

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #L

@VDM.lifecycle.status: #DEPRECATED
 @VDM.lifecycle.successor: 'I_EWM_HandlingUnitHdr_2'
define view I_EWM_HandlingUnitHdr
  as select from /scwm/huhdr as huhdr
{
      //huhdr

  key huident                                  as HandlingUnitNumber,
  key lgnum                                    as Warehouse,
  key vhi                                      as HandlingUnitIndicator,
      guid_hu                                  as HandlingUnitUUID,
      pmat_guid                                as PackagingMaterialUUID,
      created_by                               as CreatedByUser,
      created_at                               as CreationDateTime,
      //orig_system,

      changed_by                               as LastChangedByUser,
      changed_at                               as LastChangeDateTime,
      g_weight                                 as GrossWeight,
      n_weight                                 as NetWeight,
      unit_gw                                  as WeightUnit,
      t_weight                                 as HandlingUnitTareWeight,
      unit_tw                                  as HandlingUnitTareWeightUnit,
      g_volume                                 as GrossVolume,
      n_volume                                 as HandlingUnitNetVolume,
      unit_gv                                  as VolumeUnit,
      t_volume                                 as HandlingUnitTareVolume,
      unit_tv                                  as HandlingUnitTareVolumeUnit,
      g_capa                                   as HandlingUnitGrossCapacity,
      n_capa                                   as HandlingUnitNetCapacity,
      t_capa                                   as HandlingUnitTareCapacity,
      length                                   as HandlingUnitLength,
      width                                    as HandlingUnitWidth,
      height                                   as HandlingUnitHeight,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'UnitOfMeasureDimension'
      unit_lwh                                 as UnitOfMeasureDimension,
      unit_lwh                                 as EWMDimensionUnit,
      max_weight                               as HandlingUnitMaxWeight,
      tolw                                     as HandlingUnitWeightTolerance,
      tare_var                                 as HasVariableTareWeight,
      max_volume                               as HandlingUnitMaxVolume,
      tolv                                     as HandlingUnitVolumeTolerance,
      closed_package                           as HandlingUnitIsClosed,
      max_capa                                 as MaximumCapacity,
      tolc                                     as HandlingUnitCapacityTolerance,
      max_length                               as HandlingUnitMaxLength,
      max_width                                as HandlingUnitMaxWidth,
      max_height                               as HandlingUnitMaxHeight,
      unit_max_lwh                             as HandlingUnitMaxDimensionUnit,
      letyp                                    as HandlingUnitType,
      flgavq                                   as HandlingUnitHasAvailQty,
      flgmove                                  as HandlingUnitOpenTaskInd,
      procs                                    as ExternalStorageProcessStep,
      copst                                    as ProcessStepCompletedInd,
      prces                                    as StorageProcess,
      dstgrp                                   as ConsolidationGroup,
      wklid                                    as WorkloadIdentification,
      entitled                                 as EntitledToDisposeParty,
      wstyp                                    as StorageType,
      wssec                                    as StorageSection,
      wsbin                                    as StorageBin,
      wcr                                      as WarehouseOrderCreationRule,
      //ipick,

      mfserror                                 as HandlingUnitDefectCode,
      //wtconf,

      ukcon                                    as HandlingUnitContentInd,
      //transit,

      //mfs_stocktrans_cnt,

      //flgtwext,

      pmtyp                                    as PackagingMaterialType,
      packgr                                   as HandlingUnitPackingGroup,
      //saprl,

      phystat                                  as HandlingUnitStatus,
      top                                      as HandlingUnitTopLevelInd,
      bottom                                   as HandlingUnitBottomInd,
      stsma                                    as StatusProfile,
      cast( ps_guid as raw16 preserving type ) as PackagingSpecificationUUID,
      ps_level_seq                             as PackagingSpecificationLevel,
      objref                                   as HandlingUnitObjRefInd,
      hzmt                                     as HazardousSubstanceIndicator,
      logpos                                   as HandlingUnitLogicalPosition,
      logpos_ext                               as DistrEquipmentLogicalPos,
      auto_crea_pick                           as HandlingUnitAutoCreationLevel,
      hu_guid_ext                              as EWMHandlingUnitExternalUUID
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/SCWM/HUHDR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/