CTSPROJECT

Transparent Table System Table (transport)
6 Fields 2 CDS Views

Assignment of a CTS Project to an External Project

CTSPROJECT is an SAP database table in S/4HANA. Assignment of a CTS Project to an External Project. It contains 6 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
CTSProjects view from CTS Projects
I_RequestsProject view inner Request Project Details

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY externalps TR_EXTPS Project System
KEY externalid TR_EXTPID Project ID
KEY srcsystem FROMSYSTEM Source system
KEY srcclient TRCLIENT Source client
trkorr TRKORR_P Project
descriptn AS4TEXT Short Description

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Assignment of a CTS Project to an External Project
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CTSPROJECT (
    EXTERNALPS,  -- Project System [TR_EXTPS]
    EXTERNALID,  -- Project ID [TR_EXTPID]
    SRCSYSTEM,   -- Source system [FROMSYSTEM]
    SRCCLIENT,   -- Source client [TRCLIENT]
    TRKORR,      -- Project [TRKORR_P]
    DESCRIPTN,   -- Short Description [AS4TEXT]
    PRIMARY KEY (EXTERNALPS, EXTERNALID, SRCSYSTEM, SRCCLIENT)
);

Learn More