R_CashPositionUserSetting

DDL: R_CASHPOSITIONUSERSETTING Type: view_entity BASIC

User Settings for Cash Position

R_CashPositionUserSetting is a Basic CDS View that provides data about "User Settings for Cash Position" in SAP S/4HANA. It reads from 1 data source (usr05) and exposes 1 field with key field UserParameter.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
usr05 param from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label User Settings for Cash Position view
ObjectModel.representativeKey UserParameter view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY UserParameter usr05 parid 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'User Settings for Cash Position'
@ObjectModel.representativeKey: 'UserParameter'
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@VDM.viewType:#BASIC
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #MASTER
}
define view entity R_CashPositionUserSetting
  as select from usr05 as param
{
  key      param.parid                                                           as UserParameter,

           cast( case when  param.parid = 'FCLM_CP_SCALING'
                 and param.parva is not initial
                 and substring(param.parva,1, 1) = 'X'
                 then 'X' end as fclm_cp_customsclngenabled)                     as CshPosCustomScalingIsEnabled,

           cast(case when  param.parid = 'FCLM_CP_SCALING'
                and param.parva is not initial
                and ( cast(substring(param.parva, 2, 3) as int1 ) between 0 and 9 )
                then substring(param.parva, 2,3) end as fclm_cp_scaling_factor)  as CashPositionScalingFactor,

           cast ( case when param.parid = 'FCLM_CP_SCALING'
                 and param.parva is not initial
                 then substring( param.parva , 5 , 3 ) end as fclm_cp_currdec  ) as CshPosCstmSclngNmbrOfDcmlPlace
}
where
      param.parid = 'FCLM_CP_SCALING'
  and param.bname = $session.user

Learn More