/SSB/FETCH_SAC_CONNECTION

DDL: /SSB/FETCH_SAC_CONNECTION SQL: /SSB/SACCONNEC Type: view Package: /SSB/CORE
7 Fields 1 Data Sources

Fetch Sac connection

/SSB/FETCH_SAC_CONNECTION is a CDS View that provides data about "Fetch Sac connection" in SAP S/4HANA. It reads from 1 data source (sac_integ_c) and exposes 7 fields with key fields SacScenario, TenantAlias. Part of development package /SSB/CORE.

Data Sources (1)

SourceAliasJoin Type
sac_integ_c sac_integ_c from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName /SSB/SACCONNEC view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #A view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Fetch Sac connection view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.sizeCategory #M view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY SacScenario sac_integ_c sac_scenario Analytics Scenario
KEY TenantAlias sac_integ_c sac_tenant_alias Tenant Alias
TenantType sac_tenant_type Tenant Type
SupportIdp sac_support_idp Support IdP URL
UIDestination ui_dest UI Destination
ServerDestination srv_dest Server Destination
TenantAliasName _Text sac_tenant_desc

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/FETCH_SAC_CONNECTION.
-- 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/SACCONNEC

CREATE VIEW /SSB/FETCH_SAC_CONNECTION AS
SELECT
  sac_integ_c.sac_scenario AS SacScenario,
  sac_integ_c.sac_tenant_alias AS TenantAlias,
  sac_tenant_type AS TenantType,
  sac_support_idp AS SupportIdp,
  ui_dest AS UIDestination,
  srv_dest AS ServerDestination,
  _Text.sac_tenant_desc AS TenantAliasName
FROM sac_integ_c
;

Learn More