I_MaintNotifEffectCode

DDL: I_MAINTNOTIFEFFECTCODE Type: view_entity BASIC

Maintenance Notification Failure Effect

I_MaintNotifEffectCode is a Basic CDS View that provides data about "Maintenance Notification Failure Effect" in SAP S/4HANA. It reads from 1 data source (eam_flre_effect) and exposes 13 fields with key fields MaintenanceNotification, MaintenanceNotificationEffect. It has 3 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
eam_flre_effect eam_flre_effect from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Inspectioncatalog _MaintNotifEffectCodeCatalog $projection.MaintNotifEffectCatalog = _MaintNotifEffectCodeCatalog.InspectionCatalog
[0..1] I_InspectionCodeGroup _MaintNotifEffectCodeGroup $projection.MaintNotifEffectCodeGroup = _MaintNotifEffectCodeGroup.InspectionCodeGroup and $projection.MaintNotifEffectCatalog = _MaintNotifEffectCodeGroup.InspectionCatalog
[0..1] I_InspectionCode _MaintNotificationEffectCode $projection.MaintNotifEffectCode = _MaintNotificationEffectCode.InspectionCode and $projection.MaintNotifEffectCatalog = _MaintNotificationEffectCode.InspectionCatalog and $projection.MaintNotifEffectCodeGroup = _MaintNotificationEffectCode.InspectionCodeGroup

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Maintenance Notification Failure Effect view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification maintenancenotification
KEY MaintenanceNotificationEffect maintenancenotificationeffect
MaintNotifEffectCodeVersNumber maintnotifeffectcodeversnumber
MaintNotifEffectCatalog maintnotifeffectcatalog
MaintNotifEffectCodeGroup maintnotifeffectcodegroup
MaintNotifEffectCode maintnotifeffectcode
CreatedByUser createdbyuser
CreationDateTime creationdatetime
LastChangedByUser lastchangedbyuser
LastChangeDateTime lastchangedatetime
_MaintNotifEffectCodeCatalog _MaintNotifEffectCodeCatalog
_MaintNotifEffectCodeGroup _MaintNotifEffectCodeGroup
_MaintNotificationEffectCode _MaintNotificationEffectCode 
@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