| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | GUID | Project Planning: 16 Character GUID for Tasks | varbinary | 16 | 0 | RAW | | No | | CGPL_TASK_GUID | |
| 3 | EXTERNAL_ID | Project Planning: External Indentifier of an Element | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | CGPL_EXTID | Allow NULL? |
| 4 | PROJECT_GUID | Project Planning: 16 Character GUID for Projects | varbinary | 16 | 0 | RAW | | Yes | CGPL_PROJECT | CGPL_PROJECT_GUID | |
| 5 | OBJECT_TYPE | Object Type in Project Planning | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CGPL_OBJECT_TYPE | Allow NULL? |
| 6 | PRIORITY | Priority | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | CGPL_PRIO | CGPL_PRIORITY | Allow NULL? |
| 7 | ACTUALSTART | Actual Start Date | decimal | 15 | 0 | DEC | ((0)) | Yes | | CGPL_ACTUALSTART | |
| 8 | ACTUALFINISH | Actual Finish Date | decimal | 15 | 0 | DEC | ((0)) | Yes | | CGPL_ACTUALFINISH | |
| 9 | PLANSTART | Planned start date | decimal | 15 | 0 | DEC | ((0)) | Yes | | CGPL_PLANSTART | |
| 10 | PLANFINISH | Planned Finish Date | decimal | 15 | 0 | DEC | ((0)) | Yes | | CGPL_PLANFINISH | |
| 11 | COMPLETION | Percentage of Completion | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CGPL_COMPLETION | Allow NULL? |
| 12 | MILESTONE | Milestone indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CGPL_MILESTONE | Allow NULL? |
| 13 | CONSTRAINT_TYPE | Type of Scheduling Constraint | char | 1 | 0 | CHAR | (N' ') | Yes | | CGPL_CONSTRAINT | Allow NULL? |
| 14 | CONSTRAINT_TIME | Constraint Date | decimal | 15 | 0 | DEC | ((0)) | Yes | | CGPL_CONSTRAINT_TIME | |
| 15 | CREATED_BY | Name of Person Who Created Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CGPL_CREATED_BY | Allow NULL? |
| 16 | CREATED_ON | Date When the Object Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CGPL_CREATED_ON | Allow NULL? |
| 17 | CREATED_IN_BW | Transfer Object to BW | char | 1 | 0 | CHAR | (N' ') | Yes | | CGPL_CREATED_BW | Allow NULL? |
| 18 | CHANGED_BY | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CGPL_CHANGED_BY | Allow NULL? |
| 19 | CHANGED_ON | Date on which object was last changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CGPL_CHANGED_ON | Allow NULL? |
| 20 | UPDATED_IN_BW | Current Object in BW | char | 1 | 0 | CHAR | (N' ') | Yes | | CGPL_UPDATED_BW | Allow NULL? |
| 21 | BWIDENTIFIER | Project Planning - BW Identification | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | CGPL_BWIDENTIFIER | Allow NULL? |
| 22 | PLANGROUP | Planning Profile Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CGPL_SEM_PLGRP | Allow NULL? |
| 23 | LATEST_START | Latest start | decimal | 15 | 0 | DEC | ((0)) | Yes | | CGPL_LATEST_START | |
| 24 | LATEST_FINISH | Latest finish date | decimal | 15 | 0 | DEC | ((0)) | Yes | | CGPL_LATEST_FINISH | |
| 25 | TOTAL_FLOAT | Total Float | decimal | 8 | 2 | DEC | ((0)) | Yes | | CGPL_TOTAL_FLOAT | |
| 26 | DURATION | Duration of Execution | decimal | 8 | 2 | DEC | ((0)) | Yes | | CGPL_DURATION | |
| 27 | DURATION_UNIT | Time Unit for Execution Duration | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | CGPL_DURATION_UNIT | Allow NULL? |
| 28 | CALENDAR_ID | Factory Calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | WFCID | Allow NULL? |
| 29 | CONSTR_TYPE_FIN | Type of Scheduling Constraint | char | 1 | 0 | CHAR | (N' ') | Yes | | CGPL_CONSTRAINT | Allow NULL? |
| 30 | CONSTR_TIME_FIN | Constraint Date | decimal | 15 | 0 | DEC | ((0)) | Yes | | CGPL_CONSTRAINT_TIME | |
| 31 | APPLICATION | Application in Project Planning | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | CGPL_APPLICATION_TYPE | Allow NULL? |
| 32 | FORECAST_START | Forecast Start | decimal | 15 | 0 | DEC | ((0)) | Yes | | CGPL_FORECAST_START | |
| 33 | FORECAST_FINISH | Forecast Finish | decimal | 15 | 0 | DEC | ((0)) | Yes | | CGPL_FORECAST_FINISH | |
