TMO_EXP_I_TG_CDQ_R

DDL: TMO_EXP_I_TG_CDQ_R Type: view_entity Package: S_TMO_EXP
10 Fields 1 Data Sources

Exporter Targets

TMO_EXP_I_TG_CDQ_R is a CDS View that provides data about "Exporter Targets" in SAP S/4HANA. It reads from 1 data source (tmo_exp_tg_cdq) and exposes 10 fields with key fields Target_Type, Target_Name, Provider_Name, Data_Timestamp, Data_Id. Part of development package S_TMO_EXP.

Data Sources (1)

SourceAliasJoin Type
tmo_exp_tg_cdq tg_cdq from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Exporter Targets view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Target_Type tmo_exp_tg_cdq target_type Target Type
KEY Target_Name tmo_exp_tg_cdq target_name
KEY Provider_Name tmo_exp_tg_cdq provider_name Provider Name
KEY Data_Timestamp tmo_exp_tg_cdq data_timestamp Time Stamp
KEY Data_Id tmo_exp_tg_cdq data_id Data ID
Data_Type tmo_exp_tg_cdq data_type Type
Request_Cdata tmo_exp_tg_cdq request_cdata
Request_Xdata tmo_exp_tg_cdq request_xdata
Retention_Timestamp tmo_exp_tg_cdq retention_timestamp Time Stamp
Owner_type tg_hdr Owner_Type Partner Type

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 TMO_EXP_I_TG_CDQ_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 TMO_EXP_I_TG_CDQ_R AS
SELECT
  tg_cdq.target_type AS Target_Type,
  tg_cdq.target_name AS Target_Name,
  tg_cdq.provider_name AS Provider_Name,
  tg_cdq.data_timestamp AS Data_Timestamp,
  tg_cdq.data_id AS Data_Id,
  tg_cdq.data_type AS Data_Type,
  tg_cdq.request_cdata AS Request_Cdata,
  tg_cdq.request_xdata AS Request_Xdata,
  tg_cdq.retention_timestamp AS Retention_Timestamp,
  tg_hdr.Owner_Type AS Owner_type
FROM tmo_exp_tg_cdq AS tg_cdq
;

Learn More