I_TranspOrdWarehouseText

DDL: I_TRANSPORDWAREHOUSETEXT Type: view_entity BASIC

TM Warehouse - Text

I_TranspOrdWarehouseText is a Basic CDS View that provides data about "TM Warehouse - Text" in SAP S/4HANA. It reads from 2 data sources (t300t, /scwm/t300t) and exposes 7 fields with key fields TranspOrdStopWrhsNmbr, Language, Language. It has 1 association to related views.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
t300t ERPWarehouseName union
/scwm/t300t EWMWarehouseName from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (9)

NameValueLevelField
EndUserText.label TM Warehouse - Text view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey TranspOrdStopWrhsNmbr view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY TranspOrdStopWrhsNmbr /scwm/t300t lgnum
KEY Language /scwm/t300t spras
TranspOrdStopWrhsDesc /scwm/t300t lnumt
lgnumasTranspOrdStopWrhsNmbr
KEY Language t300t spras
TranspOrdStopWrhsDesc t300t lnumt
_Language _Language 
@EndUserText.label: 'TM Warehouse - Text'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel:   {representativeKey:  'TranspOrdStopWrhsNmbr',
                 dataCategory:       #TEXT,
                 usageType:          {serviceQuality: #C,
                                      sizeCategory:   #S,
                                      dataClass:      #CUSTOMIZING}}

define view entity I_TranspOrdWarehouseText
  as select from /scwm/t300t as EWMWarehouseName
  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
  key EWMWarehouseName.lgnum as TranspOrdStopWrhsNmbr,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key EWMWarehouseName.spras as Language,
      @Semantics.text: true
      EWMWarehouseName.lnumt as TranspOrdStopWrhsDesc,

      /* Associations */
      _Language

}
union select from t300t as ERPWarehouseName
association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
  key ERPWarehouseName.lgnum as TranspOrdStopWrhsNmbr,
  key ERPWarehouseName.spras as Language,
      ERPWarehouseName.lnumt as TranspOrdStopWrhsDesc,

      /* Associations */
      _Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/SCWM/T300T",
"T300T"
],
"ASSOCIATED":
[
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More