I_TndrgResponseIsNegativeText

DDL: I_TNDRGRESPONSEISNEGATIVETEXT Type: view BASIC

Text of Indicator that Tendering Response is Negative

I_TndrgResponseIsNegativeText is a Basic CDS View that provides data about "Text of Indicator that Tendering Response is Negative" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields TndrgResponseIsNegative, Language.

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Annotations (11)

NameValueLevelField
EndUserText.label Text of Indicator that Tendering Response is Negative view
ObjectModel.representativeKey TndrgResponseIsNegative 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 IISTENDRSPNEGT view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY TndrgResponseIsNegative
KEY Language ddlanguage
TndrgResponseIsNegativeDesc ddtext
_TndrgResponseIsNegative _TndrgResponseIsNegative
_Language _Language
@EndUserText:   {label:              'Text of Indicator that Tendering Response is Negative'}
@ObjectModel:   {representativeKey:  'TndrgResponseIsNegative',
                 dataCategory:       #TEXT,
                 usageType:          {serviceQuality:  #A,
                                      sizeCategory:    #S,
                                      dataClass:       #CUSTOMIZING}}
@VDM:           {viewType:           #BASIC}
@AbapCatalog:   {compiler:           {compareFilter: true},
                 sqlViewName:        'IISTENDRSPNEGT'}                             
@AccessControl: {authorizationCheck: #NOT_REQUIRED}
@ClientHandling.algorithm:           #SESSION_VARIABLE

define view I_TndrgResponseIsNegativeText
as select from dd07t
association[0..1] to I_TndrgResponseIsNegative as _TndrgResponseIsNegative on $projection.TndrgResponseIsNegative = _TndrgResponseIsNegative.TndrgResponseIsNegative
association[0..1] to I_Language                as _Language                on $projection.Language                = _Language.Language
{
    @ObjectModel.foreignKey.association: '_TndrgResponseIsNegative'
key cast(substring(domvalue_l, 1, 1) as /scmtms/vdm_negative_response preserving type) as TndrgResponseIsNegative,
    @Semantics.language
    @ObjectModel.foreignKey.association: '_Language'
key ddlanguage                                                                 as Language,
    @Semantics.text
    ddtext as TndrgResponseIsNegativeDesc,
    
    /* Associations */
    _TndrgResponseIsNegative,
    _Language
} 
where domname = '/SCMTMS/VDM_NEGATIVE_RESPONSE'
and as4local = 'A'; 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_TNDRGRESPONSEISNEGATIVE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/