C_DefectTaskRecord
Record Defect Task
C_DefectTaskRecord is a Consumption CDS View that provides data about "Record Defect Task" in SAP S/4HANA. It reads from 1 data source (I_QualityTaskTP) and exposes 32 fields with key field QualityTaskInternalId. It has 2 associations to related views. Part of development package ODATA_QM_DEFECT.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_QualityTaskTP | I_QualityTaskTP | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | C_DefectRecord | _DefectRecord | $projection.DefectInternalID = _DefectRecord.DefectInternalID |
| [0..1] | C_DefectQltyTskProcsrNotes | _DefectQltyTskProcsrNotes | $projection.QualityTaskInternalId = _DefectQltyTskProcsrNotes.QualityTaskInternalId and $projection.MasterLanguage = _DefectQltyTskProcsrNotes.Language and _DefectQltyTskProcsrNotes.ItemCounter = 1 |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CDEFTSKREC | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| VDM.viewType | #CONSUMPTION | view | |
| EndUserText.label | Record Defect Task | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.representativeKey | QualityTaskInternalId | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.compositionRoot | false | view | |
| ObjectModel.transactionalProcessingDelegated | true | view | |
| ObjectModel.draftEnabled | false | view | |
| ObjectModel.createEnabled | false | view | |
| ObjectModel.updateEnabled | false | view | |
| ObjectModel.deleteEnabled | false | view |
Fields (32)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | QualityTaskInternalId | QualityTaskInternalId | ||
| QualityTask | QualityTask | |||
| QualityTaskOrigin | QualityTaskOrigin | |||
| QualityTaskText | QualityTaskText | |||
| QualityTaskLifecycleStatus | QualityTaskLifecycleStatus | |||
| QualityTaskArchivingStatus | QualityTaskArchivingStatus | |||
| QualityTaskProcessor | QualityTaskProcessor | |||
| QltyTaskFollowUpAction | QltyTaskFollowUpAction | |||
| QltyTaskFllwUpActionSts | QltyTaskFllwUpActionSts | |||
| MasterLanguage | MasterLanguage | |||
| NotifTaskPlannedEndDateTime | NotifTaskPlannedEndDateTime | |||
| NotifTaskPlannedEndDate | NotifTaskPlannedEndDate | |||
| NotifTaskPlannedEndTime | NotifTaskPlannedEndTime | |||
| NotifTaskCompletionDateTime | NotifTaskCompletionDateTime | |||
| NotifTaskCompletionDate | NotifTaskCompletionDate | |||
| NotifTaskCompletionTime | NotifTaskCompletionTime | |||
| NotifTaskCompletedByUser | NotifTaskCompletedByUser | |||
| NotifTaskTimeZone | NotifTaskTimeZone | |||
| DefectInternalID | DefectInternalID | |||
| ChangedDateTime | ChangedDateTime | |||
| IsDeleted | IsDeleted | |||
| QltyTskProcgIsCtrldByTskOrigin | QltyTskProcgIsCtrldByTskOrigin | |||
| QltyTaskTimeBasedEffort | QltyTaskTimeBasedEffort | Time Effort for Task | ||
| QltyTaskTimeBasedEffortUoM | QltyTaskTimeBasedEffortUoM | |||
| _DefectRecord | _DefectRecord | |||
| _DefectQltyTskProcsrNotes | _DefectQltyTskProcsrNotes | |||
| _QualityTaskProcessor | _QualityTaskProcessor | |||
| _QualityTaskStatus | _QualityTaskStatus | |||
| _QltyTaskFollowUpAction | _QltyTaskFollowUpAction | |||
| _QltyTaskFllwUpActionSts | _QltyTaskFllwUpActionSts | |||
| _CompletedByUserContactCard | _CompletedByUserContactCard | |||
| _QaulityTaskTimeZone | _QaulityTaskTimeZone |
@AbapCatalog.sqlViewName: 'CDEFTSKREC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.privilegedAssociations: [ '_CompletedByUserContactCard' ]
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Record Defect Task'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
semanticKey: [ 'QualityTask' ],
representativeKey: 'QualityTaskInternalId',
usageType: {
dataClass: #TRANSACTIONAL,
sizeCategory: #L,
serviceQuality: #B },
// Begin Draft 2.0
compositionRoot: false,
transactionalProcessingDelegated: true,
draftEnabled: false,
createEnabled: false,
updateEnabled: false,
deleteEnabled: false
}
//for the edit function of active tasks in the app we need to ensure that all data is loaded (also if it is not displayed from beginning).
@UI.presentationVariant.requestAtLeast: [ 'DefectInternalID', 'QualityTaskOrigin', 'QualityTaskText', 'QualityTaskProcessor',
'MasterLanguage', 'ChangedDateTime', 'QualityTaskArchivingStatus',
'QualityTaskLifecycleStatus', 'QltyTskProcgIsCtrldByTskOrigin',
'_DefectQltyTskProcsrNotes.QualityTaskProcessorNotes',
'_DefectQltyTskProcsrNotes.QualityTaskProcsrNotesPreview' ]
@UI.presentationVariant: {
sortOrder: [{ by: 'NotifTaskCompletionDate', direction: #ASC },
{ by: 'NotifTaskCompletionTime', direction: #ASC }]
}
define view C_DefectTaskRecord as select from I_QualityTaskTP
association [1..1] to C_DefectRecord as _DefectRecord on $projection.DefectInternalID = _DefectRecord.DefectInternalID
association [0..1] to C_DefectQltyTskProcsrNotes as _DefectQltyTskProcsrNotes
on $projection.QualityTaskInternalId = _DefectQltyTskProcsrNotes.QualityTaskInternalId
and $projection.MasterLanguage = _DefectQltyTskProcsrNotes.Language
and _DefectQltyTskProcsrNotes.ItemCounter = 1
{
//=== Key Fields
@UI.hidden: true
key QualityTaskInternalId,
//=== Common Fields
/* ATTENTION: Please be aware that any change to the line item annotation here in the CDS view do not have any effect. please adopt the line
item annotations also directly in the app */
@UI.lineItem: [ { position: 10 },
{ position: 30, type: #FOR_ACTION, dataAction: 'BOPF:EDIT_TASK' } ]
@UI.textArrangement: #TEXT_SEPARATE
@ObjectModel.text: [ { exclude } ]
@ObjectModel: { readOnly: true }
@Consumption.semanticObject: 'QualityTask'
QualityTask,
@UI.hidden: true
QualityTaskOrigin,
@UI.lineItem: [{ position: 20 }]
@ObjectModel: { mandatory: true }
QualityTaskText,
@UI: { lineItem: [ { position: 30 } ], textArrangement: #TEXT_ONLY }
QualityTaskLifecycleStatus,
@UI.hidden
QualityTaskArchivingStatus,
@Consumption.valueHelpDefinition: [{ entity: {name: 'I_QltyBPWithUserStdVH', element: 'BusinessPartner' } }]
@UI: { lineItem: [ { position: 40 } ], textArrangement: #TEXT_FIRST }
QualityTaskProcessor,
@UI: { lineItem: [ { position: 50 } ], textArrangement: #TEXT_FIRST }
@Feature: 'QM_CE_DEFECT_AFFECTED_OBJ'
QltyTaskFollowUpAction,
@UI: { lineItem: [ { position: 50 } ], textArrangement: #TEXT_ONLY }
@Feature: 'QM_CE_DEFECT_AFFECTED_OBJ'
QltyTaskFllwUpActionSts,
@UI.hidden
MasterLanguage,
@Consumption.filter: { selectionType: #INTERVAL }
@ObjectModel.filter: { enabled: true }
@ObjectModel.sort: { enabled: true }
NotifTaskPlannedEndDateTime,
@UI.hidden: true
NotifTaskPlannedEndDate,
@UI.hidden: true
NotifTaskPlannedEndTime,
@ObjectModel.readOnly: true
@Consumption.filter: { selectionType: #INTERVAL }
@ObjectModel.filter: { enabled: true }
@ObjectModel.sort: { enabled: true }
NotifTaskCompletionDateTime,
@UI.hidden: true
NotifTaskCompletionDate,
@UI.hidden: true
NotifTaskCompletionTime,
@ObjectModel.readOnly: true
NotifTaskCompletedByUser,
NotifTaskTimeZone,
//=== Reference Object Fields
@UI.hidden: true
DefectInternalID,
//=== Administrative Data
@UI.hidden: true
ChangedDateTime,
@UI.hidden: true
IsDeleted,
@ObjectModel.readOnly: true
@UI.hidden: true
QltyTskProcgIsCtrldByTskOrigin,
////====Time Recording for Task
@EndUserText.label: 'Time Effort for Task '
@Semantics.quantity.unitOfMeasure: 'QltyTaskTimeBasedEffortUoM'
QltyTaskTimeBasedEffort,
@Consumption.filter.hidden: true
//@EndUserText.label: 'Unit'
@Consumption.valueHelpDefinition: [{ entity: {name: 'C_QltyTskProcTimeUnitVH', element: 'UnitOfMeasure' } }]
QltyTaskTimeBasedEffortUoM,
//=== Associations
_DefectRecord,
/*@UI:{
lineItem: [ //{ position: 40, value: '_DefectQltyTskProcsrNotes.QualityTaskProcessorNotes' },
//{ position: 50, value: '_DefectQltyTskProcsrNotes.QualityTaskProcsrNotesPreview' }
],
hidden: true
}*/
_DefectQltyTskProcsrNotes,
@Consumption.filter.hidden: true
_QualityTaskProcessor,
@Consumption.filter.hidden: true
_QualityTaskStatus,
@Consumption.filter.hidden: true
_QltyTaskFollowUpAction,
@Consumption.filter.hidden: true
_QltyTaskFllwUpActionSts,
@Consumption.filter.hidden: true
_CompletedByUserContactCard,
@Consumption.filter.hidden: true
_QaulityTaskTimeZone
} where IsDeleted <> 'X'
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA