I_EWM_StorageType

DDL: I_EWM_STORAGETYPE SQL: IEWMSTRGTYP Type: view BASIC Package: VDM_EWM_CORE

Storage Type

I_EWM_StorageType is a Basic CDS View (Dimension) that provides data about "Storage Type" in SAP S/4HANA. It reads from 1 data source (/scwm/t301) and exposes 4 fields with key fields Warehouse, StorageType. It has 2 associations to related views. Part of development package VDM_EWM_CORE.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
/scwm/t301 StorageType from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_EWM_WarehouseNumber _Warehouse $projection.Warehouse = _Warehouse.Warehouse
[0..*] I_EWM_StorageTypeText _Text $projection.Warehouse = _Text.Warehouse and $projection.StorageType = _Text.StorageType

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IEWMSTRGTYP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Storage Type view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Metadata.ignorePropagatedAnnotations true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Warehouse lgnum
_Warehouse _Warehouse
KEY StorageType lgtyp
_Text _Text 
@AbapCatalog.sqlViewName: 'IEWMSTRGTYP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Storage Type'

@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType:#BASIC

@ObjectModel.representativeKey: ['StorageType']
@Analytics.dataCategory: #DIMENSION
@ObjectModel.usageType: {serviceQuality: #A,
                         dataClass: #CUSTOMIZING,
                         sizeCategory: #M}
@ObjectModel.supportedCapabilities: [ #ANALYTICAL_DIMENSION,
                                      #SQL_DATA_SOURCE,                                      
                                      #CDS_MODELING_DATA_SOURCE,
                                      #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION                         
@Metadata.ignorePropagatedAnnotations:true
define view I_EWM_StorageType
  as select from /scwm/t301 as StorageType
  association [0..1] to I_EWM_WarehouseNumber as _Warehouse on  $projection.Warehouse = _Warehouse.Warehouse
  association [0..*] to I_EWM_StorageTypeText as _Text      on  $projection.Warehouse   = _Text.Warehouse
                                                            and $projection.StorageType = _Text.StorageType
{
      @ObjectModel.foreignKey.association: '_Warehouse'
  key lgnum         as Warehouse,
      _Warehouse,
      @ObjectModel.text.association: '_Text'
  key lgtyp         as StorageType,
      _Text

}

Learn More