C_JobListStatusVH

DDL: C_JOBLISTSTATUSVH Type: view_entity CONSUMPTION Package: ODATA_EAM_MALFUNCTION_MANAGE

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. Part of development package ODATA_EAM_MALFUNCTION_MANAGE.

Data Sources (1)

SourceAliasJoin Type
I_EAMOverallStatus I_EAMOverallStatus from

Annotations (6)

NameValueLevelField
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
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Job List Status Value Help'
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #S, dataClass: #MASTER}
@VDM.viewType: #CONSUMPTION

define view entity 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 _Condition [1: EAMOverallStatusConditionGroup = 1 and EAMOverallStatusConditionCntr = 1].EAMOverallStatusConditionGroup is not null
  group by _EAMOverallStatusText.EAMOverallStatusDescription