SAP table CGPL_PROJECT (Project Planning: Attribute Table for Project Headers)
SAP table CGPL_PROJECT has 2 primary key fields being CLIENT,GUID.
| Field |
Description |
Data Type |
Length |
Decimals |
Checktable |
Data Element |
|
| CLIENT |
Client |
CLNT |
3 |
0 |
*
|
MANDT
|
|
| GUID |
Project Planning: 16 Character GUID for Projects |
RAW |
16 |
0 |
|
CGPL_PROJECT_GUID
|
|
| EXTERNAL_ID |
Project Planning: External Identifier of an Element |
CHAR |
24 |
0 |
|
CGPL_EXTID
|
|
| PROJECT_GUID |
Project Planning: 16 Character GUID for Projects |
RAW |
16 |
0 |
|
CGPL_PROJECT_GUID
|
|
| OBJECT_TYPE |
Object Type in Project Planning |
CHAR |
3 |
0 |
|
CGPL_OBJECT_TYPE
|
|
| PRIORITY |
Priority |
NUMC |
3 |
0 |
CGPL_PRIO
|
CGPL_PRIORITY
|
|
| ACTUALSTART |
Actual Start Date |
DEC |
15 |
0 |
|
CGPL_ACTUALSTART
|
|
| ACTUALFINISH |
Actual Finish Date |
DEC |
15 |
0 |
|
CGPL_ACTUALFINISH
|
|
| PLANSTART |
Planned start date |
DEC |
15 |
0 |
|
CGPL_PLANSTART
|
|
| PLANFINISH |
Planned Finish Date |
DEC |
15 |
0 |
|
CGPL_PLANFINISH
|
|
| COMPLETION |
Percentage of Completion |
NUMC |
3 |
0 |
|
CGPL_COMPLETION
|
|
| MILESTONE |
Milestone indicator |
CHAR |
1 |
0 |
|
CGPL_MILESTONE
|
|
| CONSTRAINT_TYPE |
Type of Scheduling Constraint |
CHAR |
1 |
0 |
|
CGPL_CONSTRAINT
|
| 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 |
DEC |
15 |
0 |
|
CGPL_CONSTRAINT_TIME
|
|
| CREATED_BY |
Name of Person Who Created Object |
CHAR |
12 |
0 |
|
CGPL_CREATED_BY
|
|
| CREATED_ON |
Date When the Object Was Created |
DATS |
8 |
0 |
|
CGPL_CREATED_ON
|
|
| CREATED_IN_BW |
Transfer Object to BW |
CHAR |
1 |
0 |
|
CGPL_CREATED_BW
|
|
| CHANGED_BY |
Name of Person Who Changed Object |
CHAR |
12 |
0 |
|
CGPL_CHANGED_BY
|
|
| CHANGED_ON |
Date on which object was last changed |
DATS |
8 |
0 |
|
CGPL_CHANGED_ON
|
|
| UPDATED_IN_BW |
Current Object in BW |
CHAR |
1 |
0 |
|
CGPL_UPDATED_BW
|
|
| BWIDENTIFIER |
Project Planning - BW Identification |
NUMC |
8 |
0 |
|
CGPL_BWIDENTIFIER
|
|
| PLANGROUP |
Planning Profile Group |
CHAR |
4 |
0 |
|
CGPL_SEM_PLGRP
|
|
| LATEST_START |
Latest start |
DEC |
15 |
0 |
|
CGPL_LATEST_START
|
|
| LATEST_FINISH |
Latest finish date |
DEC |
15 |
0 |
|
CGPL_LATEST_FINISH
|
|
| TOTAL_FLOAT |
Total Float |
DEC |
8 |
2 |
|
CGPL_TOTAL_FLOAT
|
|
| DURATION |
Duration of Execution |
DEC |
8 |
2 |
|
CGPL_DURATION
|
|
| DURATION_UNIT |
Time Unit for Execution Duration |
UNIT |
3 |
0 |
*
|
CGPL_DURATION_UNIT
|
|
| CALENDAR_ID |
Factory Calendar |
CHAR |
2 |
0 |
*
|
WFCID
|
|
| CONSTR_TYPE_FIN |
Type of Scheduling Constraint |
CHAR |
1 |
0 |
|
CGPL_CONSTRAINT
|
| 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 |
DEC |
15 |
0 |
|
CGPL_CONSTRAINT_TIME
|
|
| APPLICATION |
Application in Project Planning |
CHAR |
3 |
0 |
*
|
CGPL_APPLICATION_TYPE
|
|
| FORECAST_START |
Forecast Start |
DEC |
15 |
0 |
|
CGPL_FORECAST_START
|
|
| FORECAST_FINISH |
Forecast Finish |
DEC |
15 |
0 |
|
CGPL_FORECAST_FINISH
|
|
CGPL_PROJECT foreign key relationships
| Table |
Field |
Check Table |
|
Check Field |
| 0 CGPL_PROJECT |
PRIORITY |
CGPL_PRIO |
Project Planning - Priorities |
PRIORITY |