Rv_P_User

DDL: RV_P_USER SQL: RVPUSER Type: view Package: RSVP

User

Rv_P_User is a CDS View of category Dimension that provides data about "User" in SAP S/4HANA. It reads from 2 data sources (adrp, usr21) and exposes 8 fields with key field userName. Part of development package RSVP.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
adrp adrp left_outer
usr21 usr21 from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName RVPUSER view
Analytics.dataCategory #DIMENSION view
ObjectModel.representativeKey userName view
ClientDependent true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY userName usr21 bname
personNumber usr21 persnumber
description usr21 techdesc
lastName adrp name_last
fullName adrp name_text
firstNameUpper adrp mc_namefir
lastNameUpper adrp mc_namelas
counter 
//@RV.viewType: #COMPOSITE

//@RV.private:  true


@AbapCatalog.sqlViewName: 'RVPUSER' // 7

@Analytics.dataCategory: #DIMENSION
@ObjectModel.representativeKey: 'userName'
@ClientDependent: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.compiler.compareFilter: true

// This view must be private due to authorizations

define view Rv_P_User 
(
    userName,
    
    personNumber,
    description, // is filled if the description field in SU01 is maintained

    lastName,
    fullName,
    firstNameUpper,
    lastNameUpper,
    
    counter
)
as 
select from usr21
left outer join adrp on usr21.persnumber = adrp.persnumber
{
    @ObjectModel.text.element: 'fullName' 
    key usr21.bname as userName, 
    
    usr21.persnumber as personNumber,
    usr21.techdesc as description, 
    adrp.name_last as lastName, 
    adrp.name_text as fullName,
    adrp.mc_namefir as firstNameUpper,
    adrp.mc_namelas as lastNameUpper,
    
    @DefaultAggregation: #SUM
    cast(cast(1 as abap.int4) as rvcounter) as counter   
}

Learn More