SATC_API_FINDINGS_C

DDL: SATC_API_FINDINGS_C Type: view_entity Package: SATC_CI_API
42 Fields 1 Data Sources 2 Associations 1 OData Services

ATC: Findings

SATC_API_FINDINGS_C 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 42 fields with key fields ResultId, ItemId, CheckRunIndex. It has 2 associations to related views. It is exposed through 1 OData service (SATC_API_RESULT_R). Part of development package SATC_CI_API.

Data Sources (1)

SourceAliasJoin Type
SATC_API_FINDINGS_BASE ATCFindings from

Associations (2)

CardinalityTargetAliasCondition
[0..*] SATC_API_RAW_NAV_C _toNavigationData $projection.ResultId = _toNavigationData.ResultId and $projection.ItemId = _toNavigationData.ItemId and $projection.CheckRunIndex = _toNavigationData.CheckRunIx
[0..*] SATC_API_RAW_DESCR_C _toDescriptionData $projection.ResultId = _toDescriptionData.ResultId and $projection.ItemId = _toDescriptionData.ItemId and $projection.CheckRunIndex = _toDescriptionData.CheckRunIx

Annotations (3)

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

OData Services (1)

ServiceBindingVersionContractRelease
SATC_API_RESULT_R C_SATC_API_RESULT_R_WAPI_V4 V4 C2 C1

Fields (42)

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 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 ExemptionKind Exemption kind
ExemptionValidity ExemptionValidity Validity
ExemptionApproval ExemptionApproval Approval
ExemptionKindItem ExemptionKindItem Exemption kind
ExemptionValidityItem ExemptionValidityItem Validity
ExemptionApprovalItem ExemptionApprovalItem Approval
ExemptionId ExemptionId Exemption ID
FindingLocation FindingLocation
HasQuickfixes HasQuickfixes Quickfix Exists
LastChangedBy LastChangedBy User Name
LastChangedOn LastChangedOn Time Stamp
Priority Priority Workflow priority
CretatedOn CretatedOn Variant created on
Host Host Host rule
StatusNew StatusNew Status
StatusOld StatusOld Status
RemarkText RemarkText Status Description
RemarkLink RemarkLink URL
_toNavigationData _toNavigationData
_toDescriptionData _toDescriptionData

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_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_FINDINGS_C AS
SELECT
  ResultId,
  ItemId,
  CheckRunIndex,
  CreatedOnItem,
  Status,
  ChangedOn,
  module_id,
  CheckVariant,
  ObjectName,
  ObjectType,
  PackageName,
  ContactPerson,
  ObjectProvider,
  ApplicationComponent,
  DLVRelease,
  DLVUnit,
  TransportLayer,
  Responsible,
  MessageTitle,
  QualityStandard,
  ChecksumVersion,
  Checksum,
  ExemptionKind,
  ExemptionValidity,
  ExemptionApproval,
  ExemptionKindItem,
  ExemptionValidityItem,
  ExemptionApprovalItem,
  ExemptionId,
  FindingLocation,
  HasQuickfixes,
  LastChangedBy,
  LastChangedOn,
  Priority,
  CretatedOn,
  Host,
  StatusNew,
  StatusOld,
  RemarkText,
  RemarkLink
FROM SATC_API_FINDINGS_BASE AS ATCFindings
LEFT OUTER JOIN SATC_API_RAW_NAV_C AS _toNavigationData ON ResultId = _toNavigationData.ResultId AND ItemId = _toNavigationData.ItemId AND CheckRunIndex = _toNavigationData.CheckRunIx  -- association [0..*]
LEFT OUTER JOIN SATC_API_RAW_DESCR_C AS _toDescriptionData ON ResultId = _toDescriptionData.ResultId AND ItemId = _toDescriptionData.ItemId AND CheckRunIndex = _toDescriptionData.CheckRunIx  -- association [0..*]
;

Learn More