I_QuotationReviewIsRequiredT

DDL: I_QUOTATIONREVIEWISREQUIREDT Type: view BASIC

Text of Indicator that Quotation Review is required

I_QuotationReviewIsRequiredT is a Basic CDS View that provides data about "Text of Indicator that Quotation Review is required" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields QuotationReviewIsRequired, Language.

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Annotations (11)

NameValueLevelField
EndUserText.label Text of Indicator that Quotation Review is required view
ObjectModel.representativeKey QuotationReviewIsRequired 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 IISQTANREVRQDT view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY QuotationReviewIsRequired
KEY Language ddlanguage
QuotationReviewIsRequiredDesc ddtext
_QuotationReviewIsRequired _QuotationReviewIsRequired
_Language _Language
@EndUserText:   {label:              'Text of Indicator that Quotation Review is required'}
@ObjectModel:   {representativeKey:  'QuotationReviewIsRequired',
                 dataCategory:       #TEXT,
                 usageType:          {serviceQuality:  #A,
                                      sizeCategory:    #S,
                                      dataClass:       #CUSTOMIZING}}
@VDM:           {viewType:           #BASIC}
@AbapCatalog:   {compiler:           {compareFilter: true},
                 sqlViewName:        'IISQTANREVRQDT'}                             
@AccessControl: {authorizationCheck: #NOT_REQUIRED}
@ClientHandling.algorithm:           #SESSION_VARIABLE

define view I_QuotationReviewIsRequiredT
as select from dd07t
association[0..1] to I_QuotationReviewIsRequired as _QuotationReviewIsRequired on $projection.QuotationReviewIsRequired = _QuotationReviewIsRequired.QuotationReviewIsRequired
association[0..1] to I_Language                  as _Language                  on $projection.Language                  = _Language.Language
{
    @ObjectModel.foreignKey.association: '_QuotationReviewIsRequired'
key cast(substring(domvalue_l, 1, 1) as /scmtms/vdm_tend_quo_rev_rqd preserving type) as QuotationReviewIsRequired,
    @Semantics.language
    @ObjectModel.foreignKey.association: '_Language'
key ddlanguage                                                                 as Language,
    @Semantics.text
    ddtext as QuotationReviewIsRequiredDesc,
    
    /* Associations */
    _QuotationReviewIsRequired,
    _Language
} 
where domname = '/SCMTMS/VDM_TEND_QUO_REV_RQD'
and as4local = 'A'; 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_QUOTATIONREVIEWISREQUIRED"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/