P_USERSETGETPARAMFORCTRLGAREA

CDS View

P_USERSETGETPARAMFORCTRLGAREA is a CDS View in S/4HANA. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_UserSetGetParamForCtrlgArea view from BASIC User Parameter for Controlling Area

Fields (2)

KeyField CDS FieldsUsed in Views
KEY BusinessUser BusinessUser 1
ControllingArea ControllingArea 1 
@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