I_PMNotificationType

DDL: I_PMNOTIFICATIONTYPE Type: view BASIC
20 Fields 1 Data Sources 3 Associations

Maintenance Notification Types

I_PMNotificationType (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

MaintenanceNotificationType · Asset Management

I_PMNotificationType is a Basic CDS View that provides data about "Maintenance Notification Types" in SAP S/4HANA. It reads from 1 data source (tq80) and exposes 20 fields with key field NotificationType. It has 3 associations to related views.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Purpose
This CDS view defines a basic view for maintenance notification types, providing a structured representation of various attributes and associations related to maintenance notifications within a system. It is designed to facilitate data extraction and support various capabilities such as SQL data sourcing and CDS modeling. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Structure
Important Fields Important fields in this view include the following: Field Name Description NOTIFICATIONTYPE Notification Type NUMBERRANGE Number range LONGTEXTISNOTCHANGEABLE No text change ISEXTERNALNUMBERRANGE External ISNOTIFICATIONCREATIONTYPE Request Maintenance App NOTIFICATIONORIGIN Notification Origin USERMUSTBENOTIFIED USERCANBENOTIFIED NOTIFIEDUSERCANBEDELETED MAINTENANCEORDERTYPE Order Type MAINTPRIORITYTYPE Priority Type NOTIFICATIONCATEGORY Application MAINTNOTIFRESPPARTNERFUNCTION Person Responsible MAINTNOTIFOBJPRTCODECATALOG Object Parts MAINTNOTIFDAMAGECODECATALOG Problems MAINTNOTIFCAUSECODECATALOG Causes MAINTNOTIFTASKCODECATALOG Tasks MAINTNOTIFACTIVITYCODECATALOG Activities MAINTNOTIFCODGCATALOGTYPECODE Coding CATALOGPROFILE Catalog Profile

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessAsset Management
Application ComponentPM-WOC-MN
CapabilitiesData Source for Data Extraction, Data Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageAsset Management for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
tq80 tq80 from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_PMNotificationTypeText _Text _Text.NotificationType = $projection.NotificationType
[0..1] tpaer _PartnerRoles _PartnerRoles.pargr = tq80.pargr and _PartnerRoles.parvw = 'IT'
[0..1] nriv _NumberRangeIntervals _NumberRangeIntervals.nrrangenr = $projection.NumberRange and _NumberRangeIntervals.object = 'QMEL_NR' and _NumberRangeIntervals.subobject = '' and _NumberRangeIntervals.toyear = '0000'

Annotations (14)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IPMNOTIFTYPE view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Maintenance Notification Types view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
VDM.viewType #BASIC view
ObjectModel.representativeKey NotificationType view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.sapObjectNodeType.name MaintenanceNotificationType view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY NotificationType qmart Notification Type
NumberRange tq80 qmnuk Number Range for Notifications
NotificationOrigin herkz Origin of Notification
IsExternalNumberRange _NumberRangeIntervals externind Internal (' ') or external ('X') number range flag
MaintPriorityType artpr Priority Type
NotificationCategory qmtyp Notification Category
LongTextIsNotChangeable qmltxt02 No Changes to Existing Long Text
papflXthenXelseendasUserMustBeNotified
IsNotificationCreationType tq80 reqmaintapp_use Notification Type for Request Maintenance App
CatalogProfile tq80 rbnr Catalog Profile
MaintNotifObjPrtCodeCatalog tq80 otkat Catalog Type - Object Parts
MaintNotifDamageCodeCatalog tq80 fekat Catalog Type - Problems/Defects
MaintNotifCauseCodeCatalog tq80 urkat Catalog Type - Causes
MaintNotifTaskCodeCatalog tq80 makat Catalog Type - Tasks
MaintNotifActivityCodeCatalog tq80 mfkat Catalog Type - Activities
MaintNotifEffectCatalog tq80 failure_effect Failure Effect Catalog
MaintNotifRespPartnerFunction tq80 parvw_vera Partner Function: Person/Department Responsible
MaintenanceOrderType tq80 auart Sales Doc. Type
MaintNotifCodgCatalogTypeCode tq80 sakat Catalog Type - Coding
_Text _Text

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_PMNotificationType.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_PMNotificationType AS
SELECT
  qmart AS NotificationType,
  tq80.qmnuk AS NumberRange,
  herkz AS NotificationOrigin,
  _NumberRangeIntervals.externind AS IsExternalNumberRange,
  artpr AS MaintPriorityType,
  qmtyp AS NotificationCategory,
  qmltxt02 AS LongTextIsNotChangeable,
  case when _PartnerRoles.papfl = 'X' then 'X' else '' end as UserMustBeNotified AS papflXthenXelseendasUserMustBeNotified,
  tq80.reqmaintapp_use AS IsNotificationCreationType,
  tq80.rbnr AS CatalogProfile,
  tq80.otkat AS MaintNotifObjPrtCodeCatalog,
  tq80.fekat AS MaintNotifDamageCodeCatalog,
  tq80.urkat AS MaintNotifCauseCodeCatalog,
  tq80.makat AS MaintNotifTaskCodeCatalog,
  tq80.mfkat AS MaintNotifActivityCodeCatalog,
  tq80.failure_effect AS MaintNotifEffectCatalog,
  tq80.parvw_vera AS MaintNotifRespPartnerFunction,
  tq80.auart AS MaintenanceOrderType,
  tq80.sakat AS MaintNotifCodgCatalogTypeCode
FROM tq80
LEFT OUTER JOIN I_PMNotificationTypeText AS _Text ON _Text.NotificationType = NotificationType  -- association [0..*]
LEFT OUTER JOIN tpaer AS _PartnerRoles ON _PartnerRoles.pargr = tq80.pargr AND _PartnerRoles.parvw = 'IT'  -- association [0..1]
LEFT OUTER JOIN nriv AS _NumberRangeIntervals ON _NumberRangeIntervals.nrrangenr = NumberRange AND _NumberRangeIntervals.object = 'QMEL_NR' AND _NumberRangeIntervals.subobject = '' AND _NumberRangeIntervals.toyear = '0000'  -- association [0..1]
;

Learn More