C_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 C_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.

CREATE VIEW C_EWM_StorageBin AS
SELECT
  Warehouse,
  StorageBin,
  StorageType,
  StorageSection,
  StorageBinType,
  SourceStorageBinAccessType,
  SectionOfStorageBin,
  PositionInStorageBin,
  StorageBinIsSubdivided,
  HandlingUnitsInStorageBin,
  cast( MaxHandlingUnitsInStorageBin as /scwm/de_ui_lagp_maxle) AS MaxHandlingUnitsInStorageBin,
  LoadCapacityOfStorageBin,
  WeightUnit,
  WeightOfMaterialsInStorageBin,
  StorageBinMaxVolume,
  VolumeUnit,
  StorageBinOccupiedVolume,
  TotalCapacityOfStorageBin,
  AvailableCapacityInStorageBin,
  StorageBinFreeDefinedAisleText,
  StorageBinFreeDefinedStackText,
  StorageBinFreeDefinedLevelText,
  StorageBinIsBlockedForRemoval,
  StorageBinIsBlockedForPutaway,
  StorageBinIsBlockedDueToPInv,
  StorageBinIsEmpty,
  StorageBinIsFull,
  StorageBinFreeDfndSectionText,
  StorageBinFreeDefinedDepthText,
  StorageBinFreeDepthValue,
  StorageBinMaxDepthValue,
  StorageBinRowPositionInWhse,
  StorageBinStackPositionInWhse,
  StorageBinLevelPositionInWhse,
  WarehouseLocationUUID,
  HandlingUnitUUID
FROM I_EWM_StorageBin
LEFT OUTER JOIN I_EWM_WarehouseNumberText AS _WarehouseText ON Warehouse = _WarehouseText.Warehouse  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageTypeText AS _StorageTypeText ON Warehouse = _StorageTypeText.Warehouse AND StorageType = _StorageTypeText.StorageType  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageSectionText AS _StorageSectionText ON Warehouse = _StorageSectionText.Warehouse AND StorageType = _StorageSectionText.StorageType AND StorageSection = _StorageSectionText.StorageSection  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageBinTypeText AS _StorageBinTypeText ON Warehouse = _StorageBinTypeText.Warehouse AND StorageBinType = _StorageBinTypeText.StorageBinType  -- association [0..*]
LEFT OUTER JOIN I_EWM_SrceStorBinAccTypeText AS _SourceStorageBinAccTypeText ON Warehouse = _SourceStorageBinAccTypeText.Warehouse AND SourceStorageBinAccessType = _SourceStorageBinAccTypeText.SourceStorageBinAccessType  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageBinIsEmptyText AS _StorageBinIsEmptyText ON StorageBinIsEmpty = _StorageBinIsEmptyText.StorageBinIsEmpty  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageBinIsFullText AS _StorageBinIsFullText ON StorageBinIsFull = _StorageBinIsFullText.StorageBinIsFull  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorBinRemovalBlockText AS _StorBinRemovalBlockText ON StorageBinIsBlockedForRemoval = _StorBinRemovalBlockText.StorageBinIsBlockedForRemoval  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorBinPutawayBlockText AS _StorBinPutawayBlockText ON StorageBinIsBlockedForPutaway = _StorBinPutawayBlockText.StorageBinIsBlockedForPutaway  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorBinPInvBlockText AS _StorBinPInvBlockText ON StorageBinIsBlockedDueToPInv = _StorBinPInvBlockText.StorageBinIsBlockedDueToPInv  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _WeightUnitOfMeasureText ON WeightUnit = _WeightUnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _VolumeUnitOfMeasureText ON VolumeUnit = _VolumeUnitOfMeasureText.UnitOfMeasure  -- association [0..*]
;