I_EWM_StorageBinVH

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_StorageBinVH.
-- 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_StorageBinVH AS
SELECT
  EWMWarehouse,
  EWMStorageBin,
  EWMStorageType,
  cast( _StorageTypeText[1:Language=$session.system_language].EWMStorageTypeName as ewm_de_storagetypedesc preserving type ) AS EWMStorageTypeName,
  EWMStorageSection,
  cast( _StorageSectionText[1:Language=$session.system_language].StorageSectionName as ewm_de_storagesectiondesc preserving type ) AS StorageSectionName,
  EWMStorageBinType,
  cast( _StorageBinTypeText[1:Language=$session.system_language].StorageBinTypeName as ewm_de_storagebintypedesc preserving type ) AS StorageBinTypeName,
  EWMStorageBinIsEmpty
FROM I_EWM_StorageBin_2
LEFT OUTER JOIN I_EWM_StorageTypeText_2 AS _StorageTypeText ON EWMWarehouse = _StorageTypeText.EWMWarehouse AND EWMStorageType = _StorageTypeText.EWMStorageType AND EWMStorageType is not null  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageSectionText_2 AS _StorageSectionText ON EWMWarehouse = _StorageSectionText.EWMWarehouse AND EWMStorageType = _StorageSectionText.EWMStorageType AND EWMStorageSection = _StorageSectionText.EWMStorageSection AND EWMStorageSection is not null  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageBinTypeText_2 AS _StorageBinTypeText ON EWMWarehouse = _StorageBinTypeText.EWMWarehouse AND EWMStorageBinType = _StorageBinTypeText.EWMStorageBinType AND EWMStorageBinType is not null  -- association [0..*]
;