P_USERSETGETPARAMFORCTRLGAREA
User Set Get Parameter for Controlling Area
P_USERSETGETPARAMFORCTRLGAREA is a CDS View in S/4HANA. User Set Get Parameter for Controlling Area. It contains 2 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_UserSetGetParamForCtrlgArea | view | from | BASIC | User Parameter for Controlling Area |
Fields (2)
| Key | Field | CDS Fields | Used 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
}