SATC_API_FINDINGS_BASE

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_BASE.
-- 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_BASE AS
SELECT
  fnd_v.item_id AS ItemId,
  h.display_id AS ResultId,
  fnd_v.check_run_ix AS CheckRunIndex,
  itm.created_on AS CreatedOnItem,
  itm.status AS Status,
  itm.updated_on AS ChangedOn,
  fnd.module_ix AS module_ix,
  chm.module_id AS module_id,
  chc.check_variant AS CheckVariant,
  fnd.object_ix AS object_ix,
  obj.obj_name AS ObjectName,
  obj.obj_type AS ObjectType,
  osy.package_name AS PackageName,
  osy.contact_person AS ContactPerson,
  osy.comp_short AS ApplicationComponent,
  osy.dlv_release AS DLVRelease,
  osy.dlv_unit AS DLVUnit,
  osy.tr_layer AS TransportLayer,
  h.data_source_id AS ObjectProvider,
  itm.processor AS Responsible,
  fnd.message_ix AS message_ix,
  msgt.title AS MessageTitle,
  cmm.quality_standard AS QualityStandard,
  fnd.checksum_version AS ChecksumVersion,
  fnd.checksum AS Checksum,
  fnd_v.exc_kind AS ExemptionKind,
  fnd_v.exc_validity AS ExemptionValidity,
  fnd_v.exc_approval AS ExemptionApproval,
  fnd.exc_kind AS ExemptionKindItem,
  fnd.exc_validity AS ExemptionValidityItem,
  fnd.exc_approval AS ExemptionApprovalItem,
  fnd.exemption_id AS ExemptionId,
  concat( fnd.location_path, fnd.location_fragment ) AS FindingLocation,
  fnd.has_quickfixes AS HasQuickfixes,
  fnd.has_ai_based_qf AS HasAiBasedQuickfixes,
  fnd_v.last_changed_by AS LastChangedBy,
  fnd_v.last_changed_on AS LastChangedOn,
  fnd_v.priority AS Priority,
  fnd_v.created_on AS CretatedOn,
  fnd_v.host AS Host,
  fnd_v.status_new AS StatusNew,
  fnd_v.status_old AS StatusOld,
  fnd_v.sub_index AS sub_index,
  cmt.remark AS RemarkText,
  cmt.link AS RemarkLink
FROM satc_ac_resulth AS h
INNER JOIN satc_ac_fnd_v AS fnd_v ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_itm AS itm ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_fnd AS fnd ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_obj AS obj ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_osy AS osy ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_chm AS chm ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_cmm AS cmm ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_chc AS chc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN satc_ac_fnd_cmt AS cmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN satc_ac_msgt AS msgt ON /* join condition not captured in parsed metadata */
;