I_MAINTNOTIFEFFECTCODE

CDS View

Maintenance Notification Failure Effect

I_MAINTNOTIFEFFECTCODE is a CDS View in S/4HANA. Maintenance Notification Failure Effect. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_MaintNotifEffectCodeTP view_entity from TRANSACTIONAL Maintenance Notification Failure Effect 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Maintenance Notification Failure Effect'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
define view entity I_MaintNotifEffectCode
  as select from eam_flre_effect
  // Activity Coding

  association [0..1] to I_Inspectioncatalog       as _MaintNotifEffectCodeCatalog on  $projection.MaintNotifEffectCatalog = _MaintNotifEffectCodeCatalog.InspectionCatalog

  association [0..1] to I_InspectionCodeGroup     as _MaintNotifEffectCodeGroup   on  $projection.MaintNotifEffectCodeGroup = _MaintNotifEffectCodeGroup.InspectionCodeGroup
                                                                                   and $projection.MaintNotifEffectCatalog   = _MaintNotifEffectCodeGroup.InspectionCatalog

  association [0..1] to I_InspectionCode          as _MaintNotificationEffectCode on  $projection.MaintNotifEffectCode      = _MaintNotificationEffectCode.InspectionCode
                                                                                   and $projection.MaintNotifEffectCatalog   = _MaintNotificationEffectCode.InspectionCatalog
                                                                                   and $projection.MaintNotifEffectCodeGroup = _MaintNotificationEffectCode.InspectionCodeGroup
{
  key maintenancenotification        as MaintenanceNotification,
  key maintenancenotificationeffect  as MaintenanceNotificationEffect,
      maintnotifeffectcodeversnumber as MaintNotifEffectCodeVersNumber,
      maintnotifeffectcatalog        as MaintNotifEffectCatalog,
      maintnotifeffectcodegroup      as MaintNotifEffectCodeGroup,
      maintnotifeffectcode           as MaintNotifEffectCode,
      @Semantics.user.createdBy: true
      createdbyuser                  as CreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      creationdatetime               as CreationDateTime,
      @Semantics.user.lastChangedBy: true
      lastchangedbyuser              as LastChangedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      lastchangedatetime             as LastChangeDateTime,

      _MaintNotifEffectCodeCatalog,
      _MaintNotifEffectCodeGroup,
      _MaintNotificationEffectCode
}

Learn More