A_QltyNotificationTask

DDL: A_QLTYNOTIFICATIONTASK Type: view_entity CONSUMPTION
36 Fields 1 Data Sources 1 OData Services

Quality Notification Task

A_QltyNotificationTask is a Consumption CDS View that provides data about "Quality Notification Task" in SAP S/4HANA. It reads from 1 data source (R_QltyNotificationTaskTP) and exposes 36 fields with key fields QualityNotification, NotificationTask. It is exposed through 1 OData service (API_QUALITYNOTIFICATION).

Data Sources (1)

SourceAliasJoin Type
R_QltyNotificationTaskTP R_QltyNotificationTaskTP projection

Annotations (12)

NameValueLevelField
EndUserText.label Quality Notification Task 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 #A view
ObjectModel.representativeKey NotificationTask view
OData.entitySet.name QualityNotificationTask view
OData.entityType.name QualityNotificationTask_Type view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_QUALITYNOTIFICATION API_QUALITYNOTIFICATION V4 C2 C1

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY QualityNotification _QltyNotificationTask QualityNotification
KEY NotificationTask _QltyNotificationTask NotificationTask
NotificationTaskText _QltyNotificationTask NotificationTaskText
IsDeleted _QltyNotificationTask IsDeleted TRUE
NotifTaskPlannedStartDate _QltyNotificationTask NotifTaskPlannedStartDate
NotifTaskPlannedStartTime _QltyNotificationTask NotifTaskPlannedStartTime
NotifTaskPlannedEndDate _QltyNotificationTask NotifTaskPlannedEndDate
NotifTaskPlannedEndTime _QltyNotificationTask NotifTaskPlannedEndTime
StatusObject _QltyNotificationTask StatusObject Status Object
NotifTaskCompletedByUser _QltyNotificationTask NotifTaskCompletedByUser
NotifTaskCompletionDate _QltyNotificationTask NotifTaskCompletionDate
NotifTaskCompletionTime _QltyNotificationTask NotifTaskCompletionTime
ResponsiblePersonFunctionCode _QltyNotificationTask ResponsiblePersonFunctionCode
PersonResponsible _QltyNotificationTask PersonResponsible Person Responsible
NotificationTaskSortNumber _QltyNotificationTask NotificationTaskSortNumber
NotificationItem _QltyNotificationTask NotificationItem
NotificationCauseID _QltyNotificationTask NotificationCauseID
QualityTaskCodeCatalog _QltyNotificationTask QualityTaskCodeCatalog
QualityTaskCodeGroup _QltyNotificationTask QualityTaskCodeGroup
QualityTaskCode _QltyNotificationTask QualityTaskCode
QltyTaskTimeBasedEffort _QltyNotificationTask QltyTaskTimeBasedEffort
QltyTaskTimeBasedEffortUoM _QltyNotificationTask QltyTaskTimeBasedEffortUoM
CreatedByUser _QltyNotificationTask CreatedByUser User Name
CreationDate _QltyNotificationTask CreationDate Time Stamp
CreationTime _QltyNotificationTask CreationTime Time of Change
LastChangedByUser _QltyNotificationTask LastChangedByUser User Name
LastChangeDate _QltyNotificationTask LastChangeDate Time Stamp
LastChangeTime _QltyNotificationTask LastChangeTime Time changed
NotificationType _QltyNotificationTask NotificationType Notifictn Type
Plant _QltyNotificationTask Plant Valuation Area
IsBusinessPurposeCompleted _QltyNotificationTask IsBusinessPurposeCompleted Purpose Completed
_PartnerFunction _QltyNotificationTask _PartnerFunction
_ContactPerson _QltyNotificationTask _ContactPerson
_Employee _QltyNotificationTask _Employee
_Customer _QltyNotificationTask _Customer
_Supplier _QltyNotificationTask _Supplier

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_QltyNotificationTask.
-- 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_QltyNotificationTask AS
SELECT
  _QltyNotificationTask.QualityNotification AS QualityNotification,
  _QltyNotificationTask.NotificationTask AS NotificationTask,
  _QltyNotificationTask.NotificationTaskText AS NotificationTaskText,
  _QltyNotificationTask.IsDeleted AS IsDeleted,
  _QltyNotificationTask.NotifTaskPlannedStartDate AS NotifTaskPlannedStartDate,
  _QltyNotificationTask.NotifTaskPlannedStartTime AS NotifTaskPlannedStartTime,
  _QltyNotificationTask.NotifTaskPlannedEndDate AS NotifTaskPlannedEndDate,
  _QltyNotificationTask.NotifTaskPlannedEndTime AS NotifTaskPlannedEndTime,
  _QltyNotificationTask.StatusObject AS StatusObject,
  _QltyNotificationTask.NotifTaskCompletedByUser AS NotifTaskCompletedByUser,
  _QltyNotificationTask.NotifTaskCompletionDate AS NotifTaskCompletionDate,
  _QltyNotificationTask.NotifTaskCompletionTime AS NotifTaskCompletionTime,
  _QltyNotificationTask.ResponsiblePersonFunctionCode AS ResponsiblePersonFunctionCode,
  _QltyNotificationTask.PersonResponsible AS PersonResponsible,
  _QltyNotificationTask.NotificationTaskSortNumber AS NotificationTaskSortNumber,
  _QltyNotificationTask.NotificationItem AS NotificationItem,
  _QltyNotificationTask.NotificationCauseID AS NotificationCauseID,
  _QltyNotificationTask.QualityTaskCodeCatalog AS QualityTaskCodeCatalog,
  _QltyNotificationTask.QualityTaskCodeGroup AS QualityTaskCodeGroup,
  _QltyNotificationTask.QualityTaskCode AS QualityTaskCode,
  _QltyNotificationTask.QltyTaskTimeBasedEffort AS QltyTaskTimeBasedEffort,
  _QltyNotificationTask.QltyTaskTimeBasedEffortUoM AS QltyTaskTimeBasedEffortUoM,
  _QltyNotificationTask.CreatedByUser AS CreatedByUser,
  _QltyNotificationTask.CreationDate AS CreationDate,
  _QltyNotificationTask.CreationTime AS CreationTime,
  _QltyNotificationTask.LastChangedByUser AS LastChangedByUser,
  _QltyNotificationTask.LastChangeDate AS LastChangeDate,
  _QltyNotificationTask.LastChangeTime AS LastChangeTime,
  _QltyNotificationTask.NotificationType AS NotificationType,
  _QltyNotificationTask.Plant AS Plant,
  _QltyNotificationTask.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _QltyNotificationTask._PartnerFunction AS _PartnerFunction,
  _QltyNotificationTask._ContactPerson AS _ContactPerson,
  _QltyNotificationTask._Employee AS _Employee,
  _QltyNotificationTask._Customer AS _Customer,
  _QltyNotificationTask._Supplier AS _Supplier
FROM R_QltyNotificationTaskTP
;

Learn More