I_EWM_HandlingUnitHeaderLog_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_HandlingUnitHeaderLog_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_HandlingUnitHeaderLog_2 AS
SELECT
  cast(_HandlingUnitHeaderLog.huident as char20 preserving type ) AS HandlingUnitExternalID,
  _HandlingUnitHeaderLog.lgnum AS EWMWarehouse,
  _HandlingUnitHeaderLog.log AS HandlingUnitLogUUID,
  _HandlingUnitHeaderLog.letyp AS HandlingUnitType,
  cast(_HandlingUnitHeaderLog.pmat_guid as raw16 preserving type ) AS PackagingMaterialUUID,
  _HandlingUnitHeaderLog.pmtyp AS PackagingMaterialType,
  _HandlingUnitHeaderLog.phystat AS HandlingUnitStatus,
  _HandlingUnitHeaderLog.wstyp AS EWMStorageType,
  _HandlingUnitHeaderLog.wssec AS EWMStorageSection,
  _HandlingUnitHeaderLog.wsbin AS EWMStorageBin,
  _HandlingUnitHeaderLog.max_weight AS HandlingUnitMaxWeight,
  _HandlingUnitHeaderLog.g_weight AS GrossWeight,
  _HandlingUnitHeaderLog.n_weight AS NetWeight,
  _HandlingUnitHeaderLog.unit_gw AS WeightUnit,
  _HandlingUnitHeaderLog.t_weight AS HandlingUnitTareWeight,
  _HandlingUnitHeaderLog.unit_tw AS HandlingUnitTareWeightUnit,
  _HandlingUnitHeaderLog.max_volume AS HandlingUnitMaxVolume,
  _HandlingUnitHeaderLog.g_volume AS GrossVolume,
  _HandlingUnitHeaderLog.n_volume AS HandlingUnitNetVolume,
  _HandlingUnitHeaderLog.tolv AS HandlingUnitVolumeTolerance,
  _HandlingUnitHeaderLog.unit_gv AS VolumeUnit,
  _HandlingUnitHeaderLog.t_volume AS HandlingUnitTareVolume,
  _HandlingUnitHeaderLog.unit_tv AS HandlingUnitTareVolumeUnit,
  _HandlingUnitHeaderLog.length AS HandlingUnitLength,
  _HandlingUnitHeaderLog.width AS HandlingUnitWidth,
  _HandlingUnitHeaderLog.height AS HandlingUnitHeight,
  _HandlingUnitHeaderLog.unit_lwh AS EWMDimensionUnit,
  _HandlingUnitHeaderLog.max_length AS HandlingUnitMaxLength,
  _HandlingUnitHeaderLog.max_width AS HandlingUnitMaxWidth,
  _HandlingUnitHeaderLog.max_height AS HandlingUnitMaxHeight,
  _HandlingUnitHeaderLog.unit_max_lwh AS HandlingUnitMaxDimensionUnit,
  _HandlingUnitHeaderLog.guid_hu AS HandlingUnitUUID,
  _HandlingUnitHeaderLog.guid_parent AS ParentHandlingUnitUUID,
  _HandlingUnitHeaderLog.created_by AS CreatedByUser,
  _HandlingUnitHeaderLog.created_at AS CreationUTCDateTime,
  _HandlingUnitHeaderLog.changed_by AS LastChangedByUser,
  _HandlingUnitHeaderLog.changed_at AS LastChangeUTCDateTime,
  _HandlingUnitHeaderLog.top AS HandlingUnitTopLevelInd,
  _HandlingUnitHeaderLog.hu_guid_ext AS EWMHandlingUnitExternalUUID
FROM /scwm/gmhuhdr AS _HandlingUnitHeaderLog
;