C_DefectTaskFDP

DDL: C_DEFECTTASKFDP SQL: CDEFECTTFDP Type: view CONSUMPTION

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_QualityTaskTP) and exposes 37 fields with key field QualityTaskInternalId.

Data Sources (1)

SourceAliasJoin Type
I_QualityTaskTP _QualityTaskTP from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CDEFECTTFDP view
AbapCatalog.compiler.compareFilter true view
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.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey QualityTaskInternalId view
Metadata.allowExtensions true view
Consumption.semanticObject Defect view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY QualityTaskInternalId I_QualityTaskTP QualityTaskInternalId
QualityTask I_QualityTaskTP QualityTask
QualityTaskOrigin I_QualityTaskTP QualityTaskOrigin
QualityTaskText I_QualityTaskTP QualityTaskText
QualityTaskProcessor I_QualityTaskTP QualityTaskProcessor
MasterLanguage I_QualityTaskTP MasterLanguage
NotifTaskCompletedByUser I_QualityTaskTP NotifTaskCompletedByUser
QualityTaskType I_QualityTaskTP QualityTaskType
QualityTaskCodeCatalog I_QualityTaskTP QualityTaskCodeCatalog
QualityTaskCodeGroup I_QualityTaskTP QualityTaskCodeGroup
QualityTaskCode I_QualityTaskTP QualityTaskCode
NotifTaskTimeZone I_QualityTaskTP NotifTaskTimeZone
NotifTaskPlannedEndDate I_QualityTaskTP NotifTaskPlannedEndDate
NotifTaskPlannedEndTime I_QualityTaskTP NotifTaskPlannedEndTime
NotifTaskCompletionDate I_QualityTaskTP NotifTaskCompletionDate
NotifTaskCompletionTime I_QualityTaskTP NotifTaskCompletionTime
NotifTaskResubmissionDate I_QualityTaskTP NotifTaskResubmissionDate
NotifTaskResubmissionTime I_QualityTaskTP NotifTaskResubmissionTime
DefectInternalID I_QualityTaskTP DefectInternalID
PredecessorQltyTaskIntNumber I_QualityTaskTP PredecessorQltyTaskIntNumber
ProbSolvingProc I_QualityTaskTP ProbSolvingProc
ProbSolvingProcStp I_QualityTaskTP ProbSolvingProcStp
ProbSolvingProcCause I_QualityTaskTP ProbSolvingProcCause
QltyTaskFollowUpAction I_QualityTaskTP QltyTaskFollowUpAction
QltyTskFllwUpActnConfignVal I_QualityTaskTP QltyTskFllwUpActnConfignVal
QualityTaskLifecycleStatus
QualityTaskArchivingStatus I_QualityTaskTP QualityTaskArchivingStatus
QltyTaskFllwUpActionSts I_QualityTaskTP QltyTaskFllwUpActionSts
CreatedByUser I_QualityTaskTP CreatedByUser
CreationDate I_QualityTaskTP CreationDate
CreationTime I_QualityTaskTP CreationTime
ChangedDateTime I_QualityTaskTP ChangedDateTime
LastChangeDate I_QualityTaskTP LastChangeDate
LastChangeTime I_QualityTaskTP LastChangeTime
LastChangedByUser I_QualityTaskTP LastChangedByUser
QltyTaskTimeBasedEffort QltyTaskTimeBasedEffort
QltyTaskTimeBasedEffortUoM QltyTaskTimeBasedEffortUoM
@AbapCatalog.sqlViewName: 'CDEFECTTFDP'
@AbapCatalog.compiler.compareFilter: true
@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: {
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #L,
        serviceQuality: #A },
    representativeKey: 'QualityTaskInternalId',
    semanticKey:  [ 'QualityTask' ]
}
@Metadata.allowExtensions: true
@Consumption.semanticObject: 'Defect'
@ClientHandling.algorithm: #SESSION_VARIABLE

define view C_DefectTaskFDP as select from I_QualityTaskTP as _QualityTaskTP
{
  @ObjectModel.readOnly: true
  key _QualityTaskTP.QualityTaskInternalId,
  @ObjectModel.readOnly: true
  _QualityTaskTP.QualityTask,
  @ObjectModel.readOnly: true
  _QualityTaskTP.QualityTaskOrigin,
  @ObjectModel.readOnly: true
  _QualityTaskTP.QualityTaskText,
  @ObjectModel.readOnly: true
  _QualityTaskTP.QualityTaskProcessor,
  @ObjectModel.readOnly: true
  _QualityTaskTP.MasterLanguage,
  @ObjectModel.readOnly: true
  _QualityTaskTP.NotifTaskCompletedByUser,
  @ObjectModel.readOnly: true
  _QualityTaskTP.QualityTaskType,
  @ObjectModel.readOnly: true
  _QualityTaskTP.QualityTaskCodeCatalog,
  @ObjectModel.readOnly: true
  _QualityTaskTP.QualityTaskCodeGroup,
  @ObjectModel.readOnly: true
  _QualityTaskTP.QualityTaskCode,
  @ObjectModel.readOnly: true
  _QualityTaskTP.NotifTaskTimeZone,
  @ObjectModel.readOnly: true
  _QualityTaskTP.NotifTaskPlannedEndDate,
  @ObjectModel.readOnly: true
  _QualityTaskTP.NotifTaskPlannedEndTime,
  @ObjectModel.readOnly: true
  _QualityTaskTP.NotifTaskCompletionDate,
  @ObjectModel.readOnly: true
  _QualityTaskTP.NotifTaskCompletionTime,
  @ObjectModel.readOnly: true
  _QualityTaskTP.NotifTaskResubmissionDate,
  @ObjectModel.readOnly: true
  _QualityTaskTP.NotifTaskResubmissionTime,
  @ObjectModel.readOnly: true
  _QualityTaskTP.DefectInternalID,
  @ObjectModel.readOnly: true
  _QualityTaskTP.PredecessorQltyTaskIntNumber,
  @ObjectModel.readOnly: true
  _QualityTaskTP.ProbSolvingProc,
  @ObjectModel.readOnly: true
  _QualityTaskTP.ProbSolvingProcStp,
  @ObjectModel.readOnly: true
  _QualityTaskTP.ProbSolvingProcCause,
  @ObjectModel.readOnly: true
  _QualityTaskTP.QltyTaskFollowUpAction,
  @ObjectModel.readOnly: true
  _QualityTaskTP.QltyTskFllwUpActnConfignVal,
  @ObjectModel.readOnly: true
 _QualityTaskTP. QualityTaskLifecycleStatus,
  @ObjectModel.readOnly: true
  _QualityTaskTP.QualityTaskArchivingStatus,
  @ObjectModel.readOnly: true
  _QualityTaskTP.QltyTaskFllwUpActionSts,
  @ObjectModel.readOnly: true
  _QualityTaskTP.CreatedByUser,
  @ObjectModel.readOnly: true
  _QualityTaskTP.CreationDate,
  @ObjectModel.readOnly: true
  _QualityTaskTP.CreationTime,
  @ObjectModel.readOnly: true
  _QualityTaskTP.ChangedDateTime,
  @ObjectModel.readOnly: true
  _QualityTaskTP.LastChangeDate,
  @ObjectModel.readOnly: true
  _QualityTaskTP.LastChangeTime,
  @ObjectModel.readOnly: true
  _QualityTaskTP.LastChangedByUser,
  @ObjectModel.readOnly: true
  QltyTaskTimeBasedEffort,
  @ObjectModel.readOnly: true
  QltyTaskTimeBasedEffortUoM

} where IsDeleted is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_QUALITYTASKTP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/