I_TMO_RE_MAIN_R

DDL: I_TMO_RE_MAIN_R Type: view_entity

TMO-RE: Main CDS Interface View

I_TMO_RE_MAIN_R is a CDS View that provides data about "TMO-RE: Main CDS Interface View" in SAP S/4HANA. It has 1 association to related views.

Associations (1)

CardinalityTargetAliasCondition
[0..1] CE_TMO_RE_STREAM_R _Stream $projection.Datum = _Stream.Datum and $projection.Uzeit = _Stream.Uzeit and $projection.Ahost = _Stream.Ahost and $projection.Uname = _Stream.Uname and $projection.Mandt = _Stream.Mandt and $projection.Modno = _Stream.Modno

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label TMO-RE: Main CDS Interface View view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY Datum datum Valid to
KEY Uzeit uzeit Time
KEY Ahost ahost App. Server
KEY Uname uname User Name
KEY Mandt mandt Editing Client
KEY Modno modno Work Process Index
Timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Devclass devclass Package (Obsolete)
ObjectResponsible object_responsible User Name
PackageResponsible package_responsible User Name
PackagePath package_path
RuntimeError runtime_error
Mainprog mainprog Program Name
Version version XML Vers.
ObjectName object_name Technical Name
Exc exc
Component component Softw. Comp.
Responsible responsible User Name
UserAttrDevsupport user_attr_devsupport User Category
AppInfo
_Content _Content
_Stream _Stream

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 I_TMO_RE_MAIN_R.
-- 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.

CREATE VIEW I_TMO_RE_MAIN_R AS
SELECT
  Datum,
  Uzeit,
  Ahost,
  Uname,
  Mandt,
  Modno,
  Timestamp,
  Devclass,
  object_responsible AS ObjectResponsible,
  package_responsible AS PackageResponsible,
  package_path AS PackagePath,
  runtime_error AS RuntimeError,
  Mainprog,
  Version,
  object_name AS ObjectName,
  Exc,
  Component,
  Responsible,
  user_attr_devsupport AS UserAttrDevsupport,
  cast ( '' as abap.char(255) ) AS AppInfo
LEFT OUTER JOIN CE_TMO_RE_STREAM_R AS _Stream ON Datum = _Stream.Datum AND Uzeit = _Stream.Uzeit AND Ahost = _Stream.Ahost AND Uname = _Stream.Uname AND Mandt = _Stream.Mandt AND Modno = _Stream.Modno  -- association [0..1]
;