I_EWM_WhseOrderHndlgUnit

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_WhseOrderHndlgUnit.
-- 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.
-- SQL view name: IEWMWHOHU

CREATE VIEW I_EWM_WhseOrderHndlgUnit AS
SELECT
  whohu.mandt AS Client,
  lgnum AS Warehouse,
  cast ( who as /scwm/de_who_conv_alpha preserving type ) AS WarehouseOrder,
  hukng AS HndlgUnitNumberInWhseOrder,
  pmat_guid AS PackagingMaterialUUID,
  material.Product AS PackagingMaterial,
  material._Text.Language AS Language,
  material._Text.ProductName AS PackagingMaterialDescription,
  huid AS HandlingUnitUUID,
  huident AS HandlingUnitNumber,
  shiphu AS HndlgUnitIsShippingHndlgUnit,
  flgwcr AS HndlgUnitIsCreatedByWhseOrder,
  prces AS StorageProcess,
  dstgrp AS ConsolidationGroup,
  wstyp AS StorageType,
  wssec AS StorageSection,
  wsbin AS StorageBin,
  wcr AS WarehouseOrderCreationRule,
  used AS HndlgUnitIsUsedInWhseOrder,
  pohu_guid AS PlannedShippingHndlgUnitUUID
FROM /scwm/whohu AS whohu
LEFT OUTER JOIN I_Product AS material ON /* join condition not captured in parsed metadata */
;