CLMS_V_TM_VTR_HISTORY

DDL: CLMS_V_TM_VTR_HISTORY SQL: CLMSV_TMVTRHIST Type: view

Virtual transport request history

CLMS_V_TM_VTR_HISTORY is a CDS View that provides data about "Virtual transport request history" in SAP S/4HANA. It reads from 2 data sources (clms_tm_vtr_hist, clms_tm_vtr) and exposes 26 fields with key fields trkorr, changed_at, changed_at.

Data Sources (2)

SourceAliasJoin Type
clms_tm_vtr_hist History union_all
clms_tm_vtr Request from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CLMSV_TMVTRHIST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientDependent false view
EndUserText.label Virtual transport request history view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY trkorr clms_tm_vtr trkorr Virtual Transport
KEY changed_at
changed_by clms_tm_vtr changed_by User Name
description clms_tm_vtr description Well Code Des.
status clms_tm_vtr status Workflow Status
symptom clms_tm_vtr symptom Symptom
created_by clms_tm_vtr created_by Version Created By
created_at
run_id clms_tm_vtr run_id UUID
job_name clms_tm_vtr job_name Job No.
job_count clms_tm_vtr job_count Job No.
src_client clms_tm_vtr src_client Source client
src_trkorr clms_tm_vtr src_trkorr Source Request
trkorr Virtual Transport
KEY changed_at
changed_by clms_tm_vtr_hist changed_by User Name
description clms_tm_vtr_hist description Well Code Des.
status clms_tm_vtr_hist status Workflow Status
symptom clms_tm_vtr_hist symptom Symptom
created_by clms_tm_vtr_hist created_by Version Created By
created_at
run_id clms_tm_vtr_hist run_id UUID
job_name clms_tm_vtr_hist job_name Job No.
job_count clms_tm_vtr_hist job_count Job No.
src_client clms_tm_vtr_hist src_client Source client
src_trkorr clms_tm_vtr_hist src_trkorr Source Request

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_HISTORY.
-- 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_TMVTRHIST

CREATE VIEW CLMS_V_TM_VTR_HISTORY AS
SELECT
  Request.trkorr AS trkorr,
  cast ( Request.changed_at as clms_tm_changed_at preserving type ) AS changed_at,
  Request.changed_by AS changed_by,
  Request.description AS description,
  Request.status AS status,
  Request.symptom AS symptom,
  Request.created_by AS created_by,
  cast ( Request.created_at as clms_tm_created_at preserving type ) AS created_at,
  Request.run_id AS run_id,
  Request.job_name AS job_name,
  Request.job_count AS job_count,
  Request.src_client AS src_client,
  Request.src_trkorr AS src_trkorr
FROM clms_tm_vtr AS Request
-- UNION ALL with additional select branch(es): clms_tm_vtr_hist
;