SATC_API_RESULT_HEADERS_C

DDL: SATC_API_RESULT_HEADERS_C Type: view_entity
34 Fields 1 Data Sources 2 Associations

ATC: Result Headers

SATC_API_RESULT_HEADERS_C is a CDS View that provides data about "ATC: Result Headers" in SAP S/4HANA. It reads from 1 data source (SATC_API_RESULT_HEADERS_BASE) and exposes 34 fields with key field ResultId. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
SATC_API_RESULT_HEADERS_BASE ATCResultHeaders from

Associations (2)

CardinalityTargetAliasCondition
[0..*] SATC_API_FINDINGS_C _toFindings $projection.ResultId = _toFindings.ResultId
[0..*] SATC_API_RUN_FAILURES_C _toRunFailures $projection.ResultId = _toRunFailures.ResultId

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label ATC: Result Headers view
Metadata.allowExtensions true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ResultId ResultId Display ID
IsActiveResult IsActiveResult
IsInBaseline IsInBaseline
IsCentralRun IsCentralRun Central
RunSeries RunSeries Run Series
Title Title View Title
CountPrio1 CountPrio1 Priority 1
CountPrio2 CountPrio2 Priority 2
CountPrio3 CountPrio3 Priority 3
CountCheckFailure CountCheckFailure Check Failures
ScheduledBy ScheduledBy Created By
ScheduledOnTimestamp ScheduledOnTimestamp Created On
SystemId SystemId System ID
ValidToTimestamp ValidToTimestamp Time Stamp
ObjectProvider ObjectProvider Obj Provider
ResultAnnotation ResultAnnotation DD: Key/Name for Annotation
AddedToBaselineBy AddedToBaselineBy
CheckVariant CheckVariant Check Variant
Configuration Configuration Text Analysis Method
PseudoCommentPragmaHandling PseudoCommentPragmaHandling PsComm/Pragmas
ChangedOnTimestamp ChangedOnTimestamp Changed On
UniqueSystemId UniqueSystemId Unique System Id
IsComplete IsComplete Usable
IsTransient IsTransient Transient
IsMassTest IsMassTest Mass Check
IsComposite IsComposite Composite
IsReworked IsReworked Reworked
IsImported IsImported Imported
ScheduledSystemId ScheduledSystemId SAP System ID
ProjectId ProjectId Project ID
ExecutionId ExecutionId Search Execution ID
ScheduledClient ScheduledClient Client
_toFindings _toFindings
_toRunFailures _toRunFailures

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 SATC_API_RESULT_HEADERS_C.
-- 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.

CREATE VIEW SATC_API_RESULT_HEADERS_C AS
SELECT
  ResultId,
  IsActiveResult,
  IsInBaseline,
  IsCentralRun,
  RunSeries,
  Title,
  CountPrio1,
  CountPrio2,
  CountPrio3,
  CountCheckFailure,
  ScheduledBy,
  ScheduledOnTimestamp,
  SystemId,
  ValidToTimestamp,
  ObjectProvider,
  ResultAnnotation,
  AddedToBaselineBy,
  CheckVariant,
  Configuration,
  PseudoCommentPragmaHandling,
  ChangedOnTimestamp,
  UniqueSystemId,
  IsComplete,
  IsTransient,
  IsMassTest,
  IsComposite,
  IsReworked,
  IsImported,
  ScheduledSystemId,
  ProjectId,
  ExecutionId,
  ScheduledClient
FROM SATC_API_RESULT_HEADERS_BASE AS ATCResultHeaders
LEFT OUTER JOIN SATC_API_FINDINGS_C AS _toFindings ON ResultId = _toFindings.ResultId  -- association [0..*]
LEFT OUTER JOIN SATC_API_RUN_FAILURES_C AS _toRunFailures ON ResultId = _toRunFailures.ResultId  -- association [0..*]
;

Learn More