C_DFS_UserStatusVH

DDL: C_DFS_USERSTATUSVH SQL: CDFSUSERSTATUSVH Type: view CONSUMPTION

User Status VH

C_DFS_UserStatusVH is a Consumption CDS View that provides data about "User Status VH" in SAP S/4HANA. It reads from 2 data sources (I_DFS_StatusProfile, I_UserStatusText) and exposes 6 fields with key fields UserStatus, StatusProfile.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_DFS_StatusProfile _Mapping inner
I_UserStatusText _UserStatus from

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CDFSUSERSTATUSVH view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label User Status VH view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey UserStatus view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY UserStatus UserStatus External Status Code
KEY StatusProfile I_UserStatusText StatusProfile
UserStatusName UserStatusName User Status Description
DfsUserStatusFormattedName User Status
UserStatusShortName UserStatusShortName User Status
Language Language 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CDFSUSERSTATUSVH'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@EndUserText.label: 'User Status VH'

@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true


@VDM: {
  viewType: #CONSUMPTION
}

@ObjectModel: {
    dataCategory: #VALUE_HELP,
    semanticKey:  [ 'UserStatus' ],
    representativeKey: 'UserStatus',
    usageType.dataClass: #CUSTOMIZING,
    usageType.serviceQuality: #A,
    usageType.sizeCategory: #S  
    }

define view C_DFS_UserStatusVH
  as select from I_UserStatusText    as _UserStatus
    inner join   I_DFS_StatusProfile as _Mapping on _UserStatus.StatusProfile = _Mapping.StatusProfile
{
      @Consumption.filter.hidden: true
      @EndUserText.label: 'External Status Code'
  key UserStatus,
      @Consumption.filter.hidden: true
  key _UserStatus.StatusProfile,
      @Consumption.filter.hidden: true
      @Semantics.text: true
      @EndUserText.label: 'User Status Description'
      UserStatusName,

      @Consumption.filter.hidden: true
      @EndUserText.label: 'User Status'
      CONCAT_WITH_SPACE( UserStatusName, concat( '(', concat( UserStatus, ')' ) ), 1 ) as DfsUserStatusFormattedName,


      @Consumption.filter.hidden: true
      @Semantics.text: true
      @EndUserText.label: 'User Status'
      UserStatusShortName,
      @UI.hidden: true
      @Consumption.filter.hidden: true
      Language                                                                          as Language
}
where
      Language             = $session.system_language
  and StatusObjectCategory = 'FAS'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DFS_STATUSPROFILE",
"I_USERSTATUSTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More