I_EWM_StorageBin_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_StorageBin_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_StorageBin_2 AS
SELECT
  lgnum AS EWMWarehouse,
  lgpla AS EWMStorageBin,
  lgtyp AS EWMStorageType,
  lgber AS EWMStorageSection,
  lptyp AS EWMStorageBinType,
  bin_at AS EWMStorageBinAccessType,
  plauf AS EWMStorageBinSection,
  plpos AS EWMStorageBinPosition,
  flgsbin AS EWMStorageBinSubdivision,
  max_weight AS EWMStorageBinMaximumWeight,
  unit_w AS WeightUnit,
  weight AS EWMStorageBinUsedWeight,
  max_volume AS EWMStorageBinMaximumVolume,
  unit_v AS VolumeUnit,
  volum AS EWMStorageBinOccupiedVolume,
  max_capa AS EWMStorBinTotalCapacityValue,
  fcapa AS EWMStorBinAvailCapacityValue,
  aisle AS EWMStorBinFreeDefinedAisleText,
  stack AS EWMStorBinFreeDefinedStackText,
  lvl_v AS EWMStorBinFreeDefinedLevelText,
  skzua AS EWMStorBinIsBlockedForRemoval,
  skzue AS EWMStorBinIsBlockedForPutaway,
  skzsi AS EWMStorBinIsBlockedDueToPInv,
  kzler AS EWMStorageBinIsEmpty,
  kzvol AS EWMStorageBinIsFull,
  binsc AS EWMStorBinFreeDfndSectionText,
  depth AS EWMStorageBinFreeDfndDepthText,
  cast(rem_bin_depth as ewm_de_rem_bin_depth_no_conv) AS EWMStorageBinRemainDepthValue,
  cast(max_bin_depth as ewm_de_max_bin_depth_no_conv) AS EWMStorageBinMaxDepthValue,
  x_cord AS EWMStorBinWidthCoordinateValue,
  y_cord AS EWMStorBinLengthCoordinateVal,
  z_cord AS EWMStorBinHeightCoordinateVal,
  guid_loc AS WarehouseLocationUUID,
  guid_hu AS HandlingUnitUUID,
  verif AS EWMStorBinVerifiedByMobileID,
  pbv_verif AS EWMStorageBinVerifiedByVoiceID,
  kzinv AS EWMPhysicalInventoryType,
  ivnum AS PhysicalInventoryDocNumber,
  ivpos AS PhysicalInventoryItemNumber,
  idatu AS PInvCountedUTCDateTime,
  uname AS EWMStorageBinLastChangedByUser,
  cast(laedt as timestamp preserving type) AS EWMStorageBinLastChgDateTime,
  cast(btanr as /scwm/tanum_noconv preserving type) AS EWMStorageBinLastWarehouseTask,
  ptwy_date AS EWMStorageBinFirstPutawayDate,
  moved_at AS EWMStorageBinLastMvtDateTime,
  cleared_at AS EWMStorageBinLastClrgDateTime,
  fixbintyp AS EWMStorageBinFixedBinType,
  angle AS EWMStorageBinAngleValue,
  anzle AS EWMStorBinNumberOfHndlgUnits,
  maxle AS EWMStorBinMaxNmbrOfHndlgUnits,
  brand AS EWMFireContainmentSection,
  lgber_lgst AS EWMStorageGroup
FROM /scwm/lagp
LEFT OUTER JOIN I_EWM_WarehouseNumber_2 AS _Warehouse ON EWMWarehouse = _Warehouse.EWMWarehouse  -- association [0..1]
;