APS_IAM_DPP_VTR

DDL: APS_IAM_DPP_VTR SQL: APS_IAM_DPP_VTRA Type: view
7 Fields 1 Data Sources

IAM: DPP Get VTR

APS_IAM_DPP_VTR is a CDS View that provides data about "IAM: DPP Get VTR" in SAP S/4HANA. It reads from 1 data source (clms_tm_vtr) and exposes 7 fields with key field trkorr.

Data Sources (1)

SourceAliasJoin Type
clms_tm_vtr vtr from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName APS_IAM_DPP_VTRA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label IAM: DPP Get VTR view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY trkorr trkorr Virtual Transport
created_at created_at Uploaded On
created_by created_by Version Created By
description description Well Code Des.
status status Workflow Status
symptom symptom Symptom
system_dateasdatsasDaysSinceCreation

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 APS_IAM_DPP_VTR.
-- 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: APS_IAM_DPP_VTRA

CREATE VIEW APS_IAM_DPP_VTR AS
SELECT
  trkorr,
  created_at,
  created_by,
  description,
  status,
  symptom,
  dats_days_between( tstmp_to_dats( created_at, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ), cast($session.system_date as dats) ) as DaysSinceCreation AS system_dateasdatsasDaysSinceCreation
FROM clms_tm_vtr AS vtr
;

Learn More