SATC_API_FINDINGS

DDL: SATC_API_FINDINGS Type: view_entity
40 Fields 1 Data Sources

ATC: Findings

SATC_API_FINDINGS is a CDS View that provides data about "ATC: Findings" in SAP S/4HANA. It reads from 1 data source (SATC_API_FINDINGS_BASE) and exposes 40 fields with key fields ResultId, ItemId, CheckRunIndex.

Data Sources (1)

SourceAliasJoin Type
SATC_API_FINDINGS_BASE ATCFindings from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label ATC: Findings view
Metadata.allowExtensions false view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY ResultId ResultId Display ID
KEY ItemId ItemId Russia Statutory Reporting Report Land Tax, Run Item ID
KEY CheckRunIndex CheckRunIndex Check Run
CreatedOnItem CreatedOnItem Variant created on
Status Workflow Status
ChangedOn ChangedOn Time Stamp
module_id module_id Module Key
CheckVariant CheckVariant Check Variant
ObjectName ObjectName Object name
ObjectType ObjectType Type
PackageName PackageName Package Name
ContactPerson ContactPerson Contact Person Key
ObjectProvider ObjectProvider Obj Provider
ApplicationComponent ApplicationComponent Appl. Component
DLVRelease DLVRelease SAP Release
DLVUnit DLVUnit Softw. Comp.
TransportLayer TransportLayer Transport Layer
Responsible Responsible User Name
MessageTitle MessageTitle View Title
QualityStandard QualityStandard Q. standard
ChecksumVersion ChecksumVersion INT1
Checksum Checksum Identity
ExemptionKind Exemption kind
ExemptionValidity Validity
ExemptionApproval Approval
ExemptionKindItem Exemption kind
ExemptionValidityItem Validity
ExemptionApprovalItem Approval
ExemptionId ExemptionId Exemption ID
FindingLocation FindingLocation
HasQuickfixes Quickfix Exists
LastChangedBy LastChangedBy User Name
LastChangedOn LastChangedOn Time Stamp
Priority Workflow priority
CretatedOn CretatedOn Variant created on
Host Host Host rule
StatusNew Status
StatusOld Status
RemarkText RemarkText Status Description
RemarkLink RemarkLink URL

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_FINDINGS.
-- 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_FINDINGS AS
SELECT
  ResultId,
  ItemId,
  CheckRunIndex,
  CreatedOnItem,
  cast( Status as I_SATC_API_ITEM_STATE preserving type ) AS Status,
  ChangedOn,
  module_id,
  CheckVariant,
  ObjectName,
  ObjectType,
  PackageName,
  ContactPerson,
  ObjectProvider,
  ApplicationComponent,
  DLVRelease,
  DLVUnit,
  TransportLayer,
  Responsible,
  MessageTitle,
  QualityStandard,
  ChecksumVersion,
  Checksum,
  cast( ExemptionKind as I_SATC_API_EXEMPTION_KIND preserving type ) AS ExemptionKind,
  cast( ExemptionValidity as I_SATC_API_EXEMPTION_VAL preserving type ) AS ExemptionValidity,
  cast( ExemptionApproval as I_SATC_API_EXEMPTION_APPR preserving type ) AS ExemptionApproval,
  cast( ExemptionKindItem as I_SATC_API_EXEMPTION_KIND preserving type ) AS ExemptionKindItem,
  cast( ExemptionValidityItem as I_SATC_API_EXEMPTION_VAL preserving type ) AS ExemptionValidityItem,
  cast( ExemptionApprovalItem as I_SATC_API_EXEMPTION_APPR preserving type ) AS ExemptionApprovalItem,
  ExemptionId,
  FindingLocation,
  cast( HasQuickfixes as I_SATC_API_FNDQF preserving type ) AS HasQuickfixes,
  LastChangedBy,
  LastChangedOn,
  cast( Priority as I_SATC_API_PRIORITY preserving type ) AS Priority,
  CretatedOn,
  Host,
  cast( StatusNew as I_SATC_API_ITEM_STATE preserving type ) AS StatusNew,
  cast( StatusOld as I_SATC_API_ITEM_STATE preserving type ) AS StatusOld,
  RemarkText,
  RemarkLink
FROM SATC_API_FINDINGS_BASE AS ATCFindings
;

Learn More