C_MaintNotificationItemTP

DDL: C_MAINTNOTIFICATIONITEMTP SQL: CNOTIFITTP Type: view CONSUMPTION

Maintenance Notification Item

C_MaintNotificationItemTP is a Consumption CDS View that provides data about "Maintenance Notification Item" in SAP S/4HANA. It reads from 1 data source (I_MaintNotificationItemTP) and exposes 26 fields with key fields MaintenanceNotification, MaintenanceNotificationItem. It has 12 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintNotificationItemTP I_MaintNotificationItemTP from

Associations (12)

CardinalityTargetAliasCondition
[1..1] C_MaintNotificationTP _MaintNotificationTP _MaintNotificationTP.MaintenanceNotification = $projection.MaintenanceNotification
[0..*] C_MaintNotificationCauseTP _MaintNotificationCauseTP _MaintNotificationCauseTP.MaintenanceNotification = $projection.MaintenanceNotification and _MaintNotificationCauseTP.MaintenanceNotificationItem = $projection.MaintenanceNotificationItem
[0..1] I_Inspectioncatalog _MaintNotifDamageCodeCatalog $projection.MaintNotifDamageCodeCatalog = _MaintNotifDamageCodeCatalog.InspectionCatalog
[0..1] I_InspectionCodeGroup _MaintNotifDamageCodeGroup $projection.MaintNotifDamageCodeGroup = _MaintNotifDamageCodeGroup.InspectionCodeGroup and $projection.MaintNotifDamageCodeCatalog = _MaintNotifDamageCodeGroup.InspectionCatalog
[0..*] I_Inspectioncodegrouptext _MaintNotifDamageCodeGroupText $projection.MaintNotifDamageCodeGroup = _MaintNotifDamageCodeGroupText.InspectionCodeGroup and $projection.MaintNotifDamageCodeCatalog = _MaintNotifDamageCodeGroupText.InspectionCatalog
[0..1] I_InspectionCode _MaintNotificationDamageCode $projection.MaintNotificationDamageCode = _MaintNotificationDamageCode.InspectionCode and $projection.MaintNotifDamageCodeCatalog = _MaintNotificationDamageCode.InspectionCatalog and $projection.MaintNotifDamageCodeGroup = _MaintNotificationDamageCode.InspectionCodeGroup
[0..*] I_InspectionCodeText _MaintNotificationDamageCodeT $projection.MaintNotificationDamageCode = _MaintNotificationDamageCodeT.InspectionCode and $projection.MaintNotifDamageCodeCatalog = _MaintNotificationDamageCodeT.InspectionCatalog and $projection.MaintNotifDamageCodeGroup = _MaintNotificationDamageCodeT.InspectionCodeGroup
[0..1] I_Inspectioncatalog _MaintNotifObjPrtCodeCatalog $projection.MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCodeCatalog.InspectionCatalog
[0..1] I_InspectionCodeGroup _MaintNotifObjPrtCodeGroup $projection.MaintNotifObjPrtCodeGroup = _MaintNotifObjPrtCodeGroup.InspectionCodeGroup and $projection.MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCodeGroup.InspectionCatalog
[0..*] I_Inspectioncodegrouptext _MaintNotifObjPrtCodeGroupText $projection.MaintNotifObjPrtCodeGroup = _MaintNotifObjPrtCodeGroupText.InspectionCodeGroup and $projection.MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCodeGroupText.InspectionCatalog
[0..1] I_InspectionCode _MaintNotifObjPrtCode $projection.MaintNotifObjPrtCode = _MaintNotifObjPrtCode.InspectionCode and $projection.MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCode.InspectionCatalog and $projection.MaintNotifObjPrtCodeGroup = _MaintNotifObjPrtCode.InspectionCodeGroup
[0..*] I_InspectionCodeText _MaintNotifObjPrtCodeText $projection.MaintNotifObjPrtCode = _MaintNotifObjPrtCodeText.InspectionCode and $projection.MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCodeText.InspectionCatalog and $projection.MaintNotifObjPrtCodeGroup = _MaintNotifObjPrtCodeText.InspectionCodeGroup

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CNOTIFITTP view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Notification Item view
VDM.viewType #CONSUMPTION view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.representativeKey MaintenanceNotificationItem view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification I_MaintNotificationItemTP MaintenanceNotification
KEY MaintenanceNotificationItem I_MaintNotificationItemTP MaintenanceNotificationItem Damage
MaintNotificationItemForEdit I_MaintNotificationItemTP MaintNotificationItemForEdit
MaintNotifItemText I_MaintNotificationItemTP MaintNotifItemText
MaintNotifObjPrtCode
MaintNotificationDamageCode
MaintNotifDamageCodeCatalog I_MaintNotificationItemTP MaintNotifDamageCodeCatalog
MaintNotifDamageCodeGroup I_MaintNotificationItemTP MaintNotifDamageCodeGroup
MaintNotifObjPrtCodeCatalog I_MaintNotificationItemTP MaintNotifObjPrtCodeCatalog
MaintNotifObjPrtCodeGroup I_MaintNotificationItemTP MaintNotifObjPrtCodeGroup
IsDeleted I_MaintNotificationItemTP IsDeleted
_IsDeleted I_MaintNotificationItemTP _IsDeleted
_MaintenanceNotification I_MaintNotificationItemTP _MaintenanceNotification
_MaintNotificationTP _MaintNotificationTP
_MaintNotificationCauseTP _MaintNotificationCauseTP
IsMaintNotificationRootCause
_MaintNotifDamageCodeCatalog _MaintNotifDamageCodeCatalog
_MaintNotifDamageCodeGroup _MaintNotifDamageCodeGroup
_MaintNotificationDamageCode _MaintNotificationDamageCode
_MaintNotifObjPrtCodeCatalog _MaintNotifObjPrtCodeCatalog
_MaintNotifObjPrtCodeGroup _MaintNotifObjPrtCodeGroup
_MaintNotifObjPrtCode _MaintNotifObjPrtCode
_MaintNotifObjPrtCodeGroupText _MaintNotifObjPrtCodeGroupText
_MaintNotifObjPrtCodeText _MaintNotifObjPrtCodeText
_MaintNotifDamageCodeGroupText _MaintNotifDamageCodeGroupText
_MaintNotificationDamageCodeT _MaintNotificationDamageCodeT
@AbapCatalog.sqlViewName: 'CNOTIFITTP'
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Notification Item'

@VDM.viewType: #CONSUMPTION

@ObjectModel.transactionalProcessingDelegated:true

@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL


@ObjectModel: {
  representativeKey : 'MaintenanceNotificationItem',
  semanticKey: [ 'MaintenanceNotificationItem', 'MaintenanceNotification']
}

@AccessControl.privilegedAssociations: ['_MaintNotifObjPrtCodeText', '_MaintNotificationDamageCodeT']

define view C_MaintNotificationItemTP
  as select from I_MaintNotificationItemTP
  association [1..1] to C_MaintNotificationTP      as _MaintNotificationTP           on  _MaintNotificationTP.MaintenanceNotification = $projection.MaintenanceNotification

  association [0..*] to C_MaintNotificationCauseTP as _MaintNotificationCauseTP      on  _MaintNotificationCauseTP.MaintenanceNotification     = $projection.MaintenanceNotification
                                                                                     and _MaintNotificationCauseTP.MaintenanceNotificationItem = $projection.MaintenanceNotificationItem

  //Damage Coding

  association [0..1] to I_Inspectioncatalog        as _MaintNotifDamageCodeCatalog   on  $projection.MaintNotifDamageCodeCatalog = _MaintNotifDamageCodeCatalog.InspectionCatalog
  association [0..1] to I_InspectionCodeGroup      as _MaintNotifDamageCodeGroup     on  $projection.MaintNotifDamageCodeGroup   = _MaintNotifDamageCodeGroup.InspectionCodeGroup
                                                                                     and $projection.MaintNotifDamageCodeCatalog = _MaintNotifDamageCodeGroup.InspectionCatalog
  association [0..*] to I_Inspectioncodegrouptext  as _MaintNotifDamageCodeGroupText on  $projection.MaintNotifDamageCodeGroup   = _MaintNotifDamageCodeGroupText.InspectionCodeGroup
                                                                                     and $projection.MaintNotifDamageCodeCatalog = _MaintNotifDamageCodeGroupText.InspectionCatalog
  association [0..1] to I_InspectionCode           as _MaintNotificationDamageCode   on  $projection.MaintNotificationDamageCode = _MaintNotificationDamageCode.InspectionCode
                                                                                     and $projection.MaintNotifDamageCodeCatalog = _MaintNotificationDamageCode.InspectionCatalog
                                                                                     and $projection.MaintNotifDamageCodeGroup   = _MaintNotificationDamageCode.InspectionCodeGroup
  association [0..*] to I_InspectionCodeText       as _MaintNotificationDamageCodeT  on  $projection.MaintNotificationDamageCode = _MaintNotificationDamageCodeT.InspectionCode
                                                                                     and $projection.MaintNotifDamageCodeCatalog = _MaintNotificationDamageCodeT.InspectionCatalog
                                                                                     and $projection.MaintNotifDamageCodeGroup   = _MaintNotificationDamageCodeT.InspectionCodeGroup
  //Object Part Coding_MaintNotificationDamageCodeT

  association [0..1] to I_Inspectioncatalog        as _MaintNotifObjPrtCodeCatalog   on  $projection.MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCodeCatalog.InspectionCatalog
  association [0..1] to I_InspectionCodeGroup      as _MaintNotifObjPrtCodeGroup     on  $projection.MaintNotifObjPrtCodeGroup   = _MaintNotifObjPrtCodeGroup.InspectionCodeGroup
                                                                                     and $projection.MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCodeGroup.InspectionCatalog
  association [0..*] to I_Inspectioncodegrouptext  as _MaintNotifObjPrtCodeGroupText on  $projection.MaintNotifObjPrtCodeGroup   = _MaintNotifObjPrtCodeGroupText.InspectionCodeGroup
                                                                                     and $projection.MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCodeGroupText.InspectionCatalog
  association [0..1] to I_InspectionCode           as _MaintNotifObjPrtCode          on  $projection.MaintNotifObjPrtCode        = _MaintNotifObjPrtCode.InspectionCode
                                                                                     and $projection.MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCode.InspectionCatalog
                                                                                     and $projection.MaintNotifObjPrtCodeGroup   = _MaintNotifObjPrtCode.InspectionCodeGroup
  association [0..*] to I_InspectionCodeText       as _MaintNotifObjPrtCodeText      on  $projection.MaintNotifObjPrtCode        = _MaintNotifObjPrtCodeText.InspectionCode
                                                                                     and $projection.MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCodeText.InspectionCatalog
                                                                                     and $projection.MaintNotifObjPrtCodeGroup   = _MaintNotifObjPrtCodeText.InspectionCodeGroup
{

      @ObjectModel.foreignKey.association: '_MaintNotificationTP'
      @UI.hidden: true
  key I_MaintNotificationItemTP.MaintenanceNotification,
      @ObjectModel.text.element:  [ 'MaintNotifItemText' ]
      @EndUserText.label: 'Damage'
  key I_MaintNotificationItemTP.MaintenanceNotificationItem,

      @UI.hidden: true
      I_MaintNotificationItemTP.MaintNotificationItemForEdit,

      @Semantics.text: true
      I_MaintNotificationItemTP.MaintNotifItemText,

      // Object Part

      //--[ GENERATED:012:GFBfhxvv7jY4hCRG3B4jvm

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_InspectionCodeStdVH',
                     element: 'InspectionCode' },
          additionalBinding: [{ localElement: 'MaintNotifObjPrtCodeCatalog',
                                element: 'InspectionCatalog' },
                              { localElement: 'MaintNotifObjPrtCodeGroup',
                                element: 'InspectionCodeGroup' }]
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_MaintNotifObjPrtCode'
      @ObjectModel.text.association: '_MaintNotifObjPrtCodeText'
      @ObjectModel.text.control: #ASSOCIATED_TEXT_UI_HIDDEN
      cast( I_MaintNotificationItemTP.MaintNotifObjPrtCode  as eam_object_part_code )                                                                                                                                         as MaintNotifObjPrtCode,

      // Damage

      //--[ GENERATED:012:GFBfhxvv7jY4hCRG3B4jvm

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_InspectionCodeStdVH',
                     element: 'InspectionCode' },
          additionalBinding: [{ localElement: 'MaintNotifDamageCodeCatalog',
                                element: 'InspectionCatalog' },
                              { localElement: 'MaintNotifDamageCodeGroup',
                                element: 'InspectionCodeGroup' }]
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_MaintNotificationDamageCode'
      @ObjectModel.text.association: '_MaintNotificationDamageCodeT'
      @ObjectModel.text.control: #ASSOCIATED_TEXT_UI_HIDDEN
      cast( I_MaintNotificationItemTP.MaintNotificationDamageCode  as eam_damage_code )                                                                                                                                       as MaintNotificationDamageCode,

      @ObjectModel.foreignKey.association: '_MaintNotifDamageCodeCatalog'
      @UI.hidden: true
      I_MaintNotificationItemTP.MaintNotifDamageCodeCatalog,
      //--[ GENERATED:012:GFBfhxvv7jY4hCRG3B4jvm

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_InspectionCodeGroupStdVH',
                     element: 'InspectionCodeGroup' },
          additionalBinding: [{ localElement: 'MaintNotifDamageCodeCatalog',
                                element: 'InspectionCatalog' }]
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_MaintNotifDamageCodeGroup'
      @ObjectModel.text.association: '_MaintNotifDamageCodeGroupText'
      @ObjectModel.text.control: #ASSOCIATED_TEXT_UI_HIDDEN
      I_MaintNotificationItemTP.MaintNotifDamageCodeGroup,

      @ObjectModel.foreignKey.association: '_MaintNotifObjPrtCodeCatalog'
      @UI.hidden: true
      I_MaintNotificationItemTP.MaintNotifObjPrtCodeCatalog,
      //--[ GENERATED:012:GFBfhxvv7jY4hCRG3B4jvm

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_InspectionCodeGroupStdVH',
                     element: 'InspectionCodeGroup' },
          additionalBinding: [{ localElement: 'MaintNotifObjPrtCodeCatalog',
                                element: 'InspectionCatalog' }]
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_MaintNotifObjPrtCodeGroup'
      @ObjectModel.text.association: '_MaintNotifObjPrtCodeGroupText'
      @ObjectModel.text.control: #ASSOCIATED_TEXT_UI_HIDDEN
      I_MaintNotificationItemTP.MaintNotifObjPrtCodeGroup,

      @UI.hidden: true
      I_MaintNotificationItemTP.IsDeleted,

      /* Associations */
      I_MaintNotificationItemTP._IsDeleted,
      I_MaintNotificationItemTP._MaintenanceNotification,


      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _MaintNotificationTP,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MaintNotificationCauseTP,


      @ObjectModel.readOnly: true
      _MaintNotificationCauseTP[1: IsMaintNotificationRootCause = 'X' ].IsMaintNotificationRootCause,


      _MaintNotifDamageCodeCatalog,
      _MaintNotifDamageCodeGroup,
      _MaintNotificationDamageCode,
      _MaintNotifObjPrtCodeCatalog,
      _MaintNotifObjPrtCodeGroup,
      _MaintNotifObjPrtCode,
      _MaintNotifObjPrtCodeGroupText,
      _MaintNotifObjPrtCodeText,
      _MaintNotifDamageCodeGroupText,
      _MaintNotificationDamageCodeT

}
where
  I_MaintNotificationItemTP.IsDeleted != 'X'