I_RequestsHeader

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 I_RequestsHeader.
-- 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 I_RequestsHeader AS
SELECT
  _RequestHeader.trkorr AS TransportRequestID,
  left(_RequestHeader.trkorr, 3) AS ABAPSourceSystem,
  _RequestsClient.client AS TransportRequestSourceClient,
  _RequestHeader.trfunction AS TransportRequestType,
  _RequestHeader.trstatus AS TransportRequestStatus,
  _RequestHeader.tarsystem AS TransportRequestTarget,
  _RequestHeader.korrdev AS TransportRequestCategory,
  _RequestHeader.as4user AS TransportRequestOwner,
  _RequestHeader.as4date AS TransportRequestChangedOn,
  _RequestHeader.as4time AS TransportRequestChangedAt,
  _Text.as4text AS TransportRequestDesc,
  case when _RequestsClient.repoid is null then _SoftwareComponentRepos.rid when _RequestsClient.repoid = '' then _SoftwareComponentRepos.rid else _RequestsClient.repoid end as RepositoryId AS repoidendasRepositoryId
FROM e070 AS _RequestHeader
LEFT OUTER JOIN I_SoftwareComponentRepos AS _SoftwareComponentRepos ON _RequestHeader.tarsystem = _SoftwareComponentRepos.vsid  -- association [0..1]
LEFT OUTER JOIN e07t AS _Text ON TransportRequestID = _Text.trkorr AND _Text.as4text is not null  -- association [0..1]
LEFT OUTER JOIN e070c AS _RequestsClient ON TransportRequestID = _RequestsClient.trkorr  -- association [0..1]
;