SATC_API_RAW_NAV_BASE

DDL: SATC_API_RAW_NAV_BASE Type: view_entity
6 Fields 2 Data Sources

ATC: Item Navigation Data

SATC_API_RAW_NAV_BASE is a CDS View that provides data about "ATC: Item Navigation Data" in SAP S/4HANA. It reads from 2 data sources (satc_ac_resulth, satc_ac_raw) and exposes 6 fields with key fields ItemId, CheckRunIx, ResultId, InfoType.

Data Sources (2)

SourceAliasJoin Type
satc_ac_resulth h inner
satc_ac_raw raw from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label ATC: Item Navigation Data view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ItemId satc_ac_raw item_id Simulation Item ID
KEY CheckRunIx satc_ac_raw check_run_ix Check Run
KEY ResultId satc_ac_resulth display_id Display ID
KEY InfoType satc_ac_raw info_type Info Type
FindingURI
ParentURI

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_RAW_NAV_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_RAW_NAV_BASE AS
SELECT
  raw.item_id AS ItemId,
  raw.check_run_ix AS CheckRunIx,
  h.display_id AS ResultId,
  raw.info_type AS InfoType,
  abap.string'' AS FindingURI,
  abap.string'' AS ParentURI
FROM satc_ac_raw AS raw
INNER JOIN satc_ac_resulth AS h ON /* join condition not captured in parsed metadata */
;

Learn More