I_TranspOrdEventIsTimeRlvtText

DDL: I_TRANSPORDEVENTISTIMERLVTTEXT Type: view BASIC

Text of Indicator that Transp. Order Event is Time Relevant

I_TranspOrdEventIsTimeRlvtText is a Basic CDS View that provides data about "Text of Indicator that Transp. Order Event is Time Relevant" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields TranspOrdEventIsTimeRelevant, Language.

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Annotations (11)

NameValueLevelField
EndUserText.label Text of Indicator that Transp. Order Event is Time Relevant view
ObjectModel.representativeKey TranspOrdEventIsTimeRelevant 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 IISTOREVTTMERLTT view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY TranspOrdEventIsTimeRelevant
KEY Language ddlanguage
TranspOrdEventIsTimeRlvtDesc ddtext
_TranspOrdEventIsTimeRlvt _TranspOrdEventIsTimeRlvt
_Language _Language
@EndUserText:   {label:              'Text of Indicator that Transp. Order Event is Time Relevant'}
@ObjectModel:   {representativeKey:  'TranspOrdEventIsTimeRelevant',
                 dataCategory:       #TEXT,
                 usageType:          {serviceQuality:  #A,
                                      sizeCategory:    #S,
                                      dataClass:       #CUSTOMIZING}}
@VDM:           {viewType:           #BASIC}
@AbapCatalog:   {compiler:           {compareFilter: true},
                 sqlViewName:        'IISTOREVTTMERLTT'}                             
@AccessControl: {authorizationCheck: #NOT_REQUIRED}
@ClientHandling.algorithm:           #SESSION_VARIABLE

define view I_TranspOrdEventIsTimeRlvtText
as select from dd07t
association[0..1] to I_TranspOrdEventIsTimeRlvt as _TranspOrdEventIsTimeRlvt on $projection.TranspOrdEventIsTimeRelevant = _TranspOrdEventIsTimeRlvt.TranspOrdEventIsTimeRelevant
association[0..1] to I_Language                 as _Language                 on $projection.Language                     = _Language.Language
{
    @ObjectModel.foreignKey.association: '_TranspOrdEventIsTimeRlvt'
key cast(substring(domvalue_l, 1, 1) as /scmtms/vdm_timerel_event preserving type) as TranspOrdEventIsTimeRelevant,
    @Semantics.language
    @ObjectModel.foreignKey.association: '_Language'
key ddlanguage                                                                 as Language,
    @Semantics.text
    ddtext as TranspOrdEventIsTimeRlvtDesc,
    
    /* Associations */
    _TranspOrdEventIsTimeRlvt,
    _Language
} 
where domname = '/SCMTMS/VDM_TIMEREL_EVENT'
 and as4local = 'A'; 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_TRANSPORDEVENTISTIMERLVT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/