CDS_SUI_TM_MM_CAT

DDL: CDS_SUI_TM_MM_CAT SQL: SUI_TM_MM_CAT_V Type: view Package: SUI_COMMON

CDS View for Catalogs - deprecated

CDS_SUI_TM_MM_CAT is a CDS View that provides data about "CDS View for Catalogs - deprecated" in SAP S/4HANA. It reads from 3 data sources (sui_tm_mm_cat, sui_tm_mm_catt, tadir) and exposes 9 fields with key field id. Part of development package SUI_COMMON.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
sui_tm_mm_cat sui_tm_mm_cat from
sui_tm_mm_catt sui_tm_mm_catt left_outer
tadir tadir left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SUI_TM_MM_CAT_V view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label CDS View for Catalogs - deprecated view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY id sui_tm_mm_cat id
type sui_tm_mm_cat type
langu sui_tm_mm_catt langu
title sui_tm_mm_catt title
changed_at
changed_by sui_tm_mm_cat changed_by
author tadir author
created_on tadir created_on
devclass tadir devclass 
@AbapCatalog.sqlViewName: 'SUI_TM_MM_CAT_V'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'CDS View for Catalogs - deprecated'
define view CDS_SUI_TM_MM_CAT 
( id, type, langu, title, changed_at, changed_by,
  author, created_on, devclass )
as select from sui_tm_mm_cat 
          left outer join sui_tm_mm_catt on sui_tm_mm_cat.id = sui_tm_mm_catt.id   
                                         and  sui_tm_mm_catt.langu = $session.system_language  //'E'  

          left outer join tadir on  tadir.pgmid  = 'R3TR'      
                                and tadir.object = 'UIAC'      
                                and tadir.obj_name = sui_tm_mm_cat.id                                                   
{ key sui_tm_mm_cat.id,
  sui_tm_mm_cat.type,
  sui_tm_mm_catt.langu,
  sui_tm_mm_catt.title,
  tstmp_to_dats( sui_tm_mm_cat.changed_at, abap_system_timezone( $session.client,'NULL' ), $session.client,'NULL' ) as changed_at,
  sui_tm_mm_cat.changed_by,
  tadir.author,
  tadir.created_on,
  tadir.devclass
}

Learn More