I_EWM_HandlingUnitHdr_2

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_EWM_HandlingUnitHdr_2.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_EWM_HandlingUnitHdr_2 AS
SELECT
  cast(huident as ewm_de_hu_no_conv preserving type ) AS HandlingUnitNumber,
  lgnum AS EWMWarehouse,
  vhi AS HandlingUnitIndicator,
  guid_hu AS HandlingUnitUUID,
  cast(pmat_guid as matid_no_conv preserving type ) AS PackagingMaterialUUID,
  created_by AS CreatedByUser,
  created_at AS CreationDateTime,
  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,
  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,
  copst AS EWMHUProcessStepIsCompleted,
  prces AS StorageProcess,
  dstgrp AS EWMConsolidationGroup,
  wklid AS WorkloadIdentification,
  entitled AS EntitledToDisposeParty,
  wstyp AS EWMStorageType,
  wssec AS EWMStorageSection,
  wsbin AS EWMStorageBin,
  wcr AS WarehouseOrderCreationRule,
  mfserror AS HandlingUnitDefectCode,
  ukcon AS HandlingUnitContentInd,
  pmtyp AS PackagingMaterialType,
  packgr AS HandlingUnitPackingGroup,
  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,
  guid_hu_top AS EWMHghstLvlHandlingUnitUUID,
  pickhuind AS EWMHndlgUnitPickingCriteria,
  cast( pi_guid as raw16 preserving type ) AS EWMPackingInstructionUUID,
  pb_engine AS UnifiedPackageBuildingEngine,
  cast( serid_pmat as ewm_de_serialnumber preserving type ) AS EWMSrlNmbrForPackagingMaterial,
  jit_upd_relevance AS EWMHUIsJITUpdateRelevant,
  destination_psa AS EWMHUDestinationProdnSupArea,
  destination_bin AS EWMHUDestinationStorageBin
FROM /scwm/huhdr AS huhdr
;