I_QltyNotificationActivity

DDL: I_QLTYNOTIFICATIONACTIVITY SQL: IQNOTIFACT Type: view COMPOSITE
31 Fields 2 Data Sources 2 Associations

Quality Notification Activity

I_QltyNotificationActivity (Composite)

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

Manufacturing

I_QltyNotificationActivity is a Composite CDS View that provides data about "Quality Notification Activity" in SAP S/4HANA. It reads from 2 data sources (I_NotificationActivity, I_QltyNotification) and exposes 31 fields with key fields QualityNotification, NotificationActivity. It has 2 associations to related views.

SAP Help Documentation

CategoryCDS Views for Quality Improvement
Data CategoryTransactional
StatusReleased
Purpose
This CDS view provides access to the data of a quality notification activity. This CDS view provides the prerequisites for answering the following business questions: Which activities were defined for the processing of a quality notification?

Prerequisites
Users who want to run reports using this CDS view in SAP S/4HANA (on-premise) must have the authorization to display the following data: Quality Notifications The following authorization objects are required: Quality Notification Type (Q_QMEL)

Structure
Object Types This view relates to the following SAP object types: QualityNotification Measures and attributes Some important measures and attributes are: QualityNotification Internal identifier of the quality notification NotificationActivity Internal counter of a activity in a quality notification NotificationItem Internal counter of an item to which task data refers. For header tasks it is initial.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentQM-QN
CapabilitiesData Source for Defining CDS Entities, Data Source in SQL Select
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides access to the data of a quality notification activity.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>Which activities were defined for the processing of a quality notification?</p></li> </ul>

Documentation

Data Sources (2)

SourceAliasJoin Type
I_NotificationActivity I_NotificationActivity from
I_QltyNotification I_QltyNotification inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_QltyNotification _Notification $projection.QualityNotification = _Notification.QualityNotification
[0..*] I_QltyNotifActivityLongText _QltyNotifActivityLongText $projection.QualityNotification = _QltyNotifActivityLongText.QualityNotification and $projection.NotificationActivity = _QltyNotifActivityLongText.NotificationActivity

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IQNOTIFACT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey NotificationActivity view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
EndUserText.label Quality Notification Activity view
Metadata.ignorePropagatedAnnotations true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY QualityNotification I_NotificationActivity Notification Notification Number
KEY NotificationActivity I_NotificationActivity NotificationActivity Consecutive Number of Activity
NotificationItem I_NotificationActivity NotificationItem Item Number in Item Record
NotificationActivitySortNumber I_NotificationActivity NotificationActivitySortNumber Sort Number for Activity
IsDeleted I_NotificationActivity IsDeleted Delete Data Record
MasterLanguage I_NotificationActivity MasterLanguage Primary language indicator for text segment
NotifActivityCatalog I_NotificationActivity NotifActivityCatalog Catalog Type - Activities
NotifActivityCodeGroup I_NotificationActivity NotifActivityCodeGroup Activity Code Group
NotifActivityCode I_NotificationActivity NotifActivityCode Activity Code
NotifActivityText I_NotificationActivity NotifActivityText Activity Text
NotifActivityStartDate I_NotificationActivity NotifActivityStartDate Activity Start Date
NotifActivityStartTime I_NotificationActivity NotifActivityStartTime Start Time of Activity
NotifActivityEndDate I_NotificationActivity NotifActivityEndDate Activity End Date
NotifActivityEndTime I_NotificationActivity NotifActivityEndTime End Time of Activity
NotifProcessingPhase I_QltyNotification NotifProcessingPhase Notification Processing Phase
ChangedDateTime I_NotificationActivity ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
CreatedByUser I_NotificationActivity CreatedByUser Name of Person Responsible for Creating the Object
CreationDate I_NotificationActivity CreationDate Record Created On
CreationTime I_NotificationActivity CreationTime Time at Which Record Was Added
LastChangedByUser I_NotificationActivity LastChangedByUser Name of Person Who Changed Object
LastChangeDate I_NotificationActivity LastChangeDate Last Changed On
LastChangeTime I_NotificationActivity LastChangeTime Time of Change
IsBusinessPurposeCompleted I_QltyNotification IsBusinessPurposeCompleted Business Purpose Completed Flag
_Notification _Notification
_CreatedByUserContactCard I_NotificationActivity _CreatedByUserContactCard
_LastChangedByUserContactCard I_NotificationActivity _LastChangedByUserContactCard
_Language I_NotificationActivity _Language
_NotifActivityCatalog I_NotificationActivity _NotifActivityCatalog
_NotifActivityCodeGroup I_NotificationActivity _NotifActivityCodeGroup
_NotifActivityCode I_NotificationActivity _NotifActivityCode
_QltyNotifActivityLongText _QltyNotifActivityLongText

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_QltyNotificationActivity.
-- 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.
-- SQL view name: IQNOTIFACT

CREATE VIEW I_QltyNotificationActivity AS
SELECT
  I_NotificationActivity.Notification AS QualityNotification,
  I_NotificationActivity.NotificationActivity AS NotificationActivity,
  I_NotificationActivity.NotificationItem AS NotificationItem,
  I_NotificationActivity.NotificationActivitySortNumber AS NotificationActivitySortNumber,
  I_NotificationActivity.IsDeleted AS IsDeleted,
  I_NotificationActivity.MasterLanguage AS MasterLanguage,
  I_NotificationActivity.NotifActivityCatalog AS NotifActivityCatalog,
  I_NotificationActivity.NotifActivityCodeGroup AS NotifActivityCodeGroup,
  I_NotificationActivity.NotifActivityCode AS NotifActivityCode,
  I_NotificationActivity.NotifActivityText AS NotifActivityText,
  I_NotificationActivity.NotifActivityStartDate AS NotifActivityStartDate,
  I_NotificationActivity.NotifActivityStartTime AS NotifActivityStartTime,
  I_NotificationActivity.NotifActivityEndDate AS NotifActivityEndDate,
  I_NotificationActivity.NotifActivityEndTime AS NotifActivityEndTime,
  I_QltyNotification.NotifProcessingPhase AS NotifProcessingPhase,
  I_NotificationActivity.ChangedDateTime AS ChangedDateTime,
  I_NotificationActivity.CreatedByUser AS CreatedByUser,
  I_NotificationActivity.CreationDate AS CreationDate,
  I_NotificationActivity.CreationTime AS CreationTime,
  I_NotificationActivity.LastChangedByUser AS LastChangedByUser,
  I_NotificationActivity.LastChangeDate AS LastChangeDate,
  I_NotificationActivity.LastChangeTime AS LastChangeTime,
  I_QltyNotification.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  I_NotificationActivity._CreatedByUserContactCard AS _CreatedByUserContactCard,
  I_NotificationActivity._LastChangedByUserContactCard AS _LastChangedByUserContactCard,
  I_NotificationActivity._Language AS _Language,
  I_NotificationActivity._NotifActivityCatalog AS _NotifActivityCatalog,
  I_NotificationActivity._NotifActivityCodeGroup AS _NotifActivityCodeGroup,
  I_NotificationActivity._NotifActivityCode AS _NotifActivityCode
FROM I_NotificationActivity
INNER JOIN I_QltyNotification ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_QltyNotification AS _Notification ON QualityNotification = _Notification.QualityNotification  -- association [0..1]
LEFT OUTER JOIN I_QltyNotifActivityLongText AS _QltyNotifActivityLongText ON QualityNotification = _QltyNotifActivityLongText.QualityNotification AND NotificationActivity = _QltyNotifActivityLongText.NotificationActivity  -- association [0..*]
;

Learn More