I_EWM_StorageBin

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.
-- 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: IPISTORAGEBIN

CREATE VIEW I_EWM_StorageBin AS
SELECT
  lgnum AS Warehouse,
  lgpla AS StorageBin,
  lgtyp AS StorageType,
  lgber AS StorageSection,
  lptyp AS StorageBinType,
  bin_at AS SourceStorageBinAccessType,
  plauf AS SectionOfStorageBin,
  plpos AS PositionInStorageBin,
  flgsbin AS StorageBinIsSubdivided,
  anzle AS HandlingUnitsInStorageBin,
  maxle AS MaxHandlingUnitsInStorageBin,
  max_weight AS LoadCapacityOfStorageBin,
  unit_w AS WeightUnit,
  weight AS WeightOfMaterialsInStorageBin,
  max_volume AS StorageBinMaxVolume,
  unit_v AS VolumeUnit,
  volum AS StorageBinOccupiedVolume,
  max_capa AS TotalCapacityOfStorageBin,
  fcapa AS AvailableCapacityInStorageBin,
  aisle AS StorageBinFreeDefinedAisleText,
  stack AS StorageBinFreeDefinedStackText,
  lvl_v AS StorageBinFreeDefinedLevelText,
  skzua AS StorageBinIsBlockedForRemoval,
  skzue AS StorageBinIsBlockedForPutaway,
  skzsi AS StorageBinIsBlockedDueToPInv,
  kzler AS StorageBinIsEmpty,
  kzvol AS StorageBinIsFull,
  binsc AS StorageBinFreeDfndSectionText,
  depth AS StorageBinFreeDefinedDepthText,
  cast(rem_bin_depth as ewm_de_rem_bin_depth_no_conv) AS StorageBinFreeDepthValue,
  cast(max_bin_depth as ewm_de_max_bin_depth_no_conv) AS StorageBinMaxDepthValue,
  x_cord AS StorageBinRowPositionInWhse,
  y_cord AS StorageBinStackPositionInWhse,
  z_cord AS StorageBinLevelPositionInWhse,
  guid_loc AS WarehouseLocationUUID,
  guid_hu AS HandlingUnitUUID,
  verif AS StorageBinVerifiedByMobileID,
  pbv_verif AS StorageBinVerifiedByVoiceID,
  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
FROM /scwm/lagp
;