SAP table PRTE (Scheduling Data for Project Item)
SAP table PRTE has 2 primary key fields being MANDT,POSNR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| POSNR | WBS Element | NUMC | 8 | 0 | PRPS | PS_POSNR | |
| PSPHI | Current number of the appropriate project | NUMC | 8 | 0 | PROJ | PS_PSPHI | |
| PSTRT | WBS element: Basic start date | DATS | 8 | 0 | PS_PSTRT_CHG | ||
| ESTRT | Forecast Start Date of WBS Element | DATS | 8 | 0 | PS_ESTRT | ||
| ISTRT | Actual start date for the WBS element | DATS | 8 | 0 | PS_ISTRT | ||
| PENDE | WBS element: Basic finish date | DATS | 8 | 0 | PS_PENDE_CHG | ||
| EENDE | Forecast Finish Date of WBS Element | DATS | 8 | 0 | PS_EENDE | ||
| IENDE | Actual finish date of the WBS element | DATS | 8 | 0 | PS_IENDE | ||
| PDAUR | Length (duration) of the basic dates in the WBS element | QUAN | 5 | 1 | PS_PDAUR | ||
| EDAUR | Forecasted length (duration) of the WBS element | QUAN | 5 | 1 | PS_EDAUR | ||
| IDAUR | Actual length (duration) of the WBS element | QUAN | 5 | 1 | PS_IDAUR | ||
| IEINH | Unit for duration of actual WBS element dates | UNIT | 3 | 0 | PS_IEINH | ||
| EEINH | Unit for duration of WBS element planned dates | UNIT | 3 | 0 | PS_EEINH | ||
| PEINH | Unit for duration of basic WBS element dates | UNIT | 3 | 0 | PS_PEINH | ||
| FLGVG | Indicator: There are activities for the WBS elements | CHAR | 1 | 0 | PS_FLGVG | ||
| FLGEW | Indicator: Expected dates from the activities | CHAR | 1 | 0 | PS_FLGEW | ||
| FLGEM | Indicator: Forecast dates set manually | CHAR | 1 | 0 | PS_FLGEM | ||
| FLGVM | Indicator: Basic dates set manually | CHAR | 1 | 0 | PS_FLGVM | ||
| FLGIM | Indicator: Actual dates set manually | CHAR | 1 | 0 | PS_FLGIM | ||
| FLGVI | Indicator: Actual dates from the activities | CHAR | 1 | 0 | PS_FLGVI | ||
| PSTRM | Earliest scheduled start date (Basic) | DATS | 8 | 0 | PS_GSTRS | ||
| PETRM | Latest scheduled finish date (basic) | DATS | 8 | 0 | PS_GLTRS | ||
| ESTRM | Scheduled start date (Forecast) | DATS | 8 | 0 | PS_GSTPP | ||
| EETRM | Latest scheduled finish date (Forecast) | DATS | 8 | 0 | PS_GLTPP | ||
| VISTR | Tentative actual start date for WBS element | DATS | 8 | 0 | PS_ISTVORL | ||
| VIEND | Tentative actual finish date for WBS element | DATS | 8 | 0 | PS_IENVORL | ||
| PSTRS | Latest scheduled start date (basic) | DATS | 8 | 0 | PS_GSTRE | ||
| PETRF | Earliest scheduled finish date (basic) | DATS | 8 | 0 | PS_GETRE | ||
| ESTRS | Latest scheduled start date (forecast) | DATS | 8 | 0 | PS_GSTRP | ||
| EETRF | Earliest scheduled finish date (forecast) | DATS | 8 | 0 | PS_GLTRP |
PRTE foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 PRTE | POSNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| 0 PRTE | POSNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| 1 PRTE | PSPHI | PROJ | Project definition | MANDT |
| 1 PRTE | PSPHI | PROJ | Project definition | PSPNR |