CGPL_TASK

Transparent Table Application Table
33 Fields 4 CDS Views

Project Planning: Attribute Table for Activities

CGPL_TASK is an SAP database table in S/4HANA. Project Planning: Attribute Table for Activities. It contains 33 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_DevelopmentProjectRole view inner BASIC PPM Project Role Details
I_FMEANodeAssignment view from BASIC FMEA Node root
I_PPM_ChecklistItem view inner BASIC Determines Checklist Items
V_DPR_CGPL_ATTR_VIEW view from Union of CGPL_TASK and CGPL_PROJECT

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY guid CGPL_TASK_GUID Project Planning: 16 Character GUID for Tasks
external_id CGPL_EXTID Number
project_guid CGPL_PROJECT_GUID Project Planning: 16 Character GUID for Projects
object_type CGPL_OBJECT_TYPE Object Type
priority CGPL_PRIORITY Priority
actualstart CGPL_ACTUALSTART Actual start
actualfinish CGPL_ACTUALFINISH Actual end
planstart CGPL_PLANSTART Planned Start
planfinish CGPL_PLANFINISH Planned Finish
completion CGPL_COMPLETION Percent Completion
milestone CGPL_MILESTONE Milestone
constraint_type CGPL_CONSTRAINT Restriction
constraint_time CGPL_CONSTRAINT_TIME Restriction
created_by CGPL_CREATED_BY Created by
created_on CGPL_CREATED_ON Created On
created_in_bw CGPL_CREATED_BW Created in BW
changed_by CGPL_CHANGED_BY Changed by
changed_on CGPL_CHANGED_ON Changed on
updated_in_bw CGPL_UPDATED_BW Current in BW
bwidentifier CGPL_BWIDENTIFIER BW Identification
plangroup CGPL_SEM_PLGRP Planning Profile Grp
latest_start CGPL_LATEST_START Latest Start
latest_finish CGPL_LATEST_FINISH Latest finish
total_float CGPL_TOTAL_FLOAT Total Float
duration CGPL_DURATION Duration
duration_unit CGPL_DURATION_UNIT Unit
calendar_id WFCID Factory Cal. ID
constr_type_fin CGPL_CONSTRAINT Restriction
constr_time_fin CGPL_CONSTRAINT_TIME Restriction
application CGPL_APPLICATION_TYPE Application
forecast_start CGPL_FORECAST_START Forecast Start
forecast_finish CGPL_FORECAST_FINISH Forecast Finish

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 Planning: Attribute Table for Activities
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CGPL_TASK (
    CLIENT,           -- Client [MANDT]
    GUID,             -- Project Planning: 16 Character GUID for Tasks [CGPL_TASK_GUID]
    EXTERNAL_ID,      -- Number [CGPL_EXTID]
    PROJECT_GUID,     -- Project Planning: 16 Character GUID for Projects [CGPL_PROJECT_GUID]
    OBJECT_TYPE,      -- Object Type [CGPL_OBJECT_TYPE]
    PRIORITY,         -- Priority [CGPL_PRIORITY]
    ACTUALSTART,      -- Actual start [CGPL_ACTUALSTART]
    ACTUALFINISH,     -- Actual end [CGPL_ACTUALFINISH]
    PLANSTART,        -- Planned Start [CGPL_PLANSTART]
    PLANFINISH,       -- Planned Finish [CGPL_PLANFINISH]
    COMPLETION,       -- Percent Completion [CGPL_COMPLETION]
    MILESTONE,        -- Milestone [CGPL_MILESTONE]
    CONSTRAINT_TYPE,  -- Restriction [CGPL_CONSTRAINT]
    CONSTRAINT_TIME,  -- Restriction [CGPL_CONSTRAINT_TIME]
    CREATED_BY,       -- Created by [CGPL_CREATED_BY]
    CREATED_ON,       -- Created On [CGPL_CREATED_ON]
    CREATED_IN_BW,    -- Created in BW [CGPL_CREATED_BW]
    CHANGED_BY,       -- Changed by [CGPL_CHANGED_BY]
    CHANGED_ON,       -- Changed on [CGPL_CHANGED_ON]
    UPDATED_IN_BW,    -- Current in BW [CGPL_UPDATED_BW]
    BWIDENTIFIER,     -- BW Identification [CGPL_BWIDENTIFIER]
    PLANGROUP,        -- Planning Profile Grp [CGPL_SEM_PLGRP]
    LATEST_START,     -- Latest Start [CGPL_LATEST_START]
    LATEST_FINISH,    -- Latest finish [CGPL_LATEST_FINISH]
    TOTAL_FLOAT,      -- Total Float [CGPL_TOTAL_FLOAT]
    DURATION,         -- Duration [CGPL_DURATION]
    DURATION_UNIT,    -- Unit [CGPL_DURATION_UNIT]
    CALENDAR_ID,      -- Factory Cal. ID [WFCID]
    CONSTR_TYPE_FIN,  -- Restriction [CGPL_CONSTRAINT]
    CONSTR_TIME_FIN,  -- Restriction [CGPL_CONSTRAINT_TIME]
    APPLICATION,      -- Application [CGPL_APPLICATION_TYPE]
    FORECAST_START,   -- Forecast Start [CGPL_FORECAST_START]
    FORECAST_FINISH,  -- Forecast Finish [CGPL_FORECAST_FINISH]
    PRIMARY KEY (CLIENT, GUID)
);

Learn More