ARS_V_USER

DDL: ARS_V_USER SQL: ARS_V_USR Type: view

Wrapper view for USR21

ARS_V_USER is a CDS View that provides data about "Wrapper view for USR21" in SAP S/4HANA. It reads from 1 data source (usr21) and exposes 1 field with key field name.

Data Sources (1)

SourceAliasJoin Type
usr21 usr21 from

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName ARS_V_USR view
ClientDependent true view
EndUserText.label Wrapper view for USR21 view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY name bname
@AbapCatalog.sqlViewName: 'ARS_V_USR'
@ClientDependent: true
@EndUserText.label: 'Wrapper view for USR21'

define view ARS_V_USER as select from usr21 {
  key bname as name,
  case techdesc
    when '' then bname
    else techdesc
  end as description
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"USR21"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/