ddcds_simple_type_info

DDL: DDCDS_SIMPLE_TYPE_INFO Type: view_entity

CDS Simple Type Information

ddcds_simple_type_info is a CDS View that provides data about "CDS Simple Type Information" in SAP S/4HANA. It reads from 2 data sources (dddrty_source, tadir). It has 3 associations to related views.

2 data source(s)

Data Sources (2)

SourceAliasJoin Type
dddrty_source dddrty_source from
tadir tadir inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] dddrty_source_t _text_active dddrty_source.type_name = _text_active.type_name and dddrty_source.as4local = _text_active.as4local and _text_active.ddlanguage = $session.system_language
[0..1] dddrty_source_t _text_english dddrty_source.type_name = _text_english.type_name and dddrty_source.as4local = _text_english.as4local and _text_english.ddlanguage = 'E'
[0..1] dddrty_source_t _text_original dddrty_source.type_name = _text_original.type_name and dddrty_source.as4local = _text_original.as4local and _text_original.ddlanguage = tadir.masterlang

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS Simple Type Information view 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CDS Simple Type Information'
define view entity ddcds_simple_type_info
  as select from dddrty_source
    inner join   tadir on  tadir.pgmid    = 'R3TR'
                       and tadir.object   = 'DRTY'
                       and tadir.obj_name = dddrty_source.type_name

  association [0..1] to dddrty_source_t as _text_active   on  dddrty_source.type_name = _text_active.type_name
                                                          and dddrty_source.as4local  = _text_active.as4local
                                                          and _text_active.ddlanguage = $session.system_language

  association [0..1] to dddrty_source_t as _text_english  on  dddrty_source.type_name  = _text_english.type_name
                                                          and dddrty_source.as4local   = _text_english.as4local
                                                          and _text_english.ddlanguage = 'E'

  association [0..1] to dddrty_source_t as _text_original on  dddrty_source.type_name   = _text_original.type_name
                                                          and dddrty_source.as4local    = _text_original.as4local
                                                          and _text_original.ddlanguage = tadir.masterlang

{
        @EndUserText.label: 'Simple Type Name'
  key   cast( dddrty_source.type_name as abap.char(30) )                                                                as simple_type_name,
        @EndUserText.label: 'Short Description'
        cast(coalesce( coalesce( _text_active.ddtext, _text_english.ddtext ), _text_original.ddtext ) as abap.char(60)) as short_description,
        coalesce( coalesce( _text_active.ddlanguage, _text_english.ddlanguage ), _text_original.ddlanguage )            as short_description_language,
        @EndUserText.label: 'Last Changed At'
        cast( dats_tims_to_tstmp( dddrty_source.as4date, dddrty_source.as4time,
                                  abap_system_timezone( $session.client,'NULL' ),
                                  $session.client,
                                  'FAIL')

            as timestamp )                                                                                              as last_changed_at_utc

}
where
      dddrty_source.as4local  = 'A'
  and dddrty_source.type_kind = 'S'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DDDRTY_SOURCE",
"DDDRTY_SOURCE_T",
"TADIR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More