I_RSAU_CONFIG_STATUS

DDL: I_RSAU_CONFIG_STATUS Type: view_entity

Domain Fixed Values for RSAU Status

I_RSAU_CONFIG_STATUS is a CDS View that provides data about "Domain Fixed Values for RSAU Status" in SAP S/4HANA. It reads from 2 data sources (dd07l, dd07t) and exposes 5 fields with key fields DomainName, Status, Low.

Data Sources (2)

SourceAliasJoin Type
dd07l FixedValue from
dd07t ValueText left_outer

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Domain Fixed Values for RSAU Status view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
ObjectModel.dataCategory #TEXT view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY DomainName dd07l domname
KEY Status dd07l as4local
KEY Low dd07l domvalue_l
ddtextasText
ddlanguage
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Domain Fixed Values for RSAU Status'
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable: true
@ObjectModel.dataCategory: #TEXT 
@ObjectModel.resultSet.sizeCategory: #XS
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED

}
define view entity I_RSAU_CONFIG_STATUS   as select from    dd07l as FixedValue
    left outer join dd07t as ValueText on  FixedValue.domname    = ValueText.domname
                                       and FixedValue.domvalue_l = ValueText.domvalue_l
                                       and FixedValue.as4local   = ValueText.as4local

{
      @UI.hidden
  key FixedValue.domname    as DomainName,
      @UI.hidden
  key FixedValue.as4local   as Status,
      @ObjectModel.text.element: ['Text']
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
  key FixedValue.domvalue_l as Low,
      @Semantics.text: true -- identifies the text field
      ValueText.ddtext      as Text,
      @Semantics.language: true --identifies the language
      ValueText.ddlanguage 
}

where
      FixedValue.as4local  = 'A' --Active
  and FixedValue.domname   = 'RSAU_STATUS'
  and ValueText.ddlanguage = $session.system_language

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L",
"DD07T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/