C_QltyTskDefectMng

DDL: C_QLTYTSKDEFECTMNG SQL: CQLTYTSKDEFSMNG Type: view CONSUMPTION Package: ODATA_QM_TASK
16 Fields 2 Data Sources

Quality Task Defect Fields View

C_QltyTskDefectMng is a Consumption CDS View that provides data about "Quality Task Defect Fields View" in SAP S/4HANA. It reads from 2 data sources (I_Defect_TP, I_QualityTaskTP) and exposes 16 fields with key fields DefectInternalID, QualityTaskInternalId. Part of development package ODATA_QM_TASK.

Data Sources (2)

SourceAliasJoin Type
I_Defect_TP I_Defect_TP inner
I_QualityTaskTP I_QualityTaskTP from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CQLTYTSKDEFSMNG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Quality Task Defect Fields View view
ObjectModel.representativeKey DefectInternalID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY DefectInternalID I_Defect_TP DefectInternalID Internal Defect ID
KEY QualityTaskInternalId QualityTaskInternalId
Defect Defect
DefectText DefectText
DefectCategory DefectCategory
DefectCategoryText
Plant I_Defect_TP Plant Valuation Area
WorkCenterTypeCode I_Defect_TP WorkCenterTypeCode Object Type
MainWorkCenterInternalID I_Defect_TP MainWorkCenterInternalID Work Center
MainWorkCenter I_Defect_TP MainWorkCenter Work Center
MainWorkCenterPlant I_Defect_TP MainWorkCenterPlant Plnt WorkCenter
QualityTaskOrigin QualityTaskOrigin
_DefectCategory _DefectCategory
_QualityTaskLongTextTP _QualityTaskLongTextTP
_Plant I_Defect_TP _Plant
_QualityTaskOrigin _QualityTaskOrigin

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_QltyTskDefectMng.
-- 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: CQLTYTSKDEFSMNG

CREATE VIEW C_QltyTskDefectMng AS
SELECT
  I_Defect_TP.DefectInternalID AS DefectInternalID,
  QualityTaskInternalId,
  Defect,
  DefectText,
  DefectCategory,
  _DefectCategory._Text[1:Language=$session.system_language].DefectCategoryText AS DefectCategoryText,
  I_Defect_TP.Plant AS Plant,
  I_Defect_TP.WorkCenterTypeCode AS WorkCenterTypeCode,
  I_Defect_TP.MainWorkCenterInternalID AS MainWorkCenterInternalID,
  I_Defect_TP.MainWorkCenter AS MainWorkCenter,
  I_Defect_TP.MainWorkCenterPlant AS MainWorkCenterPlant,
  QualityTaskOrigin,
  I_Defect_TP._Plant AS _Plant
FROM I_QualityTaskTP
INNER JOIN I_Defect_TP ON /* join condition not captured in parsed metadata */
;

Learn More