I_MaintNotifTrainingData

DDL: I_MAINTNOTIFTRAININGDATA SQL: IMNTNTIFTRNDAT Type: view BASIC Package: EAM_ML_ORDER_DAMAGE_CODE

Training Data for Model training

I_MaintNotifTrainingData is a Basic CDS View that provides data about "Training Data for Model training" 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. Part of development package EAM_ML_ORDER_DAMAGE_CODE.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceNotification _Notification from

Associations (3)

CardinalityTargetAliasCondition
[1..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 IMNTNTIFTRNDAT 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 Training Data for Model training 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: 'IMNTNTIFTRNDAT'
@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: 'Training Data for Model training'
define view I_MaintNotifTrainingData
  as select from I_MaintenanceNotification as _Notification
  association [1..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 =  '0001'
  and _Notification.NotificationText                <> ' '
  and _NotificationItem.MaintNotificationDamageCode <> ' '
  and _NotificationItem.MaintNotifDamageCodeGroup   <> ' '
  and _Notification.LongTextLanguage                = $session.system_language

Learn More