s_ddl_programs_descriptions

DDL: S_DDL_PROGRAMS_DESCRIPTIONS SQL: S_V_PROG_DESCR Type: view

View on programs with descriptions

s_ddl_programs_descriptions is a CDS View that provides data about "View on programs with descriptions" in SAP S/4HANA. It reads from 4 data sources (trdir, trdir, trdirt, trdirt) and exposes 5 fields with key field name.

4 data source(s) 5 fields

Data Sources (4)

SourceAliasJoin Type
trdir trdir from
trdir trdir union
trdirt trdirt left_outer
trdirt trdirt left_outer

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName S_V_PROG_DESCR view
EndUserText.label View on programs with descriptions view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY name trdir name
language trdirt sprsl
nameasname
language
description trdirt text 
@AbapCatalog.sqlViewName: 'S_V_PROG_DESCR'                  
@EndUserText.label: 'View on programs with descriptions'                          
define view s_ddl_programs_descriptions as select from trdir left outer join trdirt on trdir.name = trdirt.name
{
  key trdir.name as name,
  trdirt.sprsl as language,
  trdirt.text as description
} where ( trdirt.sprsl = $session.system_language or trdirt.sprsl = 'E') and not trdir.name like '_______________________________%' and trdir.subc = '1'
union  
select from trdir left outer join trdirt on trdir.name = trdirt.name and trdirt.sprsl = $session.system_language
{
  key trdir.name as name,
  $session.system_language as language,
  trdirt.text as description
}
where not trdir.name like '_______________________________%' and trdir.subc = '1'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TRDIRT",
"TRDIR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More