/SSB/UNION_SAC_NAV_INTENTS

DDL: /SSB/UNION_SAC_NAV_INTENTS SQL: /SSB/_USACNAV Type: view
6 Fields 7 Data Sources

Union- SAP and Cust SAC navigation tabls

/SSB/UNION_SAC_NAV_INTENTS is a CDS View that provides data about "Union- SAP and Cust SAC navigation tabls" in SAP S/4HANA. It reads from 7 data sources and exposes 6 fields with key fields id, chip_id, chip_id, chip_id, chip_id.

Data Sources (7)

SourceAliasJoin Type
/SSB/BOC_NAV_INTENTS /SSB/BOC_NAV_INTENTS union_all
/ssb/sac_app_nav /ssb/sac_app_nav union_all
/ssb/sacda_navgn /ssb/sacda_navgn union_all
/ssb/sacnavgn_s /ssb/sacnavgn_s from
/SSB/SAPCLIENT SC inner
/SSB/SAPCLIENT SC inner
/SSB/SAPCLIENT SC inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName /SSB/_USACNAV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #P view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Union- SAP and Cust SAC navigation tabls view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY id id WorklistID
KEY chip_id chip_id Identifier
KEY chip_id chip_id Identifier
KEY chip_id chip_id Identifier
KEY chip_id chip_id Identifier
type

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 /SSB/UNION_SAC_NAV_INTENTS.
-- 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.
-- SQL view name: /SSB/_USACNAV

CREATE VIEW /SSB/UNION_SAC_NAV_INTENTS AS
SELECT
  id,
  chip_id,
  ' ' AS type
FROM /ssb/sacnavgn_s
INNER JOIN /SSB/SAPCLIENT AS SC ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): /ssb/sacda_navgn, /ssb/sac_app_nav, /SSB/BOC_NAV_INTENTS
;

Learn More