uconrfcattr_v

DDL: UCONRFC_ATTR SQL: UCONRFC_ATTR Type: view
15 Fields 1 Data Sources 3 Associations

Caller Info about Incoming RFC calls to this ABAP system

uconrfcattr_v is a CDS View that provides data about "Caller Info about Incoming RFC calls to this ABAP system" in SAP S/4HANA. It reads from 1 data source (uconrfmcalleratt) and exposes 15 fields with key fields CalledRFM, called_sid, called_user, called_vh, ucon_phase. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
uconrfmcalleratt uconrfmcalleratt from

Parameters (1)

NameTypeDefault
lang abap.lang

Associations (3)

CardinalityTargetAliasCondition
[0..1] uconrfcrej_v rfcreject $projection.rejected_rfc_call = rfcreject.RFCreject
[0..1] uconrfcconn_v ext_connector $projection.external_connector = ext_connector.Extconnector
[0..1] uconrfcphase_v rfcphase $projection.ucon_phase = rfcphase.Phase

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName UCONRFC_ATTR view
EndUserText.label Caller Info about Incoming RFC calls to this ABAP system view
AccessControl.authorizationCheck #CHECK view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CalledRFM called_rfm Function name
KEY called_sid called_sid SAP System ID
KEY called_user called_user User Name
KEY called_vh called_vh Virt. Host Name
KEY ucon_phase ucon_phase
KEY caller_sid caller_sid SAP System ID
KEY caller_user caller_user Caller User Name
FirstCallD Date of First Call
FirstCallT Time of First Call
PrevCallD Date of Previous Call
PrevCallT Time of Previous Call
LastCallD Date of Last Call
LastCallT Time of Last Call
rfcreject rfcreject
rfcphase rfcphase

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 uconrfcattr_v.
-- 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: UCONRFC_ATTR
-- Parameters: lang : abap.lang

CREATE VIEW uconrfcattr_v AS
SELECT
  called_rfm AS CalledRFM,
  called_sid,
  called_user,
  called_vh,
  ucon_phase,
  caller_sid,
  caller_user,
  cast( substring( cast( firstcall_timestamp as abap.char(21) ), 1, 8 ) as abap.dats ) AS FirstCallD,
  cast( substring( cast( firstcall_timestamp as abap.char(21) ), 9, 6 ) as abap.tims ) AS FirstCallT,
  cast( substring( cast( previouscall_timestamp as abap.char(21) ), 1, 8 ) as abap.dats ) AS PrevCallD,
  cast( substring( cast( previouscall_timestamp as abap.char(21) ), 9, 6 ) as abap.tims ) AS PrevCallT,
  cast( substring( cast( lastcall_timestamp as abap.char(21) ), 1, 8 ) as abap.dats ) AS LastCallD,
  cast( substring( cast( lastcall_timestamp as abap.char(21) ), 9, 6 ) as abap.tims ) AS LastCallT,
  rfcreject,
  rfcphase
FROM uconrfmcalleratt
LEFT OUTER JOIN uconrfcrej_v AS rfcreject ON rejected_rfc_call = rfcreject.RFCreject  -- association [0..1]
LEFT OUTER JOIN uconrfcconn_v AS ext_connector ON external_connector = ext_connector.Extconnector  -- association [0..1]
LEFT OUTER JOIN uconrfcphase_v AS rfcphase ON ucon_phase = rfcphase.Phase  -- association [0..1]
;

Learn More