QB_V2_V3_QUERY

DDL: QB_V2_V3_QUERY SQL: QB_V2V3_QUERY Type: view Package: RS_ANA_QB

Get direct base objects

QB_V2_V3_QUERY is a CDS View that provides data about "Get direct base objects" in SAP S/4HANA. It reads from 5 data sources (Cds_View_Annotation_Position, dd02bnd, DDCDS_DIRECT_BASE_OBJECTS_V2, ddddlsrc, DDCDS_DIRECT_BASE_OBJECTS_V2) and exposes 11 fields with key field ObjectDDLSourceName. Part of development package RS_ANA_QB.

5 data source(s) 11 fields

Data Sources (5)

SourceAliasJoin Type
Cds_View_Annotation_Position CDSAnalyticType inner
dd02bnd StructuredNodes inner
DDCDS_DIRECT_BASE_OBJECTS_V2 V2_Views union_all
ddddlsrc V3_Query from
DDCDS_DIRECT_BASE_OBJECTS_V2 ViewBaseObject inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName QB_V2V3_QUERY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Get direct base objects view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ObjectDDLSourceName DDCDS_DIRECT_BASE_OBJECTS_V2 entity_name
state DDCDS_DIRECT_BASE_OBJECTS_V2 state
ReferredObject DDCDS_DIRECT_BASE_OBJECTS_V2 direct_base_object_name
ReferredObjectType DDCDS_DIRECT_BASE_OBJECTS_V2 direct_base_object_type
InAServiceName InAqueries serviceBindingName
entity_nameasObjectDDLSourceName
state DDCDS_DIRECT_BASE_OBJECTS_V2 state
ReferredObject DDCDS_DIRECT_BASE_OBJECTS_V2 direct_base_object_name
ReferredObjectType DDCDS_DIRECT_BASE_OBJECTS_V2 direct_base_object_type
InAServiceName
source_type V2_Query source_type 
@AbapCatalog.sqlViewName: 'QB_V2V3_QUERY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality:  #D
@ObjectModel.usageType.sizeCategory:  #L
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Get direct base objects'
define view QB_V2_V3_QUERY
  as
  // V3 queries

  select from              ddddlsrc                      as V3_Query
    inner join             dd02bnd                       as StructuredNodes on  StructuredNodes.strucobjn         = V3_Query.ddlname
                                                                            and StructuredNodes.provider_contract = 'AQ'
    inner join             DDCDS_DIRECT_BASE_OBJECTS_V2  as ViewBaseObject  on ViewBaseObject.entity_name = V3_Query.ddlname
    left outer to one join RSRTS_SRVB_SRVD_CDS_RELEATION as InAqueries      on V3_Query.ddlname = InAqueries.CDSViewName
{

  key ViewBaseObject.entity_name             as ObjectDDLSourceName,
      ViewBaseObject.state,
      ViewBaseObject.direct_base_object_name as ReferredObject,
      ViewBaseObject.direct_base_object_type as ReferredObjectType,
      ViewBaseObject.primary_data_source,
      InAqueries.serviceBindingName          as InAServiceName,
      V3_Query.source_type

}
where
       ViewBaseObject.primary_data_source     = 'X'
  and(
       ViewBaseObject.direct_base_object_type = 'STOB'
    or ViewBaseObject.direct_base_object_type = 'VIEW'
  )
  and  V3_Query.source_type                   = 'P'
  and  V3_Query.as4local                      = 'A'

union all
// V2 Queries

select from  DDCDS_DIRECT_BASE_OBJECTS_V2 as V2_Views
  inner join Cds_View_Annotation_Position 
  as CDSAnalyticType on  V2_Views.entity_name            = CDSAnalyticType.CDSName
                                                             and CDSAnalyticType.AnnotationName  = 'ANALYTICS.QUERY'
                                                             and CDSAnalyticType.AnnotationValue = 'true'
  association[0..1] to ddddlsrc                      as V2_Query  on    $projection.ObjectDDLSourceName = V2_Query.ddlname
                                                                        and V2_Query.as4local                      = 'A'                                                        
{

  key V2_Views.entity_name             as ObjectDDLSourceName,
      V2_Views.state,
      V2_Views.direct_base_object_name as ReferredObject,
      V2_Views.direct_base_object_type as ReferredObjectType,
      V2_Views.primary_data_source,
      ''                               as InAServiceName,
      V2_Query.source_type      

}
where
       V2_Views.primary_data_source     = 'X'
  and(
       V2_Views.direct_base_object_type = 'STOB'
    or V2_Views.direct_base_object_type = 'VIEW'
  )

Learn More