I_DFS_MaintNotificationTechSts

DDL: I_DFS_MAINTNOTIFICATIONTECHSTS SQL: IDFSNOTIFTECH Type: view COMPOSITE

Interface view for Tech Status of Notif

I_DFS_MaintNotificationTechSts is a Composite CDS View that provides data about "Interface view for Tech Status of Notif" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceNotification) and exposes 12 fields. It has 1 association to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceNotification _MaintenanceNotification from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_StatusObjectActiveStatus _MaintNotifTechSts _MaintNotifTechSts.StatusObject = _MaintenanceNotification.DfsMaintNotificationObjectNmbr

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IDFSNOTIFTECH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Interface view for Tech Status of Notif view

Fields (12)

KeyFieldSource TableSource FieldDescription
MaintenanceNotification I_MaintenanceNotification MaintenanceNotification
DfsMaintNotificationObjectNmbr I_MaintenanceNotification DfsMaintNotificationObjectNmbr
Equipment
FunctionalLocation
MaintNotifInternalID I_MaintenanceNotification MaintNotifInternalID
DfsMaintNotifTechStatus _MaintNotifTechSts StatusCode
DfsMaintNotifTechStsShortName
DfsMaintNotifTechStsLongName
DfsMaintNotifTechStatusProfile
DfsMaintNotifTechStsPrflName
NotifProcessingPhase I_MaintenanceNotification NotifProcessingPhase
_MaintNotifTechSts _MaintNotifTechSts 
@AbapCatalog.sqlViewName: 'IDFSNOTIFTECH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking:#NOT_REQUIRED

@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@EndUserText.label: 'Interface view for Tech Status of Notif'
define view I_DFS_MaintNotificationTechSts
  as select from I_MaintenanceNotification as _MaintenanceNotification
  association [1..*] to I_StatusObjectActiveStatus as _MaintNotifTechSts on _MaintNotifTechSts.StatusObject = _MaintenanceNotification.DfsMaintNotificationObjectNmbr


{
  _MaintenanceNotification.MaintenanceNotification,
  _MaintenanceNotification.DfsMaintNotificationObjectNmbr,
  _MaintenanceNotification._PMNotifMaintenanceData.Equipment,
  _MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment.FunctionalLocation,
  _MaintenanceNotification.MaintNotifInternalID,
  _MaintNotifTechSts.StatusCode                                                                                   as DfsMaintNotifTechStatus,
  _MaintNotifTechSts._StatusCode._StatusCodeText[ 1:Language = $session.system_language ].StatusShortName         as DfsMaintNotifTechStsShortName,
  _MaintNotifTechSts._StatusCode._StatusCodeText[ 1:Language = $session.system_language ].StatusName              as DfsMaintNotifTechStsLongName,
  _MaintNotifTechSts._StatusProfile.StatusProfile                                                                 as DfsMaintNotifTechStatusProfile,
  _MaintNotifTechSts._StatusProfile._StatusProfileText[ 1:Language = $session.system_language ].StatusProfileName as DfsMaintNotifTechStsPrflName,
  _MaintenanceNotification.NotifProcessingPhase,
  _MaintNotifTechSts
}
//where

//      NotifProcessingPhase <> '4'

//  and NotifProcessingPhase <> '5'



/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOCATIONACCOUNTASSIGNMENT",
"I_MAINTENANCENOTIFICATION",
"I_PMNOTIFMAINTENANCEDATA",
"I_STATUSCODE",
"I_STATUSCODETEXT",
"I_STATUSOBJECTACTIVESTATUS",
"I_STATUSPROFILE",
"I_STATUSPROFILETEXT"
],
"ASSOCIATED":
[
"I_STATUSOBJECTACTIVESTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More