I_EWM_StorageType_2

DDL: I_EWM_STORAGETYPE_2 Type: view_entity BASIC

Storage Type

I_EWM_StorageType_2 is a Basic CDS View (Dimension) that provides data about "Storage Type" in SAP S/4HANA. It reads from 2 data sources (/scwm/t301, /scwm/t331) and exposes 6 fields with key fields EWMWarehouse, EWMStorageType. It has 2 associations to related views.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
/scwm/t301 StorageType from
/scwm/t331 StorageTypeControl inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_EWM_WarehouseNumber_2 _Warehouse $projection.EWMWarehouse = _Warehouse.EWMWarehouse
[0..*] I_EWM_StorageTypeText_2 _Text $projection.EWMWarehouse = _Text.EWMWarehouse and $projection.EWMStorageType = _Text.EWMStorageType

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Storage Type view
VDM.viewType #BASIC view
Analytics.internalName #LOCAL view
ObjectModel.representativeKey EWMStorageType view
Analytics.dataCategory #DIMENSION view
Analytics.technicalName IEWMSTRGTYP2 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
Metadata.allowExtensions true view
ObjectModel.sapObjectNodeType.name WarehouseStorageType view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY EWMWarehouse /scwm/t301 lgnum
_Warehouse _Warehouse
KEY EWMStorageType /scwm/t301 lgtyp
EWMStorageTypeRole /scwm/t331 st_role
EWMStorageBehavior /scwm/t331 behav
_Text _Text 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Storage Type'

@VDM.viewType:#BASIC
@Analytics.internalName:#LOCAL
@ObjectModel.representativeKey: 'EWMStorageType'
@Analytics.dataCategory: #DIMENSION
@Analytics.technicalName: 'IEWMSTRGTYP2'
@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
@Metadata.allowExtensions:true
@ObjectModel.sapObjectNodeType.name: 'WarehouseStorageType'
define view entity I_EWM_StorageType_2
  as select from /scwm/t301 as StorageType
    inner join   /scwm/t331 as StorageTypeControl on  StorageType.lgnum = StorageTypeControl.lgnum
                                                  and StorageType.lgtyp = StorageTypeControl.lgtyp
  association [0..1] to I_EWM_WarehouseNumber_2 as _Warehouse on  $projection.EWMWarehouse = _Warehouse.EWMWarehouse
  association [0..*] to I_EWM_StorageTypeText_2 as _Text      on  $projection.EWMWarehouse   = _Text.EWMWarehouse
                                                              and $projection.EWMStorageType = _Text.EWMStorageType
{
      @ObjectModel.foreignKey.association: '_Warehouse'
  key StorageType.lgnum          as EWMWarehouse,
      _Warehouse,
      @ObjectModel.text.association: '_Text'
  key StorageType.lgtyp          as EWMStorageType,
      StorageTypeControl.st_role as EWMStorageTypeRole,
      StorageTypeControl.behav   as EWMStorageBehavior,
      _Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/SCWM/T301",
"/SCWM/T331"
],
"ASSOCIATED":
[
"I_EWM_STORAGETYPETEXT_2",
"I_EWM_WAREHOUSENUMBER_2"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More