C_DefectTaskFDP

DDL: C_DEFECTTASKFDP Type: view_entity CONSUMPTION Package: ODATA_QM_DEFECT

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)

SourceAliasJoin Type
I_QualityTask _QualityTask from

Associations (2)

CardinalityTargetAliasCondition
[0..1] C_DefectFDP _Defect $projection.DefectInternalID = _Defect.DefectInternalID
[0..*] I_UnitOfMeasureText _TimeBasedEffortUnitText $projection.QltyTaskTimeBasedEffortUoM = _TimeBasedEffortUnitText.UnitOfMeasure

Annotations (13)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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