CTSProjects

DDL: CTSPROJECTS SQL: CTSPROJECTSV Type: view
8 Fields 3 Data Sources

CTS Projects

CTSProjects is a CDS View that provides data about "CTS Projects" in SAP S/4HANA. It reads from 3 data sources (ctsproject, e070, e070c) and exposes 8 fields with key fields ExternalProjectSystem, ExternalProjectID, SourceClient, SourceSystem.

Data Sources (3)

SourceAliasJoin Type
ctsproject project from
e070 request inner
e070c rqclient left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CTSPROJECTSV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label CTS Projects view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ExternalProjectSystem ctsproject externalps Project System
KEY ExternalProjectID ctsproject externalid SRM Reference
KEY SourceClient ctsproject srcclient Source client
KEY SourceSystem ctsproject srcsystem Source system
Description ctsproject descriptn Short Text
RequestNumber ctsproject trkorr Virtual Transport
RequestNumberSystemPrefix
TargetClient e070c tarclient Target Client

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 CTSProjects.
-- 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: CTSPROJECTSV

CREATE VIEW CTSProjects AS
SELECT
  project.externalps AS ExternalProjectSystem,
  project.externalid AS ExternalProjectID,
  project.srcclient AS SourceClient,
  project.srcsystem AS SourceSystem,
  project.descriptn AS Description,
  project.trkorr AS RequestNumber,
  Left( project.trkorr, 3 ) AS RequestNumberSystemPrefix,
  rqclient.tarclient AS TargetClient
FROM ctsproject AS project
INNER JOIN e070 AS request ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN e070c AS rqclient ON /* join condition not captured in parsed metadata */
;

Learn More