1. Home
  2. Resources
  3. SAP Tables
  4. CGPL_TASK - Project Planning: Attribute Table for Activities

SAP Table CGPL_TASK

Project Planning: Attribute Table for Activities

CGPL_TASK (Project Planning: Attribute Table for Activities) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CGPL_TASK to other SAP tables.

Source: CGPL_TASK (Project Planning: Attribute Table for Activities)

CGPL_TASK table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT CLNT 3 0
GUID Project Planning: 16 Character GUID for Tasks CGPL_TASK_GUID RAW 16 0
EXTERNAL_ID Project Planning: External Indentifier of an Element CGPL_EXTID CHAR 24 0
PROJECT_GUID Project Planning: 16 Character GUID for Projects CGPL_PROJECT_GUID CGPL_PROJECT RAW 16 0
OBJECT_TYPE Object Type in Project Planning CGPL_OBJECT_TYPE CHAR 3 0
PRIORITY Priority CGPL_PRIORITY CGPL_PRIO NUMC 3 0
ACTUALSTART Actual Start Date CGPL_ACTUALSTART DEC 15 0
ACTUALFINISH Actual Finish Date CGPL_ACTUALFINISH DEC 15 0
PLANSTART Planned start date CGPL_PLANSTART DEC 15 0
PLANFINISH Planned Finish Date CGPL_PLANFINISH DEC 15 0
COMPLETION Percentage of Completion CGPL_COMPLETION NUMC 3 0
000 0 - 100
MILESTONE Milestone indicator CGPL_MILESTONE CHAR 1 0
CONSTRAINT_TYPE Type of Scheduling Constraint CGPL_CONSTRAINT CHAR 1 0
0 Earliest possible
1 Latest possible
2 Must start on
3 Must finish on
4 Start no earlier than
5 Start no later than
6 Finish no earlier than
7 Finish no later than
CONSTRAINT_TIME Constraint Date CGPL_CONSTRAINT_TIME DEC 15 0
CREATED_BY Name of Person Who Created Object CGPL_CREATED_BY CHAR 12 0
CREATED_ON Date When the Object Was Created CGPL_CREATED_ON DATS 8 0
CREATED_IN_BW Transfer Object to BW CGPL_CREATED_BW CHAR 1 0
CHANGED_BY Name of Person Who Changed Object CGPL_CHANGED_BY CHAR 12 0
CHANGED_ON Date on which object was last changed CGPL_CHANGED_ON DATS 8 0
UPDATED_IN_BW Current Object in BW CGPL_UPDATED_BW CHAR 1 0
BWIDENTIFIER Project Planning - BW Identification CGPL_BWIDENTIFIER NUMC 8 0
PLANGROUP Planning Profile Group CGPL_SEM_PLGRP CHAR 4 0
LATEST_START Latest start CGPL_LATEST_START DEC 15 0
LATEST_FINISH Latest finish date CGPL_LATEST_FINISH DEC 15 0
TOTAL_FLOAT Total Float CGPL_TOTAL_FLOAT DEC 8 2
DURATION Duration of Execution CGPL_DURATION DEC 8 2
DURATION_UNIT Time Unit for Execution Duration CGPL_DURATION_UNIT UNIT 3 0
CALENDAR_ID Factory Calendar WFCID CHAR 2 0
CONSTR_TYPE_FIN Type of Scheduling Constraint CGPL_CONSTRAINT CHAR 1 0
0 Earliest possible
1 Latest possible
2 Must start on
3 Must finish on
4 Start no earlier than
5 Start no later than
6 Finish no earlier than
7 Finish no later than
CONSTR_TIME_FIN Constraint Date CGPL_CONSTRAINT_TIME DEC 15 0
APPLICATION Application in Project Planning CGPL_APPLICATION_TYPE CHAR 3 0
FORECAST_START Forecast Start CGPL_FORECAST_START DEC 15 0
FORECAST_FINISH Forecast Finish CGPL_FORECAST_FINISH DEC 15 0

CGPL_TASK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CGPL_TASK PRIORITY SYST MANDT CGPL_PRIO Project Planning - Priorities CLIENT
CGPL_TASK PRIORITY CGPL_TASK PRIORITY CGPL_PRIO Project Planning - Priorities PRIORITY
CGPL_TASK PROJECT_GUID CGPL_TASK CLIENT CGPL_PROJECT Project Planning: Attribute Table for Project Headers CLIENT
CGPL_TASK PROJECT_GUID CGPL_TASK PROJECT_GUID CGPL_PROJECT Project Planning: Attribute Table for Project Headers GUID