ATOV_CMN_REQUESTS_CLIENT

DDL: ATOV_CMN_REQUESTS_CLIENT SQL: ATOVC_REQ_CLIENT Type: view

CMN Requests with Client and Target

ATOV_CMN_REQUESTS_CLIENT is a CDS View that provides data about "CMN Requests with Client and Target" in SAP S/4HANA. It reads from 3 data sources (e070c, e070, ato_cmn_requests) and exposes 4 fields with key field request.

Data Sources (3)

SourceAliasJoin Type
e070c clientinfo left_outer
e070 e070 inner
ato_cmn_requests requests from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATOVC_REQ_CLIENT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label CMN Requests with Client and Target view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY request ato_cmn_requests request Request/Task
changed_at ato_cmn_requests changed_at Timestamp
tarsystem e070 tarsystem Transport Target
trstatus e070 trstatus Status

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 ATOV_CMN_REQUESTS_CLIENT.
-- 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: ATOVC_REQ_CLIENT

CREATE VIEW ATOV_CMN_REQUESTS_CLIENT AS
SELECT
  requests.request AS request,
  requests.changed_at AS changed_at,
  e070.tarsystem AS tarsystem,
  e070.trstatus AS trstatus
FROM ato_cmn_requests AS requests
INNER JOIN e070 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN e070c AS clientinfo ON /* join condition not captured in parsed metadata */
;