A_QltyNotificationItemCause

DDL: A_QLTYNOTIFICATIONITEMCAUSE Type: view_entity CONSUMPTION Package: ODATA_QM_NOTIFICATION_API
19 Fields 1 Data Sources 1 OData Services

Quality Notification Item Cause

A_QltyNotificationItemCause is a Consumption CDS View that provides data about "Quality Notification Item Cause" in SAP S/4HANA. It reads from 1 data source (R_QltyNotificationItemCauseTP) and exposes 19 fields with key fields QualityNotification, NotificationItem, NotificationCauseID. It is exposed through 1 OData service (API_QUALITYNOTIFICATION). Part of development package ODATA_QM_NOTIFICATION_API.

Data Sources (1)

SourceAliasJoin Type
R_QltyNotificationItemCauseTP R_QltyNotificationItemCauseTP projection

Annotations (12)

NameValueLevelField
EndUserText.label Quality Notification Item Cause view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey NotificationCauseID view
OData.entitySet.name QualityNotificationItemCause view
OData.entityType.name QualityNotificationItemCause_Type view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_QUALITYNOTIFICATION API_QUALITYNOTIFICATION V4 C2 C1

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY QualityNotification _QltyNotificationItemCause QualityNotification
KEY NotificationItem _QltyNotificationItemCause NotificationItem
KEY NotificationCauseID _QltyNotificationItemCause NotificationCauseID
NotificationCauseSortNumber _QltyNotificationItemCause NotificationCauseSortNumber
MasterLanguage _QltyNotificationItemCause MasterLanguage Primary lang.
NotificationCauseText _QltyNotificationItemCause NotificationCauseText
NotificationCauseCodeCatalog _QltyNotificationItemCause NotificationCauseCodeCatalog
NotificationCauseCodeGroup _QltyNotificationItemCause NotificationCauseCodeGroup
NotificationCauseCode _QltyNotificationItemCause NotificationCauseCode
NotificationRootCause _QltyNotificationItemCause NotificationRootCause
IsDeleted _QltyNotificationItemCause IsDeleted TRUE
IsBusinessPurposeCompleted _QltyNotificationItemCause IsBusinessPurposeCompleted Purpose Completed
CreatedByUser _QltyNotificationItemCause CreatedByUser User Name
CreationDate _QltyNotificationItemCause CreationDate Time Stamp
CreationTime _QltyNotificationItemCause CreationTime Time of Change
LastChangedByUser _QltyNotificationItemCause LastChangedByUser User Name
LastChangeDate _QltyNotificationItemCause LastChangeDate Time Stamp
LastChangeTime _QltyNotificationItemCause LastChangeTime Time changed
_Notification _QltyNotificationItemCause _Notification

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 A_QltyNotificationItemCause.
-- 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 A_QltyNotificationItemCause AS
SELECT
  _QltyNotificationItemCause.QualityNotification AS QualityNotification,
  _QltyNotificationItemCause.NotificationItem AS NotificationItem,
  _QltyNotificationItemCause.NotificationCauseID AS NotificationCauseID,
  _QltyNotificationItemCause.NotificationCauseSortNumber AS NotificationCauseSortNumber,
  _QltyNotificationItemCause.MasterLanguage AS MasterLanguage,
  _QltyNotificationItemCause.NotificationCauseText AS NotificationCauseText,
  _QltyNotificationItemCause.NotificationCauseCodeCatalog AS NotificationCauseCodeCatalog,
  _QltyNotificationItemCause.NotificationCauseCodeGroup AS NotificationCauseCodeGroup,
  _QltyNotificationItemCause.NotificationCauseCode AS NotificationCauseCode,
  _QltyNotificationItemCause.NotificationRootCause AS NotificationRootCause,
  _QltyNotificationItemCause.IsDeleted AS IsDeleted,
  _QltyNotificationItemCause.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _QltyNotificationItemCause.CreatedByUser AS CreatedByUser,
  _QltyNotificationItemCause.CreationDate AS CreationDate,
  _QltyNotificationItemCause.CreationTime AS CreationTime,
  _QltyNotificationItemCause.LastChangedByUser AS LastChangedByUser,
  _QltyNotificationItemCause.LastChangeDate AS LastChangeDate,
  _QltyNotificationItemCause.LastChangeTime AS LastChangeTime,
  _QltyNotificationItemCause._Notification AS _Notification
FROM R_QltyNotificationItemCauseTP
;

Learn More