| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | EXT_OBJECT_ID | External Object Technical Key | nvarchar | 34 | 0 | CHAR | (N' ') | No | IAOM_EXT_OBJ_INF | IAOM_EXT_OBJECT_ID | Allow NULL? |
| 3 | PROJECT_ID | Project Number in cProjects | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | DPR_TV_PROJECT_ID_CO | Allow NULL? |
| 4 | BEZEICH | Description | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | DPR_TV_BEZEICH_CO | Allow NULL? |
| 5 | HR_PLANVARIANTE | Plan Version | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T778P | PCHDYPLVAR | Allow NULL? |
| 6 | HR_OBJEKTTYP | Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T778O | PCHDYOTYPE | Allow NULL? |
| 7 | RESP_ORG_UNIT | Organization Responsible | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | HRP1000 | DPR_TV_RESP_ORGANIZATION_CO | Allow NULL? |
| 8 | PRIORITY | Priority | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | DPR_TV_PRIORITY_CO | Allow NULL? |
| 9 | PRO_TYPE | Project Type | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | DPR_PRO_TYPE_C | DPR_TV_PRO_TYPE_CO | Allow NULL? |
| 10 | CAUSE | Project Reason | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | DPR_CAUSE_CO | DPR_TV_CAUSE_CO | Allow NULL? |
| 11 | GROUPING | Grouping | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | DPR_TV_GROUPING_CO | Allow NULL? |
| 12 | SEARCH_FIELD | Search Field | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | DPR_TV_SEARCH_FIELD_CO | Allow NULL? |
| 13 | TEMP_EXTERNAL_ID | Template Number | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | DPR_TV_TEMP_EXTERNAL_ID_CO | Allow NULL? |
| 14 | CUSTOMER | Sold-to party | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUNAG | Allow NULL? |
| 15 | PROJ_ELEMENT_ID | External ID of a Project Element | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | DPR_TV_PROJECT_ELEMENT_ID_CO | Allow NULL? |
| 16 | OBJECT_TYPE | Object Category of Project Element | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | DPR_TV_OBJECT_TYPE_CO | Allow NULL? |
| 17 | BEZEICH_PRJ_ELEM | Name of Project Element | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | DPR_TV_BEZEICH_PROJ_ELEMENT_CO | Allow NULL? |
| 18 | CONTROLLING_METH | Controlling Method for cProjects | char | 1 | 0 | CHAR | (N' ') | Yes | | DPR_TV_CONTROLLING_METHOD | Allow NULL? |
| 19 | ELEMENT_LEVEL | CGPL Planning Level of an Activity (Interface Conversion) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | DPR_TV_CGPL_LEVEL | Allow NULL? |
