| 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 | POSNR | WBS Element | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | PRPS | PS_POSNR | Allow NULL? |
| 3 | PSPHI | Current number of the appropriate project | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | PROJ | PS_PSPHI | Allow NULL? |
| 4 | PSTRT | WBS element: Basic start date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PS_PSTRT | Allow NULL? |
| 5 | ESTRT | Forecasted start date of the WBS element | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PS_ESTRT | Allow NULL? |
| 6 | ISTRT | Actual start date for the WBS element | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PS_ISTRT | Allow NULL? |
| 7 | PENDE | WBS element: Basic finish date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PS_PENDE | Allow NULL? |
| 8 | EENDE | Forecasted finish date of the WBS element | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PS_EENDE | Allow NULL? |
| 9 | IENDE | Actual finish date of the WBS element | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PS_IENDE | Allow NULL? |
| 10 | PDAUR | Length (duration) of the basic dates in the WBS element | decimal | 5 | 1 | QUAN | ((0)) | Yes | | PS_PDAUR | |
| 11 | EDAUR | Forecasted length (duration) of the WBS element | decimal | 5 | 1 | QUAN | ((0)) | Yes | | PS_EDAUR | |
| 12 | IDAUR | Actual length (duration) of the WBS element | decimal | 5 | 1 | QUAN | ((0)) | Yes | | PS_IDAUR | |
| 13 | IEINH | Unit for duration of actual WBS element dates | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | | PS_IEINH | Allow NULL? |
| 14 | EEINH | Unit for duration of WBS element planned dates | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | | PS_EEINH | Allow NULL? |
| 15 | PEINH | Unit for duration of basic WBS element dates | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | | PS_PEINH | Allow NULL? |
| 16 | FLGVG | Indicator: There are activities for the WBS elements | char | 1 | 0 | CHAR | (N' ') | Yes | | PS_FLGVG | Allow NULL? |
| 17 | FLGEW | Indicator: Expected dates from the activities | char | 1 | 0 | CHAR | (N' ') | Yes | | PS_FLGEW | Allow NULL? |
| 18 | FLGEM | Indicator: Forecast dates set manually | char | 1 | 0 | CHAR | (N' ') | Yes | | PS_FLGEM | Allow NULL? |
| 19 | FLGVM | Indicator: Basic dates set manually | char | 1 | 0 | CHAR | (N' ') | Yes | | PS_FLGVM | Allow NULL? |
| 20 | FLGIM | Indicator: Actual dates set manually | char | 1 | 0 | CHAR | (N' ') | Yes | | PS_FLGIM | Allow NULL? |
| 21 | FLGVI | Indicator: Actual dates from the activities | char | 1 | 0 | CHAR | (N' ') | Yes | | PS_FLGVI | Allow NULL? |
| 22 | PSTRM | Earliest scheduled start date (Basic) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PS_GSTRS | Allow NULL? |
| 23 | PETRM | Latest scheduled finish date (basic) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PS_GLTRS | Allow NULL? |
| 24 | ESTRM | Scheduled start date (Forecast) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PS_GSTPP | Allow NULL? |
| 25 | EETRM | Latest scheduled finish date (Forecast) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PS_GLTPP | Allow NULL? |
| 26 | VISTR | Tentative actual start date for WBS element | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PS_ISTVORL | Allow NULL? |
| 27 | VIEND | Tentative actual finish date for WBS element | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PS_IENVORL | Allow NULL? |
| 28 | PSTRS | Latest scheduled start date (basic) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PS_GSTRE | Allow NULL? |
| 29 | PETRF | Earliest scheduled finish date (basic) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PS_GETRE | Allow NULL? |
| 30 | ESTRS | Latest scheduled start date (forecast) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PS_GSTRP | Allow NULL? |
| 31 | EETRF | Earliest scheduled finish date (forecast) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PS_GLTRP | Allow NULL? |
