I_QUALITYTASK
Quality Task
I_QUALITYTASK is a CDS View in S/4HANA. Quality Task. It contains 46 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| ESH_N_QUALITYTASK | view | from | ||
| I_QualityTaskTP | view | from | TRANSACTIONAL | Quality Task |
| P_DefectAffcdObjActnParam | view | inner | COMPOSITE | |
| R_QualityTaskTP | view_entity | from | TRANSACTIONAL | Quality Task |
Fields (46)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DefectInternalID | DefectInternalID | 3 |
| KEY | QualityTaskInternalId | QualityTaskInternalId | 3 |
| _CompletedByUserContactCard | _CompletedByUserContactCard | 2 | |
| _CreatedByUserContactCard | _CreatedByUserContactCard | 2 | |
| _Defect | _Defect | 1 | |
| _LastChangedByUserContactCard | _LastChangedByUserContactCard | 2 | |
| _PredecessorQualityTask | _PredecessorQualityTask | 2 | |
| _QltyTaskArchivingStatus | _QltyTaskArchivingStatus | 2 | |
| _QltyTaskFllwUpActionSts | _QltyTaskFllwUpActionSts | 2 | |
| _QltyTaskFollowUpAction | _QltyTaskFollowUpAction | 2 | |
| _QltyTskCode | _QltyTskCode | 2 | |
| _QltyTskCodeGroup | _QltyTskCodeGroup | 2 | |
| _QltyTskProcTimeUnit | _QltyTskProcTimeUnit | 2 | |
| _QualityTaskOrigin | _QualityTaskOrigin | 2 | |
| _QualityTaskProcessor | _QualityTaskProcessor | 2 | |
| _QualityTaskStatus | _QualityTaskStatus | 2 | |
| _QualityTaskType | _QualityTaskType | 1 | |
| ChangedDateTime | ChangedDateTime | 3 | |
| CreatedByUser | CreatedByUser | 2 | |
| CreationDate | CreationDate | 1 | |
| CreationTime | CreationTime | 1 | |
| IsDeleted | IsDeleted | 2 | |
| LastChangeDate | LastChangeDate | 1 | |
| LastChangedByUser | LastChangedByUser | 2 | |
| LastChangeTime | LastChangeTime | 1 | |
| MasterLanguage | MasterLanguage | 1 | |
| NotifTaskCompletedByUser | NotifTaskCompletedByUser | 2 | |
| PredecessorQltyTaskIntNumber | PredecessorQltyTaskIntNumber | 2 | |
| ProbSolvingProc | ProbSolvingProc | 2 | |
| ProbSolvingProcCause | ProbSolvingProcCause | 2 | |
| ProbSolvingProcStp | ProbSolvingProcStp | 2 | |
| QltyTaskFllwUpActionSts | QltyTaskFllwUpActionSts | 3 | |
| QltyTaskFollowUpAction | QltyTaskFollowUpAction | 3 | |
| QltyTaskTimeBasedEffort | QltyTaskTimeBasedEffort | 2 | |
| QltyTaskTimeBasedEffortUoM | QltyTaskTimeBasedEffortUoM | 2 | |
| QltyTskProcgIsCtrldByTskOrigin | QltyTskProcgIsCtrldByTskOrigin | 2 | |
| QualityTask | QualityTask | 3 | |
| QualityTaskArchivingStatus | QualityTaskArchivingStatus | 2 | |
| QualityTaskCode | QualityTaskCode | 2 | |
| QualityTaskCodeCatalog | QualityTaskCodeCatalog | 2 | |
| QualityTaskCodeGroup | QualityTaskCodeGroup | 2 | |
| QualityTaskLifecycleStatus | QualityTaskLifecycleStatus | 2 | |
| QualityTaskOrigin | QualityTaskOrigin | 2 | |
| QualityTaskProcessor | QualityTaskProcessor | 2 | |
| QualityTaskText | QualityTaskText | 2 | |
| QualityTaskType | QualityTaskType | 2 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Quality Task
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_QUALITYTASK (
DEFECTINTERNALID,
QUALITYTASKINTERNALID,
_COMPLETEDBYUSERCONTACTCARD,
_CREATEDBYUSERCONTACTCARD,
_DEFECT,
_LASTCHANGEDBYUSERCONTACTCARD,
_PREDECESSORQUALITYTASK,
_QLTYTASKARCHIVINGSTATUS,
_QLTYTASKFLLWUPACTIONSTS,
_QLTYTASKFOLLOWUPACTION,
_QLTYTSKCODE,
_QLTYTSKCODEGROUP,
_QLTYTSKPROCTIMEUNIT,
_QUALITYTASKORIGIN,
_QUALITYTASKPROCESSOR,
_QUALITYTASKSTATUS,
_QUALITYTASKTYPE,
CHANGEDDATETIME,
CREATEDBYUSER,
CREATIONDATE,
CREATIONTIME,
ISDELETED,
LASTCHANGEDATE,
LASTCHANGEDBYUSER,
LASTCHANGETIME,
MASTERLANGUAGE,
NOTIFTASKCOMPLETEDBYUSER,
PREDECESSORQLTYTASKINTNUMBER,
PROBSOLVINGPROC,
PROBSOLVINGPROCCAUSE,
PROBSOLVINGPROCSTP,
QLTYTASKFLLWUPACTIONSTS,
QLTYTASKFOLLOWUPACTION,
QLTYTASKTIMEBASEDEFFORT,
QLTYTASKTIMEBASEDEFFORTUOM,
QLTYTSKPROCGISCTRLDBYTSKORIGIN,
QUALITYTASK,
QUALITYTASKARCHIVINGSTATUS,
QUALITYTASKCODE,
QUALITYTASKCODECATALOG,
QUALITYTASKCODEGROUP,
QUALITYTASKLIFECYCLESTATUS,
QUALITYTASKORIGIN,
QUALITYTASKPROCESSOR,
QUALITYTASKTEXT,
QUALITYTASKTYPE,
PRIMARY KEY (DEFECTINTERNALID, QUALITYTASKINTERNALID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA