CLMS_V_TM_VTR_OBJ_STATUS

DDL: CLMS_V_TM_VTR_OBJ_STATUS SQL: CLMSV_TMVTROBJST Type: view
9 Fields 3 Data Sources

Multiplex status of objects of virtual transport

CLMS_V_TM_VTR_OBJ_STATUS is a CDS View that provides data about "Multiplex status of objects of virtual transport" in SAP S/4HANA. It reads from 3 data sources (CLMS_V_TM_OBJ_LIST, clms_tm_vtr_obj, clms_tenant) and exposes 9 fields with key fields trkorr, pgmid, object, obj_name, client.

Data Sources (3)

SourceAliasJoin Type
CLMS_V_TM_OBJ_LIST MultiplexStatus left_outer
clms_tm_vtr_obj Object from
clms_tenant Tenant inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CLMSV_TMVTROBJST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientDependent false view
EndUserText.label Multiplex status of objects of virtual transport view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY trkorr clms_tm_vtr_obj trkorr Virtual Transport
KEY pgmid clms_tm_vtr_obj pgmid Program Name
KEY object clms_tm_vtr_obj object TRFM Object
KEY obj_name clms_tm_vtr_obj obj_name Object Name
KEY client clms_tenant client Workflow definition: Client
KEY run_id CLMS_V_TM_OBJ_LIST run_id UUID
status CLMS_V_TM_OBJ_LIST status Workflow Status
task_list_id CLMS_V_TM_OBJ_LIST task_list_id Task List Run
changed_at

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 CLMS_V_TM_VTR_OBJ_STATUS.
-- 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: CLMSV_TMVTROBJST

CREATE VIEW CLMS_V_TM_VTR_OBJ_STATUS AS
SELECT
  Object.trkorr AS trkorr,
  Object.pgmid AS pgmid,
  Object.object AS object,
  Object.obj_name AS obj_name,
  Tenant.client AS client,
  MultiplexStatus.run_id AS run_id,
  MultiplexStatus.status AS status,
  MultiplexStatus.task_list_id AS task_list_id,
  cast ( MultiplexStatus.crea_date_time as clms_tm_changed_at preserving type ) AS changed_at
FROM clms_tm_vtr_obj AS Object
INNER JOIN clms_tenant AS Tenant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CLMS_V_TM_OBJ_LIST AS MultiplexStatus ON /* join condition not captured in parsed metadata */
;

Learn More