I_REUserStatusVH

DDL: I_REUSERSTATUSVH SQL: IREUSRSTATYVH Type: view BASIC

Real Estate User Status Help

I_REUserStatusVH is a Basic CDS View that provides data about "Real Estate User Status Help" in SAP S/4HANA. It reads from 1 data source (tj30) and exposes 7 fields with key fields UserStatus, StatusProfile. It has 1 association to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
tj30 tj30 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_UserStatusText _UserStatusText $projection.UserStatus = _UserStatusText.UserStatus and $projection.StatusProfile = _UserStatusText.StatusProfile

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IREUSRSTATYVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
ObjectModel.representativeKey UserStatus view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Real Estate User Status Help view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY UserStatus tj30 estat
KEY StatusProfile tj30 stsma
UserStatusName
StatusAuthorizationKey tj30 bersl
StatusSequenceNumber tj30 stonr
StatusDisplayPosition tj30 linep
StatusDisplayPriority tj30 statp 
@AbapCatalog.sqlViewName: 'IREUSRSTATYVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true

@VDM.viewType: #BASIC
@ObjectModel.representativeKey : 'UserStatus'
@ObjectModel.dataCategory: #VALUE_HELP

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@Search.searchable: true

@Consumption.ranked:true 

@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Real Estate User Status Help'
define view I_REUserStatusVH
  as select from tj30

association [0..*] to I_UserStatusText as _UserStatusText
  on  $projection.UserStatus    = _UserStatusText.UserStatus
  and $projection.StatusProfile = _UserStatusText.StatusProfile

{
  @ObjectModel.text.element: ['UserStatusName']
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold : 0.7
  key tj30.estat as UserStatus,
  
  key tj30.stsma  as StatusProfile,
  
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold : 0.7
  @Search.ranking:#HIGH 
  _UserStatusText[1:Language=$session.system_language].UserStatusName as UserStatusName,

  tj30.bersl as StatusAuthorizationKey,

  tj30.stonr as StatusSequenceNumber,
  
  tj30.linep as StatusDisplayPosition,
  
  tj30.statp as StatusDisplayPriority
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_USERSTATUSTEXT",
"TJ30"
],
"ASSOCIATED":
[
"I_USERSTATUSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More