C_ChangeRecordNextStatusVH

DDL: C_CHANGERECORDNEXTSTATUSVH SQL: CCRNEXTSTATVH Type: view CONSUMPTION

Value help for next status

C_ChangeRecordNextStatusVH is a Consumption CDS View that provides data about "Value help for next status" in SAP S/4HANA. It reads from 1 data source (I_ChangeRecordNextStatusVH) and exposes 8 fields with key fields ChangeRecordType, ChangeRecordStatus, ChangeRecordNextStatus, ChangeRecordStatusAction. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChangeRecordNextStatusVH user_status from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_ChangeRecordTypeVH _ChangeRecordTypeVH $projection.ChangeRecordType = _ChangeRecordTypeVH.ChangeRecordType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCRNEXTSTATVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
EndUserText.label Value help for next status view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordType I_ChangeRecordNextStatusVH ChangeRecordType Record Type
KEY ChangeRecordStatus I_ChangeRecordNextStatusVH ChangeRecordStatus Current Status
KEY ChangeRecordNextStatus ChangeRecordNextStatus Target Status
KEY ChangeRecordStatusAction ChangeRecordStatusAction Status Action
ChangeRecordStatusProfile ChangeRecordStatusProfile Status Profile
ChangeRecordStatusDescription
ChangeRecordStatusActionText I_ChangeRecordNextStatusVH ChangeRecordStatusActionText
_ChangeRecordTypeVH _ChangeRecordTypeVH
@AbapCatalog.sqlViewName: 'CCRNEXTSTATVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@EndUserText.label: 'Value help for next status'

@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #S
}
@ClientHandling.algorithm: #SESSION_VARIABLE
define view C_ChangeRecordNextStatusVH
  as select from I_ChangeRecordNextStatusVH as user_status
  association [0..1] to C_ChangeRecordTypeVH as _ChangeRecordTypeVH on $projection.ChangeRecordType = _ChangeRecordTypeVH.ChangeRecordType

{

          @Search.defaultSearchElement: true
          @ObjectModel.foreignKey.association: '_ChangeRecordTypeVH'
          @EndUserText.label: 'Record Type'
          @Consumption.filter.hidden: true
  key     user_status.ChangeRecordType,
          @Search.defaultSearchElement: true
          @Search.ranking: #HIGH
          @Search.fuzzinessThreshold: 0.8
          @ObjectModel.text.element: 'ChangeRecordStatusDescription'
          @EndUserText.label: 'Current Status'
  key     user_status.ChangeRecordStatus,

          @EndUserText.label: 'Target Status'
          //@ObjectModel.virtualElement : true

          //@ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_NEXTSTATUS_AUTH'

  key     ChangeRecordNextStatus,
          @EndUserText.label: 'Status Action'
  key     ChangeRecordStatusAction,
          @EndUserText.label: 'Status Profile'
          @UI.hidden: true
          ChangeRecordStatusProfile,
          // Next Status Description

          //@UI.hidden: true

          cast(ChangeRecordStatusDescription as /plmb/cr_hdr_status_desc) as ChangeRecordStatusDescription,
          user_status.ChangeRecordStatusActionText,
          _ChangeRecordTypeVH
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGERECORDNEXTSTATUSVH"
],
"ASSOCIATED":
[
"C_CHANGERECORDTYPEVH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/