I_SWF_SWD_APIS_RELEASED_FOR_C1

DDL: I_SWF_SWD_APIS_RELEASED_FOR_C1 Type: view_entity Package: SWD_CDS_USER_ATTR

CDS Based Customer Attributes: C1 Released APIs

I_SWF_SWD_APIS_RELEASED_FOR_C1 is a CDS View that provides data about "CDS Based Customer Attributes: C1 Released APIs" in SAP S/4HANA. It reads from 4 data sources (ARS_APIS_RELEASED_FOR_C1_SCP, ARS_APIS_RELEASED_FOR_C1_SCP, ARS_APIS_RELEASED_FOR_C1, ARS_APIS_RELEASED_FOR_C1) and exposes 6 fields with key field tadir_object. Part of development package SWD_CDS_USER_ATTR.

4 data source(s) 6 fields

Data Sources (4)

SourceAliasJoin Type
ARS_APIS_RELEASED_FOR_C1_SCP forCloudDevelopment left_outer
ARS_APIS_RELEASED_FOR_C1_SCP forCloudDevelopment union_all
ARS_APIS_RELEASED_FOR_C1 forKeyUser from
ARS_APIS_RELEASED_FOR_C1 forKeyUser left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS Based Customer Attributes: C1 Released APIs view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY tadir_object ARS_APIS_RELEASED_FOR_C1 tadir_object
forKeyUser
forCloudDevelopment
forKeyUser
forCloudDevelopment
releaseState ARS_APIS_RELEASED_FOR_C1_SCP state 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CDS Based Customer Attributes: C1 Released APIs'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity I_SWF_SWD_APIS_RELEASED_FOR_C1
  as select from    ARS_APIS_RELEASED_FOR_C1     as forKeyUser
    left outer join ARS_APIS_RELEASED_FOR_C1_SCP as forCloudDevelopment on  forCloudDevelopment.tadir_object   = forKeyUser.tadir_object
                                                                        and forCloudDevelopment.tadir_obj_name = forKeyUser.tadir_obj_name
{
  key forKeyUser.tadir_object                                                 as tadir_object,
  key forKeyUser.tadir_obj_name                                               as tadir_obj_name,
      'X'                                                                     as forKeyUser,
      case when forCloudDevelopment.tadir_object is null then '' else 'X' end as forCloudDevelopment,
      forKeyUser.state                                                        as releaseState
}

union all select from ARS_APIS_RELEASED_FOR_C1_SCP as forCloudDevelopment
  left outer join     ARS_APIS_RELEASED_FOR_C1     as forKeyUser on  forKeyUser.tadir_object   = forCloudDevelopment.tadir_object
                                                                 and forKeyUser.tadir_obj_name = forCloudDevelopment.tadir_obj_name
{
  key forCloudDevelopment.tadir_object   as tadir_object,
  key forCloudDevelopment.tadir_obj_name as tadir_obj_name,
      ''                                 as forKeyUser,
      'X'                                as forCloudDevelopment,
      forCloudDevelopment.state          as releaseState
}
where
  forKeyUser.tadir_object is null

Learn More