I_MaintNotifPredictionData

DDL: I_MAINTNOTIFPREDICTIONDATA SQL: IMNTNTIFPRDCTDAT Type: view BASIC

prediction data with RDT

I_MaintNotifPredictionData is a Basic CDS View that provides data about "prediction data with RDT" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceNotification) and exposes 13 fields with key field Notification. It has 3 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceNotification _Notification from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_MaintenanceNotificationItem _NotificationItem $projection.Notification = _NotificationItem.MaintenanceNotification and _NotificationItem.MaintenanceNotificationItem = '0001'
[0..1] I_PMNotifMaintenanceData _Equipment $projection.Notification = _Equipment.MaintenanceNotification
[0..1] I_TextObjectPlainLongText _LongText $projection.Notification = _LongText.TextObjectKey and _LongText.Language = $session.system_language and _LongText.TextObjectType = 'LTXT' and _LongText.TextObjectCategory = 'QMEL'

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMNTNTIFPRDCTDAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
EndUserText.label prediction data with RDT view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Notification I_MaintenanceNotification MaintenanceNotification
NotificationType I_MaintenanceNotification NotificationType
NotificationText I_MaintenanceNotification NotificationText
Equipment _Equipment Equipment
RelevantFunctionalLocation _Equipment RelevantFunctionalLocation
MaintenancePlanningPlant _Equipment MaintenancePlanningPlant
LongText _LongText PlainLongText
MaintNotifObjPrtCode _NotificationItem MaintNotifObjPrtCode
MaintNotifObjPrtCodeGroupName
MaintNotifDamageCodeAndGrpVal
_NotificationItem _NotificationItem
_Equipment _Equipment
_LongText _LongText 
@AbapCatalog.sqlViewName: 'IMNTNTIFPRDCTDAT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@EndUserText.label: 'prediction data with RDT'
define view I_MaintNotifPredictionData
  as select from I_MaintenanceNotification as _Notification
  association [0..1] to I_MaintenanceNotificationItem as _NotificationItem on  $projection.Notification                      = _NotificationItem.MaintenanceNotification
                                                                           and _NotificationItem.MaintenanceNotificationItem = '0001'
  association [0..1] to I_PMNotifMaintenanceData      as _Equipment        on  $projection.Notification = _Equipment.MaintenanceNotification
  association [0..1] to I_TextObjectPlainLongText     as _LongText         on  $projection.Notification     = _LongText.TextObjectKey
                                                                           and _LongText.Language           = $session.system_language
                                                                           and _LongText.TextObjectType     = 'LTXT'
                                                                           and _LongText.TextObjectCategory = 'QMEL'
{
  key _Notification.MaintenanceNotification                                                                              as Notification,
      _Notification.NotificationType                                                                                     as NotificationType,
      _Notification.NotificationText                                                                                     as NotificationText,
      _Equipment.Equipment                                                                                               as Equipment,
      _Equipment.RelevantFunctionalLocation                                                                              as RelevantFunctionalLocation,
      _Equipment.MaintenancePlanningPlant                                                                                as MaintenancePlanningPlant,
      _LongText.PlainLongText                                                                                            as LongText,
      _NotificationItem.MaintNotifObjPrtCode                                                                             as MaintNotifObjPrtCode,
      concat_with_space( _NotificationItem.MaintNotifObjPrtCode,  _NotificationItem.MaintNotifObjPrtCodeGroup, 1) as MaintNotifObjPrtCodeGroupName,
      concat_with_space( _NotificationItem.MaintNotificationDamageCode,  _NotificationItem.MaintNotifDamageCodeGroup, 1) as MaintNotifDamageCodeAndGrpVal,
      _NotificationItem,
      _Equipment,
      _LongText
}
where
  (
          _NotificationItem.MaintenanceNotificationItem is null
    or(
          _NotificationItem.MaintenanceNotificationItem =  '0001'))
  and     _Notification.NotificationText                <> ' '
  and     _Notification.LongTextLanguage                = $session.system_language
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCENOTIFICATION",
"I_MAINTENANCENOTIFICATIONITEM",
"I_PMNOTIFMAINTENANCEDATA",
"I_TEXTOBJECTPLAINLONGTEXT"
],
"ASSOCIATED":
[
"I_MAINTENANCENOTIFICATIONITEM",
"I_PMNOTIFMAINTENANCEDATA",
"I_TEXTOBJECTPLAINLONGTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More