C_QualityTaskProcessCalc

DDL: C_QUALITYTASKPROCESSCALC SQL: CQLTYTSKPROCCALC Type: view CONSUMPTION
9 Fields 1 Data Sources 1 Associations

Qlty. Task Process Calculated Attributes

C_QualityTaskProcessCalc is a Consumption CDS View that provides data about "Qlty. Task Process Calculated Attributes" in SAP S/4HANA. It reads from 1 data source (I_QualityTaskTP) and exposes 9 fields with key field QualityTaskInternalId. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_QualityTaskTP I_QualityTaskTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_QltyTaskOrigin _QualityTaskOrigin $projection.QualityTaskOrigin = _QualityTaskOrigin.QualityTaskOrigin

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CQLTYTSKPROCCALC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
EndUserText.label Qlty. Task Process Calculated Attributes view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey QualityTaskInternalId view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
Consumption.semanticObject QualityTask view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY QualityTaskInternalId QualityTaskInternalId
QualityTask QualityTask
QualityTaskOrigin QualityTaskOrigin
QltyTaskFllwUpActionSts QltyTaskFllwUpActionSts
QualityTaskOriginText
DefectInternalID DefectInternalID Internal Defect ID
ProbSolvingProc ProbSolvingProc
FllwUpActionLatestLogNumber
_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_QualityTaskProcessCalc.
-- 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: CQLTYTSKPROCCALC

CREATE VIEW C_QualityTaskProcessCalc AS
SELECT
  QualityTaskInternalId,
  QualityTask,
  QualityTaskOrigin,
  QltyTaskFllwUpActionSts,
  cast(_QualityTaskOrigin._Text[1:Language = $session.system_language].QualityTaskOriginText as vdm_qtaskoriginextdtext preserving type) AS QualityTaskOriginText,
  DefectInternalID,
  ProbSolvingProc,
  cast( '' as balognr ) AS FllwUpActionLatestLogNumber
FROM I_QualityTaskTP
LEFT OUTER JOIN I_QltyTaskOrigin AS _QualityTaskOrigin ON QualityTaskOrigin = _QualityTaskOrigin.QualityTaskOrigin  -- association [1..1]
;

Learn More