C_JobListStatusVH

DDL: C_JOBLISTSTATUSVH SQL: CJOBLISTSTATS Type: view CONSUMPTION

Job List Status Value Help

C_JobListStatusVH is a Consumption CDS View that provides data about "Job List Status Value Help" in SAP S/4HANA. It reads from 1 data source (I_EAMOverallStatus) and exposes 3 fields with key fields EAMOverallStatus, EAMOverallStatusProfile.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_EAMOverallStatus I_EAMOverallStatus from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CJOBLISTSTATS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Job List Status Value Help view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY EAMOverallStatus
KEY EAMOverallStatusProfile
EAMOverallStatusDescription _EAMOverallStatusText EAMOverallStatusDescription 
@AbapCatalog.sqlViewName: 'CJOBLISTSTATS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Job List Status Value Help'
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #S, dataClass: #MASTER}
@VDM.viewType: #CONSUMPTION

define view C_JobListStatusVH
  as select from I_EAMOverallStatus
  association to I_EAMOverallStatusText as _EAMOverallStatusText on _EAMOverallStatusText.EAMOverallStatusProfile = I_EAMOverallStatus.EAMOverallStatusProfile
                                                                 and _EAMOverallStatusText.EAMOverallStatus = I_EAMOverallStatus.EAMOverallStatus
                                                                 and _EAMOverallStatusText.Language = $session.system_language
{

      @UI.textArrangement: #TEXT_ONLY
      @ObjectModel.text.element: ['EAMOverallStatusDescription']
  key max( I_EAMOverallStatus.EAMOverallStatus ) as EAMOverallStatus,

      @UI.hidden: true
  key min( I_EAMOverallStatus.EAMOverallStatusProfile ) as EAMOverallStatusProfile,

      _EAMOverallStatusText.EAMOverallStatusDescription

}
where I_EAMOverallStatus.EAMOverallStatusEntity = 'OVG'
  and I_EAMOverallStatus.EAMOverallStatusProfile = 'MAINTJOB'  //Note 3346579

  and _Condition [1: EAMOverallStatusConditionGroup = 1 and EAMOverallStatusConditionCntr = 1].EAMOverallStatusConditionGroup is not null
  group by _EAMOverallStatusText.EAMOverallStatusDescription
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EAMOVERALLSTATUS",
"I_EAMOVERALLSTATUSCONDITION",
"I_EAMOVERALLSTATUSTEXT"
],
"ASSOCIATED":
[
"I_EAMOVERALLSTATUSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More