ars_v_implicit_c3_tables

DDL: ARS_V_IMPLICIT_C3_TABLES Type: view_entity

API Release: Tables implicitly stable for C3

ars_v_implicit_c3_tables is a CDS View that provides data about "API Release: Tables implicitly stable for C3" in SAP S/4HANA. It reads from 2 data sources (dd02l, ars_u_tabs_in_logtrans) and exposes 2 fields with key fields object_type, object_name.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
dd02l dd02l from
ars_u_tabs_in_logtrans logtab inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label API Release: Tables implicitly stable for C3 view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY object_type
KEY object_name dd02l tabname 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'API Release: Tables implicitly stable for C3'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity ars_v_implicit_c3_tables
  as select from dd02l
    inner join   ars_u_tabs_in_logtrans as logtab on logtab.TableName = dd02l.tabname
  association to ARS_V_C3_RELEASED_TABLES as stable_api on stable_api.object_name = dd02l.tabname
{

  key    'TABL'        as object_type,
  key    dd02l.tabname as object_name,
  key    'TABL'        as sub_object_type,
  key    dd02l.tabname as sub_object_name
}
where
       dd02l.as4local         = 'A'
  and  dd02l.as4vers          = '0000'
  and  dd02l.clidep           = 'X'
  and  dd02l.tabclass         = 'TRANSP'
  and(
       dd02l.contflag         = 'C'
    or dd02l.contflag         = 'E'
    or dd02l.contflag         = 'G'
  )
  and  stable_api.object_name is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ARS_U_TABS_IN_LOGTRANS",
"ARS_V_C3_RELEASED_TABLES",
"DD02L"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More