V_UCONHTTPSQL_RT_DD

DDL: V_UCONHTTPSQL_RT_DD SQL: V_UCONHTTPSQL_RT Type: view Package: S_UNIFIED_CON_RUN_TIME
12 Fields 3 Data Sources

View for UCON HTTP Cloud SQL Runtime

V_UCONHTTPSQL_RT_DD is a CDS View that provides data about "View for UCON HTTP Cloud SQL Runtime" in SAP S/4HANA. It reads from 3 data sources (uconhttpcusthead, uconvhhttpnames, uconhttprturl) and exposes 12 fields with key fields client, vh_name, host_name, port, assigned_ca. Part of development package S_UNIFIED_CON_RUN_TIME.

Data Sources (3)

SourceAliasJoin Type
uconhttpcusthead cfg inner
uconvhhttpnames host inner
uconhttprturl url inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName V_UCONHTTPSQL_RT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label View for UCON HTTP Cloud SQL Runtime view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #SINGLE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY client main client Workflow definition: Client
KEY vh_name main vh_name Virt. Host Name
KEY host_name uconvhhttpnames host_name IP Address
KEY port uconvhhttpnames port Port rule
KEY assigned_ca main assigned_ca
KEY assigned_cfg main assigned_cfg
KEY service_name main service_name Service Name
KEY url_nr uconhttprturl url_nr INT4
KEY cfg_id uconhttpcusthead id WorklistID
aliaslogin uconhttpcusthead aliaslogin UCON: User Type ( Standard or Internetuser)
logon_cat uconhttpcusthead logon_cat Logon Category
url uconhttprturl url URLContract

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 V_UCONHTTPSQL_RT_DD.
-- 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: V_UCONHTTPSQL_RT

CREATE VIEW V_UCONHTTPSQL_RT_DD AS
SELECT
  main.client AS client,
  main.vh_name AS vh_name,
  host.host_name AS host_name,
  host.port AS port,
  main.assigned_ca AS assigned_ca,
  main.assigned_cfg AS assigned_cfg,
  main.service_name AS service_name,
  url.url_nr AS url_nr,
  cfg.id AS cfg_id,
  cfg.aliaslogin AS aliaslogin,
  cfg.logon_cat AS logon_cat,
  url.url AS url
INNER JOIN uconvhhttpnames AS host ON /* join condition not captured in parsed metadata */
INNER JOIN uconhttpcusthead AS cfg ON /* join condition not captured in parsed metadata */
INNER JOIN uconhttprturl AS url ON /* join condition not captured in parsed metadata */
;

Learn More