DMC_PRJCT

Transparent Table System Table (SAP only)
13 Fields 4 CDS Views

Project Management

DMC_PRJCT is an SAP database table in S/4HANA. Project Management. It contains 13 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
/LTB/I_MIG_PROJECT_LIST view inner I_MIG_PROJECT_LIST
I_DataMigrationCoreProject view_entity from BASIC Data Migration Project
I_DataMigrtnProject view from BASIC Data Migration Project
I_DataMigrtnProjObjSndrStruc view from BASIC Migration Object Sender Structure

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY guid DMC_PROJECT_GUID Project GUID
appl GUID_22 GUID 22
ident DMC_PIDENT Project
versio DMC_VERSIO Version Number
chnam SYUNAME User Name
changedate SYDATUM Current Date
author SYUNAME User Name
createdate SYDATUM Current Date
descr DMC_PDESCR Description
versio_act BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
projecttype DMC_PROJECTTYPE Project Type
uc_active BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
ref_client DMC_CLIENT Client

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.

-- Project Management
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DMC_PRJCT (
    GUID,         -- Project GUID [DMC_PROJECT_GUID]
    APPL,         -- GUID 22 [GUID_22]
    IDENT,        -- Project [DMC_PIDENT]
    VERSIO,       -- Version Number [DMC_VERSIO]
    CHNAM,        -- User Name [SYUNAME]
    CHANGEDATE,   -- Current Date [SYDATUM]
    AUTHOR,       -- User Name [SYUNAME]
    CREATEDATE,   -- Current Date [SYDATUM]
    DESCR,        -- Description [DMC_PDESCR]
    VERSIO_ACT,   -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    PROJECTTYPE,  -- Project Type [DMC_PROJECTTYPE]
    UC_ACTIVE,    -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    REF_CLIENT,   -- Client [DMC_CLIENT]
    PRIMARY KEY (GUID)
);

Learn More