smtr_cus_tt_database_table

DDL: SMTR_CUS_TT_DATABASE_TABLE Type: view_entity

MTR Customizing Text Table: DBT

smtr_cus_tt_database_table is a CDS View that provides data about "MTR Customizing Text Table: DBT" in SAP S/4HANA. It reads from 2 data sources (ARS_OBJECTS_ALL_SW_COMP_SCP, SMTR_TT_DATABASE_TABLE) and exposes 1 field with key field name.

2 data source(s) 1 fields

Data Sources (2)

SourceAliasJoin Type
ARS_OBJECTS_ALL_SW_COMP_SCP CustomerObject inner
SMTR_TT_DATABASE_TABLE DatabaseTable from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MTR Customizing Text Table: DBT view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY name SMTR_TT_DATABASE_TABLE name 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'MTR Customizing Text Table: DBT'
define root view entity smtr_cus_tt_database_table
  as select from SMTR_TT_DATABASE_TABLE      as DatabaseTable
    inner join   ARS_OBJECTS_ALL_SW_COMP_SCP as CustomerObject on  CustomerObject.program_id  = 'R3TR'
                                                               and CustomerObject.object_type = 'TABL'
                                                               and CustomerObject.object_name = DatabaseTable.name
{
  key DatabaseTable.name
}
where
  DatabaseTable.deliveryClass = 'C'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ARS_OBJECTS_ALL_SW_COMP_SCP",
"SMTR_TT_DATABASE_TABLE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More