I_MfgQualityTaskHistory

DDL: I_MFGQUALITYTASKHISTORY SQL: IQULTYTSK Type: view BASIC
24 Fields 1 Data Sources

Quality Task History

I_MfgQualityTaskHistory is a Basic CDS View that provides data about "Quality Task History" in SAP S/4HANA. It reads from 1 data source (P_MfgNotifFollowUpActnHistory) and exposes 24 fields with key fields Notification, NotificationTask.

Data Sources (1)

SourceAliasJoin Type
P_MfgNotifFollowUpActnHistory FollowUpAction from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IQULTYTSK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Quality Task History view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Notification P_MfgNotifFollowUpActnHistory Notification Notification
KEY NotificationTask P_MfgNotifFollowUpActnHistory NotificationTask Task
NotificationItem P_MfgNotifFollowUpActnHistory NotificationItem Number of days
DefectInternalID P_MfgNotifFollowUpActnHistory DefectInternalID Internal Defect ID
QltyTaskFollowUpAction P_MfgNotifFollowUpActnHistory QltyTaskFollowUpAction Follow-Up Actn
QltyTaskFllwUpActionSts P_MfgNotifFollowUpActnHistory QltyTaskFllwUpActionSts Follow-Up Action Status
CreatedByUser P_MfgNotifFollowUpActnHistory CreatedByUser User Name
CreationDate P_MfgNotifFollowUpActnHistory CreationDate Time Stamp
CreationTime P_MfgNotifFollowUpActnHistory CreationTime Time of Change
QualityTaskCodeCatalog P_MfgNotifFollowUpActnHistory QualityTaskCodeCatalog
QualityTaskCodeGroup P_MfgNotifFollowUpActnHistory QualityTaskCodeGroup
QualityTaskCode P_MfgNotifFollowUpActnHistory QualityTaskCode Task Code
QualityTaskOrigin P_MfgNotifFollowUpActnHistory QualityTaskOrigin Task Origin
ResponsiblePersonName P_MfgNotifFollowUpActnHistory ResponsiblePerson Processor
QualityTaskProcessor P_MfgNotifFollowUpActnHistory QualityTaskProcessor User Name
ResponsiblePersonFunctionCode P_MfgNotifFollowUpActnHistory ResponsiblePersonFunctionCode
QualityTaskText P_MfgNotifFollowUpActnHistory QualityTaskText Task Text
_ContactPerson P_MfgNotifFollowUpActnHistory _ContactPerson
_Customer P_MfgNotifFollowUpActnHistory _Customer
_Employee P_MfgNotifFollowUpActnHistory _Employee
_Notification P_MfgNotifFollowUpActnHistory _Notification
_PartnerFunction P_MfgNotifFollowUpActnHistory _PartnerFunction
_QualityTaskProcessor P_MfgNotifFollowUpActnHistory _QualityTaskProcessor
_Supplier P_MfgNotifFollowUpActnHistory _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 I_MfgQualityTaskHistory.
-- 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: IQULTYTSK

CREATE VIEW I_MfgQualityTaskHistory AS
SELECT
  FollowUpAction.Notification AS Notification,
  FollowUpAction.NotificationTask AS NotificationTask,
  FollowUpAction.NotificationItem AS NotificationItem,
  FollowUpAction.DefectInternalID AS DefectInternalID,
  FollowUpAction.QltyTaskFollowUpAction AS QltyTaskFollowUpAction,
  FollowUpAction.QltyTaskFllwUpActionSts AS QltyTaskFllwUpActionSts,
  FollowUpAction.CreatedByUser AS CreatedByUser,
  FollowUpAction.CreationDate AS CreationDate,
  FollowUpAction.CreationTime AS CreationTime,
  FollowUpAction.QualityTaskCodeCatalog AS QualityTaskCodeCatalog,
  FollowUpAction.QualityTaskCodeGroup AS QualityTaskCodeGroup,
  FollowUpAction.QualityTaskCode AS QualityTaskCode,
  FollowUpAction.QualityTaskOrigin AS QualityTaskOrigin,
  FollowUpAction.ResponsiblePerson AS ResponsiblePersonName,
  FollowUpAction.QualityTaskProcessor AS QualityTaskProcessor,
  FollowUpAction.ResponsiblePersonFunctionCode AS ResponsiblePersonFunctionCode,
  FollowUpAction.QualityTaskText AS QualityTaskText,
  FollowUpAction._ContactPerson AS _ContactPerson,
  FollowUpAction._Customer AS _Customer,
  FollowUpAction._Employee AS _Employee,
  FollowUpAction._Notification AS _Notification,
  FollowUpAction._PartnerFunction AS _PartnerFunction,
  FollowUpAction._QualityTaskProcessor AS _QualityTaskProcessor,
  FollowUpAction._Supplier AS _Supplier
FROM P_MfgNotifFollowUpActnHistory AS FollowUpAction
;

Learn More