Which tables does C_MaintNotifEffectCodeVH use?

C_MaintNotifEffectCodeVH reads from 1 data source(s): I_PMNotificationType.

How many fields does C_MaintNotifEffectCodeVH have?

C_MaintNotifEffectCodeVH has 13 fields. Key fields: InspectionCatalog, InspectionCodeGroup, InspectionCode.

C_MaintNotifEffectCodeVH

DDL: C_MAINTNOTIFEFFECTCODEVH Type: view_entity CONSUMPTION

Maint Notif Failure Effect Code

C_MaintNotifEffectCodeVH is a Consumption CDS View that provides data about "Maint Notif Failure Effect Code" in SAP S/4HANA. It reads from 1 data source (I_PMNotificationType) and exposes 13 fields with key fields InspectionCatalog, InspectionCodeGroup, InspectionCode. It has 2 associations to related views. It is exposed through 2 OData services (UI_MAINTENANCEJOB_MANAGE, UI_MAINTWORKREQUESTOVERVIEW). It is used in 1 Fiori application: Perform Maintenance Jobs.

Data Sources (1)

Source	Alias	Join Type
I_PMNotificationType	pmnotiftype	inner

Associations (2)

Cardinality	Target	Alias	Condition
[0..*]	I_Inspectioncodegrouptext	_InspectionCodeGroupText	`_InspectionCodeGroupText.InspectionCatalog = $projection.InspectionCatalog and _InspectionCodeGroupText.InspectionCodeGroup = $projection.InspectionCodeGroup`
[0..*]	I_NotificationCatalogText	_NotificationCatalogText	`$projection.InspectionCatalog = _NotificationCatalogText.NotificationCatalog`

Annotations (10)

Name	Value	Level
EndUserText.label	Maint Notif Failure Effect Code	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.dataCategory	#VALUE_HELP	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#CUSTOMIZING	view
Search.searchable	true	view
ObjectModel.representativeKey	InspectionCode	view
Metadata.ignorePropagatedAnnotations	true	view

OData Services (2)

Service	Binding	Version	Contract	Release
UI_MAINTENANCEJOB_MANAGE	UI_MAINTENANCEJOB_MANAGE	V2	C1	NOT_RELEASED
UI_MAINTWORKREQUESTOVERVIEW	UI_MAINTWORKREQUESTOVW_V2	V2	C1	NOT_RELEASED

Fiori Apps (1)

App ID	App Name	Type	Description
F5104A	Perform Maintenance Jobs	Transactional	Perform Maintenance Jobs app will help Maintenance Technician to see the list with all work items assigned to the him/her or to his/her team, several features like Assignment of an operation, Time recording for the Operations, create partial or final confirmations and the ability to display and change the malfunction information are possible with the app. The maintenance technician can post and return the planned components and can also record the measurement document.

Perform Maintenance Jobs

Business Role: Maintenance Technician

Technician records actual work, remaining work, confirmation text, and final confirmation for self as well as for team members working on the job.

Fields (13)

Key	Field	Source Table	Source Field	Description
KEY	InspectionCatalog	I_InspectionCode	InspectionCatalog
KEY	InspectionCodeGroup	I_InspectionCode	InspectionCodeGroup	Failure Effect Group
KEY	InspectionCode	I_InspectionCode	InspectionCode	Failure Effect
	CatalogProfile			Catalog Profile
	NotificationType
	InspectionCodeText			Failure Effect Text
	InspSpecAddlCodeGroupText			Failure Effect Group Text
	InspSpecAdditionalCatalogText			Catalog Text
	CodeIsInactive	I_InspectionCode	CodeIsInactive
	_InspectionCodeGroupText		_InspectionCodeGroupText
	_NotificationCatalogText		_NotificationCatalogText
	_InspectionCodeGroup	I_InspectionCode	_InspectionCodeGroup
	_InspectionCatalog	I_InspectionCode	_InspectionCatalog

@EndUserText.label: 'Maint Notif Failure Effect Code'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory: #M,
    dataClass: #CUSTOMIZING }
}
@Search.searchable: true
@ObjectModel.representativeKey: 'InspectionCode'
@Metadata.ignorePropagatedAnnotations: true

