TPROJECT

Transparent Table Customizing Table
27 Fields 1 CDS Views

SPROJECT: Project Table

TPROJECT is an SAP database table in S/4HANA. SPROJECT: Project Table. It contains 27 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CUSTOMIZING_PROJECTS view from Customizing Projects list

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY project_id PROJECT_ID Project Name
class PROJ_CLASS Project Type
proj_lang SPRAS Language
responsibl PROJ_RESP Name
app_comp UFFCTR Component
ena_comp UFFCTR Component
ref_proj PROJECT_ID Project Name
begin_date STAT_FDATE Creation date
end_date STAT_FDATE Creation date
release PROJ_REL SAP Release
kenn1 PROJ_K1 Flag
cts_id CTS_ID CTS ID
proj_rel PROJ_REL SAP Release
doc_client DOC_CLIENT Office client
note_devc NOTE_DEVC Package
note_req NOTE_REQ Transport
kenn2 PROJ_K1 Flag
org_spr PROJ_K1 Flag
mod_spr PROJ_K1 Flag
dependent PROJ_K1 Flag
proj_stat STAT_STAT Status
fdate STAT_FDATE Creation date
fuser STAT_FUSER Created by
ldate STAT_LDATE Changed On
luser STAT_LUSER Changed by
ftime STAT_FTIME Time
ltime STAT_LTIME Time

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.

-- SPROJECT: Project Table
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TPROJECT (
    PROJECT_ID,  -- Project Name [PROJECT_ID]
    CLASS,       -- Project Type [PROJ_CLASS]
    PROJ_LANG,   -- Language [SPRAS]
    RESPONSIBL,  -- Name [PROJ_RESP]
    APP_COMP,    -- Component [UFFCTR]
    ENA_COMP,    -- Component [UFFCTR]
    REF_PROJ,    -- Project Name [PROJECT_ID]
    BEGIN_DATE,  -- Creation date [STAT_FDATE]
    END_DATE,    -- Creation date [STAT_FDATE]
    RELEASE,     -- SAP Release [PROJ_REL]
    KENN1,       -- Flag [PROJ_K1]
    CTS_ID,      -- CTS ID [CTS_ID]
    PROJ_REL,    -- SAP Release [PROJ_REL]
    DOC_CLIENT,  -- Office client [DOC_CLIENT]
    NOTE_DEVC,   -- Package [NOTE_DEVC]
    NOTE_REQ,    -- Transport [NOTE_REQ]
    KENN2,       -- Flag [PROJ_K1]
    ORG_SPR,     -- Flag [PROJ_K1]
    MOD_SPR,     -- Flag [PROJ_K1]
    DEPENDENT,   -- Flag [PROJ_K1]
    PROJ_STAT,   -- Status [STAT_STAT]
    FDATE,       -- Creation date [STAT_FDATE]
    FUSER,       -- Created by [STAT_FUSER]
    LDATE,       -- Changed On [STAT_LDATE]
    LUSER,       -- Changed by [STAT_LUSER]
    FTIME,       -- Time [STAT_FTIME]
    LTIME,       -- Time [STAT_LTIME]
    PRIMARY KEY (PROJECT_ID)
);

Learn More