I_TranspOrdIsInTransitText

DDL: I_TRANSPORDISINTRANSITTEXT Type: view BASIC

Text of Indicator that Transportation Order is In Transit

I_TranspOrdIsInTransitText is a Basic CDS View that provides data about "Text of Indicator that Transportation Order is In Transit" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields TranspOrdIsInTransit, Language.

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Annotations (11)

NameValueLevelField
EndUserText.label Text of Indicator that Transportation Order is In Transit view
ObjectModel.representativeKey TranspOrdIsInTransit view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IISTORTRANSITT view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY TranspOrdIsInTransit
KEY Language ddlanguage
TranspOrdIsInTransitDesc ddtext
_TranspOrdIsInTransit _TranspOrdIsInTransit
_Language _Language
@EndUserText:   {label:              'Text of Indicator that Transportation Order is In Transit'}
@ObjectModel:   {representativeKey:  'TranspOrdIsInTransit',
                 dataCategory:       #TEXT,
                 usageType:          {serviceQuality:  #A,
                                      sizeCategory:    #S,
                                      dataClass:       #CUSTOMIZING}}
@VDM:           {viewType:           #BASIC}
@AbapCatalog:   {compiler:           {compareFilter: true},
                 sqlViewName:        'IISTORTRANSITT'}                             
@AccessControl: {authorizationCheck: #NOT_REQUIRED}
@ClientHandling.algorithm:           #SESSION_VARIABLE

define view I_TranspOrdIsInTransitText
as select from dd07t
association[0..1] to I_TranspOrdIsInTransit as _TranspOrdIsInTransit on $projection.TranspOrdIsInTransit = _TranspOrdIsInTransit.TranspOrdIsInTransit
association[0..1] to I_Language             as _Language             on $projection.Language             = _Language.Language
{
    @ObjectModel.foreignKey.association: '_TranspOrdIsInTransit'
key cast(substring(domvalue_l, 1, 1) as /scmtms/vdm_tor_intransit preserving type) as TranspOrdIsInTransit,
    @Semantics.language
    @ObjectModel.foreignKey.association: '_Language'
key ddlanguage                                                                 as Language,
    @Semantics.text
    ddtext as TranspOrdIsInTransitDesc,
    
    /* Associations */
    _TranspOrdIsInTransit,
   _Language
} 
where domname = '/SCMTMS/VDM_TOR_INTRANSIT'
and as4local = 'A'; 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_TRANSPORDISINTRANSIT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/