APS_SEC_MTS_TRUST_CDOC_GEN

DDL: APS_SEC_MTS_TRUST_CDOC_GEN Type: view_entity Package: SR_APS_SEC_MTS_ODATA

CSP Trust Change Logs

APS_SEC_MTS_TRUST_CDOC_GEN is a CDS View that provides data about "CSP Trust Change Logs" in SAP S/4HANA. It reads from 3 data sources (t100, t100, http_log_trusts) and exposes 9 fields with key field SortKey. It has 1 association to related views. Part of development package SR_APS_SEC_MTS_ODATA.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
t100 _Text_Created left_outer
t100 _Text_Deleted left_outer
http_log_trusts cdoc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] aps_user_ddl _user cdoc.username = _user.UserID

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CSP Trust Change Logs view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SortKey http_log_trusts sort_key
Namespace http_log_trusts namespace
TrustedSiteList http_log_trusts trusted_site_list
Content http_log_trusts content
Action http_log_trusts action
ChangedBy http_log_trusts username
ChangedAt http_log_trusts time
textelseendasActionText
ChangedByName _user UserDescription 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CSP Trust Change Logs'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #M,
  dataClass: #MIXED
}

define view entity APS_SEC_MTS_TRUST_CDOC_GEN
  as select from    http_log_trusts as cdoc

    left outer join t100            as _Text_Created on  _Text_Created.sprsl = $session.system_language
                                                     and _Text_Created.arbgb = 'CM_APS_SEC_MTS_CDS'
                                                     and _Text_Created.msgnr = '000'

    left outer join t100            as _Text_Deleted on  _Text_Deleted.sprsl = $session.system_language
                                                     and _Text_Deleted.arbgb = 'CM_APS_SEC_MTS_CDS'
                                                     and _Text_Deleted.msgnr = '001'

  association [0..1] to aps_user_ddl as _user on cdoc.username = _user.UserID

{
  key cdoc.sort_key          as SortKey,
      cdoc.namespace         as Namespace,
      cdoc.trusted_site_list as TrustedSiteList,
      cdoc.content           as Content,
      cdoc.action            as Action,

      cdoc.username          as ChangedBy,
      cdoc.time              as ChangedAt,

      case $projection.Action
        when 'A' then _Text_Created.text
        when 'D' then _Text_Deleted.text
        else ''
      end                    as ActionText,

      _user.UserDescription  as ChangedByName
}
where
  cdoc.namespace = 'C'

Learn More