R_QualityTaskTP

DDL: R_QUALITYTASKTP Type: view_entity TRANSACTIONAL
57 Fields 1 Data Sources 3 Associations

Quality Task

R_QualityTaskTP is a Transactional CDS View that provides data about "Quality Task" in SAP S/4HANA. It reads from 1 data source (I_QualityTask) and exposes 57 fields with key field QualityTaskInternalId. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_QualityTask _QualityTask from

Associations (3)

CardinalityTargetAliasCondition
[1..1] E_NotificationTask _Extension $projection.QualityTaskInternalId = _Extension.Notification and _Extension.NotificationTask = '0000'
[0..*] R_QltyTaskFllwUpActionParamTP _QltyTaskFllwUpActionParam
[0..*] R_QualityTaskLongTextTP _QualityTaskLongText

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Quality Task view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name QualityTask view
ObjectModel.representativeKey QualityTaskInternalId view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
Metadata.ignorePropagatedAnnotations true view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY QualityTaskInternalId I_QualityTask QualityTaskInternalId
QualityTask I_QualityTask QualityTask
QualityTaskOrigin I_QualityTask QualityTaskOrigin Task Origin
QualityTaskText I_QualityTask QualityTaskText
IsDeleted I_QualityTask IsDeleted TRUE
QualityTaskProcessor I_QualityTask QualityTaskProcessor User Name
MasterLanguage
NotifTaskCompletedByUser I_QualityTask NotifTaskCompletedByUser
QualityTaskType I_QualityTask QualityTaskType Task Type
QualityTaskCodeCatalog I_QualityTask QualityTaskCodeCatalog Catalog type
QualityTaskCodeGroup I_QualityTask QualityTaskCodeGroup
QualityTaskCode I_QualityTask QualityTaskCode Task Code
NotifTaskTimeZone I_NotifTskTmeStampsInLoclTmeZn NotifTaskTimeZone Task Time Zone
NotifTaskPlannedEndDate I_NotifTskTmeStampsInLoclTmeZn NotifTaskPlannedEndDate
NotifTaskPlannedEndTime I_NotifTskTmeStampsInLoclTmeZn NotifTaskPlannedEndTime
NotifTaskCompletionDate I_NotifTskTmeStampsInLoclTmeZn NotifTaskCompletionDate
NotifTaskCompletionTime I_NotifTskTmeStampsInLoclTmeZn NotifTaskCompletionTime
NotifTaskResubmissionDate I_NotifTskTmeStampsInLoclTmeZn NotifTaskResubmissionDate Resubmission
NotifTaskResubmissionTime I_NotifTskTmeStampsInLoclTmeZn NotifTaskResubmissionTime Resubmission Time
DefectInternalID I_QualityTask DefectInternalID Internal Defect ID
PredecessorQltyTaskIntNumber I_QualityTask PredecessorQltyTaskIntNumber Predecessor Task Internal ID
ProbSolvingProc I_QualityTask ProbSolvingProc Problem-Solving Process
ProbSolvingProcStp I_QualityTask ProbSolvingProcStp Problem-Solving Step
ProbSolvingProcCause I_QualityTask ProbSolvingProcCause Cause
QltyTaskFollowUpAction I_QualityTask QltyTaskFollowUpAction Follow-Up Actn
QualityTaskLifecycleStatus I_QualityTask QualityTaskLifecycleStatus Task Status
QualityTaskArchivingStatus I_QualityTask QualityTaskArchivingStatus Task Archiving Status
QltyTaskFllwUpActionSts I_QualityTask QltyTaskFllwUpActionSts Follow-Up Action Status
CreatedByUser I_QualityTask CreatedByUser User Name
CreationDate I_QualityTask CreationDate Time Stamp
CreationTime I_QualityTask CreationTime Time of Change
ChangedDateTime I_QualityTask ChangedDateTime Time Stamp
LastChangeDate I_QualityTask LastChangeDate Time Stamp
LastChangeTime I_QualityTask LastChangeTime Time changed
LastChangedByUser I_QualityTask LastChangedByUser User Name
QltyTskProcgIsCtrldByTskOrigin I_QualityTask QltyTskProcgIsCtrldByTskOrigin Task Processing Is Controlled by Origin
QltyTaskTimeBasedEffort I_QualityTask QltyTaskTimeBasedEffort Time Effort
QltyTaskTimeBasedEffortUoM I_QualityTask QltyTaskTimeBasedEffortUoM Unit
_CompletedByUserContactCard I_QualityTask _CompletedByUserContactCard
_CreatedByUserContactCard I_QualityTask _CreatedByUserContactCard
_Defect I_QualityTask _Defect
_LastChangedByUserContactCard I_QualityTask _LastChangedByUserContactCard
_PredecessorQualityTask I_QualityTask _PredecessorQualityTask
_QaulityTaskTimeZone I_NotifTskTmeStampsInLoclTmeZn _QaulityTaskTimeZone
_QltyTaskArchivingStatus I_QualityTask _QltyTaskArchivingStatus
_QltyTaskFllwUpActionSts I_QualityTask _QltyTaskFllwUpActionSts
_QltyTaskFollowUpAction I_QualityTask _QltyTaskFollowUpAction
_QltyTskCode I_QualityTask _QltyTskCode
_QltyTskCodeGroup I_QualityTask _QltyTskCodeGroup
_QltyTskProcTimeUnit I_QualityTask _QltyTskProcTimeUnit
_QualityTaskOrigin I_QualityTask _QualityTaskOrigin
_QualityTaskProcessor I_QualityTask _QualityTaskProcessor
_QualityTaskStatus I_QualityTask _QualityTaskStatus
_QltyTaskFllwUpActionParam _QltyTaskFllwUpActionParam
_QualityTaskLongText _QualityTaskLongText
_QltyTaskDetailedDesc _QltyTaskDetailedDesc
_QltyTaskProcessorNote _QltyTaskProcessorNote

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 R_QualityTaskTP.
-- 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 R_QualityTaskTP AS
SELECT
  _QualityTask.QualityTaskInternalId AS QualityTaskInternalId,
  _QualityTask.QualityTask AS QualityTask,
  _QualityTask.QualityTaskOrigin AS QualityTaskOrigin,
  _QualityTask.QualityTaskText AS QualityTaskText,
  _QualityTask.IsDeleted AS IsDeleted,
  _QualityTask.QualityTaskProcessor AS QualityTaskProcessor,
  cast( _QualityTask.MasterLanguage as vdm_j_masterlanguage ) AS MasterLanguage,
  _QualityTask.NotifTaskCompletedByUser AS NotifTaskCompletedByUser,
  _QualityTask.QualityTaskType AS QualityTaskType,
  _QualityTask.QualityTaskCodeCatalog AS QualityTaskCodeCatalog,
  _QualityTask.QualityTaskCodeGroup AS QualityTaskCodeGroup,
  _QualityTask.QualityTaskCode AS QualityTaskCode,
  I_NotifTskTmeStampsInLoclTmeZn.NotifTaskTimeZone AS NotifTaskTimeZone,
  I_NotifTskTmeStampsInLoclTmeZn.NotifTaskPlannedEndDate AS NotifTaskPlannedEndDate,
  I_NotifTskTmeStampsInLoclTmeZn.NotifTaskPlannedEndTime AS NotifTaskPlannedEndTime,
  I_NotifTskTmeStampsInLoclTmeZn.NotifTaskCompletionDate AS NotifTaskCompletionDate,
  I_NotifTskTmeStampsInLoclTmeZn.NotifTaskCompletionTime AS NotifTaskCompletionTime,
  I_NotifTskTmeStampsInLoclTmeZn.NotifTaskResubmissionDate AS NotifTaskResubmissionDate,
  I_NotifTskTmeStampsInLoclTmeZn.NotifTaskResubmissionTime AS NotifTaskResubmissionTime,
  _QualityTask.DefectInternalID AS DefectInternalID,
  _QualityTask.PredecessorQltyTaskIntNumber AS PredecessorQltyTaskIntNumber,
  _QualityTask.ProbSolvingProc AS ProbSolvingProc,
  _QualityTask.ProbSolvingProcStp AS ProbSolvingProcStp,
  _QualityTask.ProbSolvingProcCause AS ProbSolvingProcCause,
  _QualityTask.QltyTaskFollowUpAction AS QltyTaskFollowUpAction,
  _QualityTask.QualityTaskLifecycleStatus AS QualityTaskLifecycleStatus,
  _QualityTask.QualityTaskArchivingStatus AS QualityTaskArchivingStatus,
  _QualityTask.QltyTaskFllwUpActionSts AS QltyTaskFllwUpActionSts,
  _QualityTask.CreatedByUser AS CreatedByUser,
  _QualityTask.CreationDate AS CreationDate,
  _QualityTask.CreationTime AS CreationTime,
  _QualityTask.ChangedDateTime AS ChangedDateTime,
  _QualityTask.LastChangeDate AS LastChangeDate,
  _QualityTask.LastChangeTime AS LastChangeTime,
  _QualityTask.LastChangedByUser AS LastChangedByUser,
  _QualityTask.QltyTskProcgIsCtrldByTskOrigin AS QltyTskProcgIsCtrldByTskOrigin,
  _QualityTask.QltyTaskTimeBasedEffort AS QltyTaskTimeBasedEffort,
  _QualityTask.QltyTaskTimeBasedEffortUoM AS QltyTaskTimeBasedEffortUoM,
  _QualityTask._CompletedByUserContactCard AS _CompletedByUserContactCard,
  _QualityTask._CreatedByUserContactCard AS _CreatedByUserContactCard,
  _QualityTask._Defect AS _Defect,
  _QualityTask._LastChangedByUserContactCard AS _LastChangedByUserContactCard,
  _QualityTask._PredecessorQualityTask AS _PredecessorQualityTask,
  I_NotifTskTmeStampsInLoclTmeZn._QaulityTaskTimeZone AS _QaulityTaskTimeZone,
  _QualityTask._QltyTaskArchivingStatus AS _QltyTaskArchivingStatus,
  _QualityTask._QltyTaskFllwUpActionSts AS _QltyTaskFllwUpActionSts,
  _QualityTask._QltyTaskFollowUpAction AS _QltyTaskFollowUpAction,
  _QualityTask._QltyTskCode AS _QltyTskCode,
  _QualityTask._QltyTskCodeGroup AS _QltyTskCodeGroup,
  _QualityTask._QltyTskProcTimeUnit AS _QltyTskProcTimeUnit,
  _QualityTask._QualityTaskOrigin AS _QualityTaskOrigin,
  _QualityTask._QualityTaskProcessor AS _QualityTaskProcessor,
  _QualityTask._QualityTaskStatus AS _QualityTaskStatus
FROM I_QualityTask AS _QualityTask
LEFT OUTER JOIN E_NotificationTask AS _Extension ON QualityTaskInternalId = _Extension.Notification AND _Extension.NotificationTask = '0000'  -- association [1..1]
LEFT OUTER JOIN R_QltyTaskFllwUpActionParamTP AS _QltyTaskFllwUpActionParam ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_QualityTaskLongTextTP AS _QualityTaskLongText ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More