C_DefectTaskFDP

DDL: C_DEFECTTASKFDP SQL: CDEFECTTFDP Type: view CONSUMPTION
37 Fields 1 Data Sources

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 Primary lang.
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 Internal Defect ID
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 User Name
CreationDate I_QualityTaskTP CreationDate Time Stamp
CreationTime I_QualityTaskTP CreationTime Time of Change
ChangedDateTime I_QualityTaskTP ChangedDateTime Time Stamp
LastChangeDate I_QualityTaskTP LastChangeDate Time Stamp
LastChangeTime I_QualityTaskTP LastChangeTime Time changed
LastChangedByUser I_QualityTaskTP LastChangedByUser User Name
QltyTaskTimeBasedEffort QltyTaskTimeBasedEffort
QltyTaskTimeBasedEffortUoM QltyTaskTimeBasedEffortUoM

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_DefectTaskFDP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CDEFECTTFDP

CREATE VIEW C_DefectTaskFDP AS
SELECT
  _QualityTaskTP.QualityTaskInternalId AS QualityTaskInternalId,
  _QualityTaskTP.QualityTask AS QualityTask,
  _QualityTaskTP.QualityTaskOrigin AS QualityTaskOrigin,
  _QualityTaskTP.QualityTaskText AS QualityTaskText,
  _QualityTaskTP.QualityTaskProcessor AS QualityTaskProcessor,
  _QualityTaskTP.MasterLanguage AS MasterLanguage,
  _QualityTaskTP.NotifTaskCompletedByUser AS NotifTaskCompletedByUser,
  _QualityTaskTP.QualityTaskType AS QualityTaskType,
  _QualityTaskTP.QualityTaskCodeCatalog AS QualityTaskCodeCatalog,
  _QualityTaskTP.QualityTaskCodeGroup AS QualityTaskCodeGroup,
  _QualityTaskTP.QualityTaskCode AS QualityTaskCode,
  _QualityTaskTP.NotifTaskTimeZone AS NotifTaskTimeZone,
  _QualityTaskTP.NotifTaskPlannedEndDate AS NotifTaskPlannedEndDate,
  _QualityTaskTP.NotifTaskPlannedEndTime AS NotifTaskPlannedEndTime,
  _QualityTaskTP.NotifTaskCompletionDate AS NotifTaskCompletionDate,
  _QualityTaskTP.NotifTaskCompletionTime AS NotifTaskCompletionTime,
  _QualityTaskTP.NotifTaskResubmissionDate AS NotifTaskResubmissionDate,
  _QualityTaskTP.NotifTaskResubmissionTime AS NotifTaskResubmissionTime,
  _QualityTaskTP.DefectInternalID AS DefectInternalID,
  _QualityTaskTP.PredecessorQltyTaskIntNumber AS PredecessorQltyTaskIntNumber,
  _QualityTaskTP.ProbSolvingProc AS ProbSolvingProc,
  _QualityTaskTP.ProbSolvingProcStp AS ProbSolvingProcStp,
  _QualityTaskTP.ProbSolvingProcCause AS ProbSolvingProcCause,
  _QualityTaskTP.QltyTaskFollowUpAction AS QltyTaskFollowUpAction,
  _QualityTaskTP.QltyTskFllwUpActnConfignVal AS QltyTskFllwUpActnConfignVal,
  _QualityTaskTP. QualityTaskLifecycleStatus AS QualityTaskLifecycleStatus,
  _QualityTaskTP.QualityTaskArchivingStatus AS QualityTaskArchivingStatus,
  _QualityTaskTP.QltyTaskFllwUpActionSts AS QltyTaskFllwUpActionSts,
  _QualityTaskTP.CreatedByUser AS CreatedByUser,
  _QualityTaskTP.CreationDate AS CreationDate,
  _QualityTaskTP.CreationTime AS CreationTime,
  _QualityTaskTP.ChangedDateTime AS ChangedDateTime,
  _QualityTaskTP.LastChangeDate AS LastChangeDate,
  _QualityTaskTP.LastChangeTime AS LastChangeTime,
  _QualityTaskTP.LastChangedByUser AS LastChangedByUser,
  QltyTaskTimeBasedEffort,
  QltyTaskTimeBasedEffortUoM
FROM I_QualityTaskTP AS _QualityTaskTP
;

Learn More