P_Usersetgetparamforctrlgarea

DDL: P_USERSETGETPARAMFORCTRLGAREA SQL: PFIUSRPARMCTRLGA Type: view BASIC

P_Usersetgetparamforctrlgarea is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_User, usr05) and exposes 2 fields with key field BusinessUser.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_User I_User from
usr05 usr05 left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PFIUSRPARMCTRLGA view
ClientDependent true view
VDM.viewType #BASIC view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY BusinessUser UserID
parvaendaskokrsasControllingArea 
@AbapCatalog.sqlViewName: 'PFIUSRPARMCTRLGA'
@ClientDependent: true
@VDM.viewType: #BASIC
@VDM.private:true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'User Set Get Parameter for Controlling Area'

define view P_Usersetgetparamforctrlgarea as select from I_User 

    left outer join usr05 as usr05 
        on  I_User.UserID = usr05.bname
        and usr05.parid = 'CAC'
{
key UserID as BusinessUser,
cast( case when usr05.parva is null 
  then 'A000'
  else usr05.parva
end as kokrs )as ControllingArea
//usr05.parva as ControllingArea

}
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_USER",
"USR05"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More