CTE_CDS_FIN_LATEST_COM_LOG_QM

DDL: CTE_CDS_FIN_LATEST_COM_LOG_QM SQL: CTE_COM_LOG_QM Type: view
2 Fields 1 Data Sources

Latest Communication Log Entry for QM

CTE_CDS_FIN_LATEST_COM_LOG_QM is a CDS View that provides data about "Latest Communication Log Entry for QM" in SAP S/4HANA. It reads from 1 data source (cte_d_com_log_qm) and exposes 2 fields with key field objid.

Data Sources (1)

SourceAliasJoin Type
cte_d_com_log_qm cte_d_com_log_qm from

Parameters (3)

NameTypeDefault
p_system_key cte_system_key_number
p_start_timestmp timestampl
p_end_timestmp timestampl

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CTE_COM_LOG_QM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Latest Communication Log Entry for QM view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY objid objid Work Center
timestamp

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 CTE_CDS_FIN_LATEST_COM_LOG_QM.
-- 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: CTE_COM_LOG_QM
-- Parameters: p_system_key : cte_system_key_number, p_start_timestmp : timestampl, p_end_timestmp : timestampl

CREATE VIEW CTE_CDS_FIN_LATEST_COM_LOG_QM AS
SELECT
  objid,
  max(timestamp) AS timestamp
FROM cte_d_com_log_qm
;

Learn More