PSM_AVC_SPONSORED_CLASS_BASIC

DDL: PSM_AVC_SPONSORED_CLASS_BASIC SQL: PSMAVCSCBASIC Type: view

Basic Sponsored Class View for Hierarchy

PSM_AVC_SPONSORED_CLASS_BASIC is a CDS View that provides data about "Basic Sponsored Class View for Hierarchy" in SAP S/4HANA. It reads from 2 data sources (hrrp_node, hrrp_attr_node).

2 data source(s)

Data Sources (2)

SourceAliasJoin Type
hrrp_node node left_outer
hrrp_attr_node node_attr left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PSMAVCSCBASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Basic Sponsored Class View for Hierarchy view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view 
@AbapCatalog.sqlViewName: 'PSMAVCSCBASIC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Basic Sponsored Class View for Hierarchy'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE

define view PSM_AVC_SPONSORED_CLASS_BASIC
  as select
    profile.profile        as AVCProfile,
    node.hrynode           as SponsoredClassNode,
    node.parnode           as SponsoredClassParent,
    node.nodevalue         as SponsoredClass,
    node.hrylevel          as HryLevel,
    node_attr.hryattrvalue as IsCheckLevel,
    node.hryid             as HryId,
    node.nodetype          as NodeType

  from              psm_d_avc_prf_gr as profile
    left outer join hrrp_node        as node      on profile.hryid = node.hryid
    left outer join hrrp_attr_node   as node_attr on  node.hryid            = node_attr.hryid
                                                  and node.hrynode          = node_attr.hrynode
                                                  and node_attr.hryattrname = 'ISCHECKLEVEL'
  where
        profile.fieldname_acdoca = 'RSPNSRD_CL'
    and profile.relation_type    = 'H'
    and not node.nodetype        = 'D'
    and node.hryvalfrom         <= $session.system_date
    and node.hryvalto           >= $session.system_date
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRRP_ATTR_NODE",
"HRRP_NODE",
"PSM_D_AVC_PRF_GR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More