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. It is exposed through 1 OData service (UI_C_DFS_ALLWNCPLAN). It is used in 1 Fiori application: Manage Allowance Plans.

2 data source(s) Exposed by 1 service(s) Used in 1 Fiori app(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

OData Services (1)

ServiceBindingVersionContractRelease
UI_C_DFS_ALLWNCPLAN UI_C_DFS_ALLWNCPLAN V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4662 Manage Allowance Plans Transactional The allowance enables force element structures to request authorized materials or products over a time period without influencing the current force planning.

Manage Allowance Plans

Business Role: Material Planner - Authorized Materials

The allowance enables force element structures to request authorized materials or products over a time period without influencing the current force planning. An allowance is divided up into a request and a plan. The request is used to place enquiries for quantities and the plan is a preliminary planning process in which quantities are limited for force element structures over a time period. The result is available in the force planning process.

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'

Learn More