V_UCONWSRFC_ALL_DD
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)
| Source | Alias | Join 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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
;
Learn More
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA