VB_DEPRECATED_STATUS

DDL: VB_DEPRECATED_STATUS SQL: VBDEPRECATED Type: view Package: S_DICT_VB

Views with statuses for cloud

VB_DEPRECATED_STATUS is a CDS View that provides data about "Views with statuses for cloud" in SAP S/4HANA. It reads from 1 data source (ddddlsrc) and exposes 3 fields with key field DDLSourceName. Part of development package S_DICT_VB.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
ddddlsrc AllViews from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName VBDEPRECATED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Views with statuses for cloud view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName ddddlsrc ddlname
stateendasCDSViewStatus
stateendasCDSViewStatusCloud 
@AbapCatalog.sqlViewName: 'VBDEPRECATED'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality:  #C
@ObjectModel.usageType.sizeCategory:  #L
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Views with statuses for cloud'
define view VB_DEPRECATED_STATUS as select from ddddlsrc as AllViews

left outer to one join ARS_APIS_RELEASED_C1_ALL_OR_GR  as Cds_Release_Status  
                                  on  AllViews.ddlname    = Cds_Release_Status.tadir_obj_name
                                  and Cds_Release_Status.tadir_object = 'DDLS' // Status will be Released or Deprecated only if this flag is true

{
   key AllViews.ddlname as DDLSourceName,
    
    case when Cds_Release_Status.use_in_key_user_apps = 'X'
      then  Cds_Release_Status.state 
      end as CDSViewStatus, // Released or Deprecated based on use in key user apps

  
    case when Cds_Release_Status.use_in_cloud_development = 'X'
      then  Cds_Release_Status.state 
      end as CDSViewStatusCloud // Released or Deprecated based on use in cloud development

} where AllViews.as4local = 'A' and ( AllViews.source_type = 'V' or AllViews.source_type = 'W' )

Learn More