I_USERSETGETPARAMFORCTRLGAREA

CDS View

User Parameter for Controlling Area

I_USERSETGETPARAMFORCTRLGAREA is a CDS View in S/4HANA. User Parameter for Controlling Area. 4 CDS views read from this table.

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_RealTimeOrderCount view inner CONSUMPTION Event Based Order Real Time KPI Count
P_ServiceDocLinItmFinData view inner COMPOSITE
P_SrvcContrFinance view inner COMPOSITE
P_SrvcDocIntOrdFinData view inner COMPOSITE 
@ObjectModel.representativeKey: 'BusinessUser'

@ObjectModel.supportedCapabilities: [ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
@ObjectModel.modelingPattern:  #ANALYTICAL_DIMENSION 

@ObjectModel.usageType: {
  dataClass: #MIXED,
  serviceQuality: #B,
  sizeCategory: #M
}
@AbapCatalog.sqlViewName: 'IFIUSRPARMCTRLGA'
@Analytics: { dataCategory: #DIMENSION } //,dataExtraction.enabled: true }

@VDM.viewType: #BASIC
@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'User Parameter for Controlling Area'
@AccessControl.authorizationCheck: #NOT_REQUIRED //PRIVILEGED_ONLY

@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_UserSetGetParamForCtrlgArea as select from P_Usersetgetparamforctrlgarea
left outer join I_ControllingArea on I_ControllingArea.ControllingArea = P_Usersetgetparamforctrlgarea.ControllingArea
{
    
key P_Usersetgetparamforctrlgarea.BusinessUser,
P_Usersetgetparamforctrlgarea.ControllingArea,
I_ControllingArea.CtrlgStdFinStatementVersion,
I_ControllingArea.FiscalYearVariant
//cast( case when P_Usersetgetparamforctrlgarea.ControllingArea is null 

//  then 'A000'

//  else P_Usersetgetparamforctrlgarea.ControllingArea

//end as kokrs )as ControllingArea


} 

where P_Usersetgetparamforctrlgarea.BusinessUser = $session.user

Learn More