C_DefectTaskFDP
FDP view for QM Defect Task
C_DefectTaskFDP is a Consumption CDS View that provides data about "FDP view for QM Defect Task" in SAP S/4HANA. It reads from 1 data source (I_QualityTask) and exposes 44 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_QualityTask | _QualityTask | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | C_DefectFDP | _Defect | $projection.DefectInternalID = _Defect.DefectInternalID |
| [0..*] | I_UnitOfMeasureText | _TimeBasedEffortUnitText | $projection.QltyTaskTimeBasedEffortUoM = _TimeBasedEffortUnitText.UnitOfMeasure |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| EndUserText.label | FDP view for QM Defect Task | view | |
| VDM.viewType | #CONSUMPTION | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| ObjectModel.modelingPattern | #OUTPUT_FORM_DATA_PROVIDER | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.representativeKey | QualityTaskInternalId | view | |
| Metadata.allowExtensions | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Consumption.semanticObject | Defect | view |
Fields (44)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | QualityTaskInternalId | I_QualityTask | QualityTaskInternalId | |
| QualityTask | I_QualityTask | QualityTask | ||
| QualityTaskOrigin | I_QualityTask | QualityTaskOrigin | ||
| QualityTaskOriginText | ||||
| QualityTaskText | I_QualityTask | QualityTaskText | ||
| QualityTaskProcessor | I_QualityTask | QualityTaskProcessor | ||
| QualityTaskProcessorFullName | _QualityTaskProcessor | FullName | ||
| MasterLanguage | ||||
| NotifTaskCompletedByUser | I_QualityTask | NotifTaskCompletedByUser | ||
| QualityTaskType | I_QualityTask | QualityTaskType | ||
| QualityTaskTypeText | ||||
| QualityTaskCodeCatalog | I_QualityTask | QualityTaskCodeCatalog | ||
| QualityTaskCodeGroup | I_QualityTask | QualityTaskCodeGroup | ||
| QualityTaskCodeGroupText | ||||
| QualityTaskCode | I_QualityTask | QualityTaskCode | ||
| QualityTaskCodeText | ||||
| NotifTaskTimeZone | I_QualityTask | NotifTaskTimeZone | ||
| NotifTaskPlannedEndDate | I_QualityTask | NotifTaskPlannedEndDate | ||
| NotifTaskPlannedEndTime | I_QualityTask | NotifTaskPlannedEndTime | ||
| NotifTaskCompletionDate | I_QualityTask | NotifTaskCompletionDate | ||
| NotifTaskCompletionTime | I_QualityTask | NotifTaskCompletionTime | ||
| NotifTaskResubmissionDate | I_QualityTask | NotifTaskResubmissionDate | ||
| NotifTaskResubmissionTime | I_QualityTask | NotifTaskResubmissionTime | ||
| DefectInternalID | I_QualityTask | DefectInternalID | ||
| QltyTaskFollowUpAction | I_QualityTask | QltyTaskFollowUpAction | ||
| QltyTaskFollowUpActionText | ||||
| QualityTaskLifecycleStatus | I_QualityTask | QualityTaskLifecycleStatus | ||
| QualityTaskLifecycleStatusText | ||||
| QualityTaskArchivingStatus | I_QualityTask | QualityTaskArchivingStatus | ||
| QltyTaskFllwUpActionSts | I_QualityTask | QltyTaskFllwUpActionSts | ||
| QltyTaskFllwUpActionStsTxt | ||||
| CreatedByUser | I_QualityTask | CreatedByUser | ||
| CreatedByUserDescription | ||||
| CreationDate | I_QualityTask | CreationDate | ||
| CreationTime | I_QualityTask | CreationTime | ||
| ChangedDateTime | I_QualityTask | ChangedDateTime | ||
| LastChangeDate | I_QualityTask | LastChangeDate | ||
| LastChangeTime | I_QualityTask | LastChangeTime | ||
| LastChangedByUser | I_QualityTask | LastChangedByUser | ||
| LastChangedByUserDescription | ||||
| QltyTaskTimeBasedEffort | QltyTaskTimeBasedEffort | |||
| QltyTaskTimeBasedEffortUoM | QltyTaskTimeBasedEffortUoM | |||
| _Defect | _Defect | |||
| _TimeBasedEffortUnitText | _TimeBasedEffortUnitText |
@AccessControl: {
authorizationCheck: #MANDATORY,
personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@EndUserText.label: 'FDP view for QM Defect Task'
@VDM: {
viewType: #CONSUMPTION,
lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel.supportedCapabilities:
[ #OUTPUT_FORM_DATA_PROVIDER ]
@ObjectModel.modelingPattern: #OUTPUT_FORM_DATA_PROVIDER
@ObjectModel: {
usageType: {
dataClass: #TRANSACTIONAL,
sizeCategory: #L,
serviceQuality: #D },
representativeKey: 'QualityTaskInternalId',
semanticKey: [ 'QualityTask' ]
}
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@Consumption.semanticObject: 'Defect'
define view entity C_DefectTaskFDP as select from I_QualityTask as _QualityTask
association [0..1] to C_DefectFDP as _Defect on $projection.DefectInternalID = _Defect.DefectInternalID
// new associations for text fields
association [0..*] to I_UnitOfMeasureText as _TimeBasedEffortUnitText on $projection.QltyTaskTimeBasedEffortUoM = _TimeBasedEffortUnitText.UnitOfMeasure
{
key _QualityTask.QualityTaskInternalId,
_QualityTask.QualityTask,
_QualityTask.QualityTaskOrigin,
_QualityTaskOrigin._Text[ 1: Language = $session.system_language ].QualityTaskOriginText,
@Semantics.text: true
_QualityTask.QualityTaskText,
_QualityTask.QualityTaskProcessor,
_QualityTaskProcessor.FullName as QualityTaskProcessorFullName,
cast( _QualityTask.MasterLanguage as vdm_j_masterlanguage ) as MasterLanguage,
_QualityTask.NotifTaskCompletedByUser,
// TODO: UserDescription/ FullName
_QualityTask.QualityTaskType,
_QualityTaskType._QualityTaskTypeText[ 1: Language = $session.system_language ].QualityTaskTypeText,
_QualityTask.QualityTaskCodeCatalog,
_QualityTask.QualityTaskCodeGroup,
_QltyTskCodeGroup._QltyTskCodeGroupText[ 1: Language = $session.system_language ].QualityTaskCodeGroupText,
_QualityTask.QualityTaskCode,
_QltyTskCode._QltyTskCodeText[ 1: Language = $session.system_language ].QualityTaskCodeText,
_QualityTask.NotifTaskTimeZone,
_QualityTask.NotifTaskPlannedEndDate,
_QualityTask.NotifTaskPlannedEndTime,
_QualityTask.NotifTaskCompletionDate,
_QualityTask.NotifTaskCompletionTime,
@Consumption.hidden: true
_QualityTask.NotifTaskResubmissionDate,
@Consumption.hidden: true
_QualityTask.NotifTaskResubmissionTime,
@ObjectModel.foreignKey.association: '_Defect'
@Consumption.hidden: true
_QualityTask.DefectInternalID,
_QualityTask.QltyTaskFollowUpAction,
_QltyTaskFollowUpAction._QltyTaskFollowUpActionText[ 1: Language = $session.system_language ].QltyTaskFollowUpActionText,
_QualityTask.QualityTaskLifecycleStatus,
_QualityTaskStatus._QualityTaskStatusText[ 1: Language = $session.system_language ].QualityTaskLifecycleStatusText,
@Consumption.hidden: true
_QualityTask.QualityTaskArchivingStatus,
_QualityTask.QltyTaskFllwUpActionSts,
_QltyTaskFllwUpActionSts._QltyTaskFllwUpActionStsTxt[ 1: Language = $session.system_language ].QltyTaskFllwUpActionStsTxt,
_QualityTask.CreatedByUser,
cast( _CreatedByUserContactCard.FullName as vdm_createdbyuserdescription preserving type ) as CreatedByUserDescription,
_QualityTask.CreationDate,
_QualityTask.CreationTime,
@Consumption.hidden: true
_QualityTask.ChangedDateTime,
_QualityTask.LastChangeDate,
_QualityTask.LastChangeTime,
_QualityTask.LastChangedByUser,
cast( _LastChangedByUserContactCard.FullName as vdm_lastchangedbyuserdescripti preserving type ) as LastChangedByUserDescription,
@Semantics.quantity.unitOfMeasure: 'QltyTaskTimeBasedEffortUoM'
QltyTaskTimeBasedEffort,
@ObjectModel.text.association: '_TimeBasedEffortUnitText'
QltyTaskTimeBasedEffortUoM,
/* Associations */
_Defect,
_TimeBasedEffortUnitText
} where QualityTaskOrigin = '01' // Only tasks related to a defect
and IsDeleted is initial
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