define view entity C_MaintNotifEffectCodeVH
  as select distinct from I_InspectionCode
  inner join   I_PMNotificationType as pmnotiftype on I_InspectionCode.InspectionCatalog = pmnotiftype.MaintNotifEffectCatalog
  association [0..*] to I_Inspectioncodegrouptext as _InspectionCodeGroupText on  _InspectionCodeGroupText.InspectionCatalog   = $projection.InspectionCatalog
                                                                              and _InspectionCodeGroupText.InspectionCodeGroup = $projection.InspectionCodeGroup

  association [0..*] to I_NotificationCatalogText as _NotificationCatalogText on  $projection.InspectionCatalog = _NotificationCatalogText.NotificationCatalog
{
      @Search.defaultSearchElement: true
      @UI.lineItem: [{ position: 50 }]
      @UI.selectionField: [{ position: 10  }]
      @Consumption.valueHelpDefinition: [
      { entity:  { name:    'I_Inspectioncatalog',
                     element: 'InspectionCatalog' }
                     }]
  key I_InspectionCode.InspectionCatalog,

      @Search.defaultSearchElement: true
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'C_MaintNotifEffectCodeGroupVH',
                     element: 'InspectionCodeGroup' },
          additionalBinding: [{ localElement: 'InspectionCatalog',
                                element: 'InspectionCatalog' ,
                                usage: #FILTER_AND_RESULT }]
        }]
      @ObjectModel.text.element: ['InspSpecAddlCodeGroupText']
      @EndUserText.label: 'Failure Effect Group'
      @UI.lineItem: [{ position: 30 }]
      @UI.selectionField: [{ position: 50  }]
  key I_InspectionCode.InspectionCodeGroup,
      @Search: { defaultSearchElement: true, ranking: #HIGH }
      @ObjectModel.text.element:  [ 'InspectionCodeText' ]
      @EndUserText.label: 'Failure Effect'
      @UI.lineItem: [{ position: 10 }]
      @UI.selectionField: [{ position: 30  }]
  key I_InspectionCode.InspectionCode,

      @EndUserText.label: 'Catalog Profile'
      @UI.lineItem:[{ hidden: true } ]
      @ObjectModel.readOnly: true
      @ObjectModel.filter.transformedBy: 'ABAP:CL_EAM_MALF_CODE_VH_EXIT'
      @UI.selectionField: [{ position: 70  }]
      cast ('' as rbnr)  as CatalogProfile,

      @Consumption.filter.hidden: true
      @UI.lineItem:[{ hidden: true } ]
      @ObjectModel.filter.transformedBy: 'ABAP:CL_EAM_MNTNTF_NOTIF_TYPE_EXIT'
      cast ('' as qmart) as NotificationType,

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.7, ranking: #MEDIUM }
      @Semantics.text: true
      @EndUserText.label: 'Failure Effect Text'
      @UI.lineItem: [{ position: 20 }]
      @UI.selectionField: [{ position: 40  }]
      I_InspectionCode._Text[1: Language = $session.system_language ].InspectionCodeText,

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.7, ranking: #MEDIUM }
      @EndUserText.label: 'Failure Effect Group Text'
      @UI.lineItem: [{ position: 40 }]
      @UI.selectionField: [{ position: 60  }]
      @Semantics.text: true
      _InspectionCodeGroupText[1: Language = $session.system_language ].InspSpecAddlCodeGroupText,

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.7, ranking: #MEDIUM }
      @EndUserText.label: 'Catalog Text'
      @UI.lineItem: [{ position: 60 }]
      @Semantics.text: true
      @UI.selectionField: [{ position: 20  }]
      _NotificationCatalogText[1: Language = $session.system_language ].InspSpecAdditionalCatalogText,

      @Consumption.hidden: true
      @UI.hidden: true
      I_InspectionCode.CodeIsInactive,

      _InspectionCodeGroupText,
      _NotificationCatalogText,
      I_InspectionCode._InspectionCodeGroup,
      I_InspectionCode._InspectionCatalog
}
where
      I_InspectionCode.CodeIsInactive                           = ''
  and I_InspectionCode._InspectionCodeGroup.CodeGroupStatus     = '2' // Released

  and I_InspectionCode._InspectionCodeGroup.CodeGroupIsInactive = ''

Depth:

C_MaintNotifEffectCodeVH view_entity

I_PMNotificationType view