V_UCONWSRFC_ALL_DD

DDL: V_UCONWSRFC_ALL_DD SQL: V_UCONWSRFCL_ALL Type: view

UCON WSRFC runtime view

V_UCONWSRFC_ALL_DD is a CDS View that provides data about "UCON WSRFC runtime view" in SAP S/4HANA. It reads from 38 data sources and exposes 58 fields with key fields client, host_name, port, rfcfuncname, version.

Data Sources (38)

SourceAliasJoin Type
ucon_ca_rfcfunc cafunc inner
ucon_ca_rfcfunc cafunc inner
ucon_ca_rfcfunc cafunc inner
ucon_ca_rfcfunc cafunc inner
ucon_ca_rfcfunc cafunc inner
ucon_ca_rfcfunc cafunc inner
ucon_ca_rfcfunc cafunc inner
uconservashead childca left_outer
uconservashead childca left_outer
uconservashead childca left_outer
uconservashead childca left_outer
uconservashead childchildca left_outer
uconrfcservcust cust from
uconrfcservcust cust union
uconrfcservcust cust union
uconrfcservcust cust union
uconrfcservcust cust union
uconrfcservcust cust union
uconrfcservcust cust union
uconservashead head left_outer
uconservashead head left_outer
uconservashead head left_outer
uconservashead head left_outer
uconservashead head left_outer
uconservashead head left_outer
uconservashead head left_outer
ucon_ca_ca parsubca left_outer
ucon_ca_ca subca left_outer
ucon_ca_ca subca left_outer
ucon_ca_ca subca left_outer
ucon_ca_ca subsubca left_outer
uconvhwsrfcnames vh left_outer
uconvhwsrfcnames vh left_outer
uconvhwsrfcnames vh left_outer
uconvhwsrfcnames vh left_outer
uconvhwsrfcnames vh left_outer
uconvhwsrfcnames vh left_outer
uconvhwsrfcnames vh left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName V_UCONWSRFCL_ALL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
EndUserText.label UCON WSRFC runtime view view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY client uconrfcservcust client Workflow definition: Client
KEY host_name uconvhwsrfcnames host_name IP Address
KEY port uconvhwsrfcnames port Port rule
KEY rfcfuncname ucon_ca_rfcfunc rfcfuncname Function Module
KEY version uconservashead version XML Vers.
KEY virthostid uconrfcservcust vhost Virt. Host Name
KEY caid uconrfcservcust service_assembly UCON Object ID
KEY cfgid uconrfcservcust id WorklistID
vhversion uconvhwsrfcnames version XML Vers.
KEY host_name uconvhwsrfcnames host_name IP Address
KEY port uconvhwsrfcnames port Port rule
KEY rfcfuncname ucon_ca_rfcfunc rfcfuncname Function Module
KEY version uconservashead version XML Vers.
KEY virthostid uconrfcservcust vhost Virt. Host Name
KEY caid uconrfcservcust service_assembly UCON Object ID
KEY cfgid uconrfcservcust id WorklistID
vhversion uconvhwsrfcnames version XML Vers.
KEY host_name uconvhwsrfcnames host_name IP Address
KEY port uconvhwsrfcnames port Port rule
KEY rfcfuncname ucon_ca_rfcfunc rfcfuncname Function Module
KEY version uconservashead version XML Vers.
KEY virthostid uconrfcservcust vhost Virt. Host Name
KEY caid uconrfcservcust service_assembly UCON Object ID
KEY cfgid uconrfcservcust id WorklistID
vhversion uconvhwsrfcnames version XML Vers.
KEY host_name uconvhwsrfcnames host_name IP Address
KEY port uconvhwsrfcnames port Port rule
KEY rfcfuncname ucon_ca_rfcfunc rfcfuncname Function Module
KEY version uconservashead version XML Vers.
KEY virthostid uconrfcservcust vhost Virt. Host Name
KEY caid uconrfcservcust service_assembly UCON Object ID
KEY cfgid uconrfcservcust id WorklistID
vhversion uconvhwsrfcnames version XML Vers.
KEY host_name uconvhwsrfcnames host_name IP Address
KEY port uconvhwsrfcnames port Port rule
KEY rfcfuncname ucon_ca_rfcfunc rfcfuncname Function Module
KEY version uconservashead version XML Vers.
KEY virthostid uconrfcservcust vhost Virt. Host Name
KEY caid uconrfcservcust service_assembly UCON Object ID
KEY cfgid uconrfcservcust id WorklistID
vhversion uconvhwsrfcnames version XML Vers.
KEY host_name uconvhwsrfcnames host_name IP Address
KEY port uconvhwsrfcnames port Port rule
KEY rfcfuncname ucon_ca_rfcfunc rfcfuncname Function Module
KEY version uconservashead version XML Vers.
KEY virthostid uconrfcservcust vhost Virt. Host Name
KEY caid uconrfcservcust service_assembly UCON Object ID
KEY cfgid uconrfcservcust id WorklistID
vhversion uconvhwsrfcnames version XML Vers.
KEY host_name uconvhwsrfcnames host_name IP Address
KEY port uconvhwsrfcnames port Port rule
KEY rfcfuncname ucon_ca_rfcfunc rfcfuncname Function Module
KEY version uconservashead version XML Vers.
KEY virthostid uconrfcservcust vhost Virt. Host Name
KEY caid uconrfcservcust service_assembly UCON Object ID
KEY cfgid uconrfcservcust id WorklistID
vhversion uconvhwsrfcnames version XML Vers.
wsrfc uconrfcservcust webrfc WebRFC

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_UCONWSRFC_ALL_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_UCONWSRFCL_ALL

CREATE VIEW V_UCONWSRFC_ALL_DD AS
SELECT
  cust.client AS client,
  vh.host_name AS host_name,
  vh.port AS port,
  cafunc.rfcfuncname AS rfcfuncname,
  head.version AS version,
  cust.vhost AS virthostid,
  cust.service_assembly AS caid,
  cust.id AS cfgid,
  vh.version AS vhversion,
  cust.webrfc AS wsrfc
FROM uconrfcservcust AS cust
LEFT OUTER JOIN uconvhwsrfcnames AS vh ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN uconservashead AS head ON /* join condition not captured in parsed metadata */
INNER JOIN ucon_ca_rfcfunc AS cafunc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ucon_ca_ca AS subca ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN uconservashead AS childca ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ucon_ca_ca AS subsubca ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ucon_ca_ca AS parsubca ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN uconservashead AS childchildca ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): uconrfcservcust
;