DDCDS_DRTY_INFO

DDL: DDCDS_DRTY_INFO Type: view_entity Package: SD_CDS_TYPES

CDS Simple Type Information

DDCDS_DRTY_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) and exposes 1 field. It has 3 associations to related views. Part of development package SD_CDS_TYPES.

2 data source(s) 1 fields

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

Fields (1)

KeyFieldSource TableSource FieldDescription
type_kind dddrty_source type_kind 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CDS Simple Type Information'
define view entity DDCDS_DRTY_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   dddrty_source.type_name                                                                                                    as simple_type_name,
        dddrty_source.type_kind                                                                                                    as type_kind,
        @EndUserText.label: 'Short Description'
        cast( coalesce( coalesce( _text_active.ddtext, _text_english.ddtext ), _text_original.ddtext ) as ddtext )                 as short_description,
        cast( coalesce( coalesce( _text_active.ddlanguage, _text_english.ddlanguage ), _text_original.ddlanguage ) as 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,
        dddrty_source.as4date                                                                                                      as last_changed_at_date,
        dddrty_source.as4time                                                                                                      as last_changed_at_time


}
where
      dddrty_source.as4local  = 'A'
  and dddrty_source.type_kind = 'S'

Learn More