P_Usersetgetparamforctrlgarea

DDL: P_USERSETGETPARAMFORCTRLGAREA SQL: PFIUSRPARMCTRLGA Type: view BASIC Package: FINS_FIS_FICO

User Set Get Parameter for Controlling Area

P_Usersetgetparamforctrlgarea is a Basic CDS View that provides data about "User Set Get Parameter for Controlling Area" in SAP S/4HANA. It reads from 2 data sources (I_User, usr05) and exposes 2 fields with key field BusinessUser. Part of development package FINS_FIS_FICO.

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

}

Learn More