SAP ABAP Table PROJSTAT (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | PROJSTAT | Table Relationship Diagram |
Short Description | Generated Table for View |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | PROJECT_ID | PROJECT_ID | PROJECT_ID | CHAR | 10 | 0 | Project name | ||
2 | OBJ_TYPE | OBJE_TYPE | OBJE_TYPE | CHAR | 4 | 0 | Project management object type | ||
3 | NODE_ID | HIER_GUID | SYCHAR32 | CHAR | 32 | 0 | Unique ID - 32 characters | ||
4 | NODE_TYPE | HIER_NODET | HIER_NODET | CHAR | 4 | 0 | Valid Node Types in Structure Repository | TNODEH | |
5 | ID | STATUS_ID | SYCHAR32 | CHAR | 32 | 0 | Unique identifier for status information | ||
6 | STATUS | STAT_STAT | STAT_STAT | CHAR | 10 | 0 | Processing status | ||
7 | PLANSTART | STAT_PLSTA | DATUM | DATS | 8 | 0 | Planned Start | ||
8 | PLANEND | STAT_PLEND | DATUM | DATS | 8 | 0 | Planned end | ||
9 | PLANDUR | STAT_PLDUR | STAT_DUR | INT2 | 5 | 0 | Planned work | ||
10 | ACTULSTART | STAT_ACSTA | DATUM | DATS | 8 | 0 | Actual start | ||
11 | ACTULEND | STAT_ACEND | DATUM | DATS | 8 | 0 | Actual end | ||
12 | ACTULDUR | STAT_ACDUR | STAT_DUR | INT2 | 5 | 0 | Actual work | ||
13 | RESTWORK | STAT_REST | STAT_DUR | INT2 | 5 | 0 | Remaining work | ||
14 | DONE | STAT_DONE | STAT_PERC | NUMC | 3 | 0 | Percent complete | ||
15 | PRIORITY | PROJ_PRIO | CHAR1 | CHAR | 1 | 0 | Activity priority | ||
16 | ISP_PLAN | CHAR32 | CHAR32 | CHAR | 32 | 0 | Character field, length 32 | ||
17 | ISP_ELEM | ISP_ELE | CHAR4 | CHAR | 4 | 0 | Process number | ||
18 | ISP_CODE | ISP_CODE | CHAR10 | CHAR | 10 | 0 | Value Field | ||
19 | STAT_REL | STAT_REL | SYCHAR04 | CHAR | 4 | 0 | Activity Release | ||
20 | ISP_CODE2 | ISP_CODE | CHAR10 | CHAR | 10 | 0 | Value Field | ||
21 | ISP_CODE3 | ISP_CODE | CHAR10 | CHAR | 10 | 0 | Value Field | ||
22 | FDATE | STAT_FDATE | DATUM | DATS | 8 | 0 | Date created | ||
23 | FUSER | STAT_FUSER | UNAME | CHAR | 12 | 0 | Created By | ||
24 | LDATE | STAT_LDATE | DATUM | DATS | 8 | 0 | Changed On | ||
25 | LUSER | STAT_LUSER | UNAME | CHAR | 12 | 0 | Changed by | ||
26 | FTIME | STAT_FTIME | UZEIT | TIMS | 6 | 0 | Created at | ||
27 | LTIME | STAT_LTIME | UZEIT | TIMS | 6 | 0 | Changed At | ||
28 | CLASS | PROJ_CLASS | PROJ_CLASS | CHAR | 6 | 0 | Possible Project Type | ||
29 | PROJ_LANG | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
30 | RESPONSIBL | PROJ_RESP | UNAME | CHAR | 12 | 0 | Project manager | ||
31 | APP_COMP | UFFCTR | UFFCTR | CHAR | 20 | 0 | Application Component | ||
32 | REF_PROJ | PROJECT_ID | PROJECT_ID | CHAR | 10 | 0 | Project name | ||
33 | BEGIN_DATE | STAT_FDATE | DATUM | DATS | 8 | 0 | Date created | ||
34 | END_DATE | STAT_FDATE | DATUM | DATS | 8 | 0 | Date created | ||
35 | RELEASE | PROJ_REL | SYCHAR04 | CHAR | 4 | 0 | Project Release | ||
36 | KENN1 | PROJ_K1 | CHAR1 | CHAR | 1 | 0 | Project flag | ||
37 | PFDATE | STAT_FDATE | DATUM | DATS | 8 | 0 | Date created | ||
38 | PFUSER | STAT_FUSER | UNAME | CHAR | 12 | 0 | Created By | ||
39 | PLDATE | STAT_LDATE | DATUM | DATS | 8 | 0 | Changed On | ||
40 | PLUSER | STAT_LUSER | UNAME | CHAR | 12 | 0 | Changed by |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PROJSTAT | NODE_TYPE | TNODEH | NODE_TYPE | 1 | CN | |
2 | PROJSTAT | PROJ_LANG | T002 | SPRAS | REF |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |