I_QltyNotificationActivity

DDL: I_QLTYNOTIFICATIONACTIVITY Type: view_entity COMPOSITE Package: VDM_QM_NOTIFICATION
31 Fields 2 Data Sources 2 Associations

Quality Notification Activity

I_QltyNotificationActivity (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public 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. Part of development package VDM_QM_NOTIFICATION.

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
One of the following business catalogs needs to be assigned in SAP S/4HANA Cloud to a user to be able to use this CDS view: QM - Notifications (SAP_QM_BC_NOTIFICATIONS_PC) QM - Quality Task Processing (SAP_QM_BC_QTASK_PRC_PC) Users who want to run reports using this CDS view must have a role that includes authorization based on at least one of the business catalogs listed above. In this role, the following restriction types must be set to read access: Plant (WERKS)

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

CategoryComposite
StateC1
Line of BusinessManufacturing
Application ComponentQM-QN-2CL
CapabilitiesData Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageManufacturing for SAP S/4HANA Cloud Public 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 (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey NotificationActivity view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
Analytics.technicalName IQNOTIFACT 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 Creation Date
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.

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