SAP VSPRTE_CN Version: Scheduling data for project item Table
Overview
VSPRTE_CN is a standard SAP S/4HANA table that stores Version: Scheduling data for project item data. There are total 32 fields in the VSPRTE_CN table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VSPRTE_CN belongs to Simulation (PS-SIM) module and is located in the package R/3 Application development: Version Management (CNVS).
In addition, following links provide an overview of foreign key relationships, if any, that link VSPRTE_CN to other SAP tables and standard CDS views available based on VSPRTE_CN table in S/4HANA 2020.
Techincal Settings of VSPRTE_CN
Below are technical details of the table VSPRTE_CN
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VSPRTE_CN Fields
The following table gives you an overview of the fields available in VSPRTE_CN
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VSNMR | Number or description of a version | VSNMR | CHAR | 12 | |
| POSNR | WBS Element | PS_POSNR | NUMC | 8 | |
| PSPHI | Current number of the appropriate project | PS_PSPHI | VSPROJ_CN | NUMC | 8 |
| PSTRT | WBS element: Basic start date | PS_PSTRT_CHG | DATS | 8 | |
| ESTRT | Forecast Start Date of WBS Element | PS_ESTRT | DATS | 8 | |
| ISTRT | Actual start date for the WBS element | PS_ISTRT | DATS | 8 | |
| PENDE | WBS element: Basic finish date | PS_PENDE_CHG | DATS | 8 | |
| EENDE | Forecast Finish Date of WBS Element | PS_EENDE | DATS | 8 | |
| IENDE | Actual finish date of the WBS element | PS_IENDE | DATS | 8 | |
| PDAUR | Length (duration) of the basic dates in the WBS element | PS_PDAUR | QUAN | 5 | |
| EDAUR | Forecasted length (duration) of the WBS element | PS_EDAUR | QUAN | 5 | |
| IDAUR | Actual length (duration) of the WBS element | PS_IDAUR | QUAN | 5 | |
| IEINH | Unit for duration of actual WBS element dates | PS_IEINH | UNIT | 3 | |
| EEINH | Unit for duration of WBS element planned dates | PS_EEINH | UNIT | 3 | |
| PEINH | Unit for duration of basic WBS element dates | PS_PEINH | UNIT | 3 | |
| FLGVG | Indicator: There are activities for the WBS elements | PS_FLGVG | CHAR | 1 | |
| FLGEW | Indicator: Expected dates from the activities | PS_FLGEW | CHAR | 1 | |
| FLGEM | Indicator: Forecast dates set manually | PS_FLGEM | CHAR | 1 | |
| FLGVM | Indicator: Basic dates set manually | PS_FLGVM | CHAR | 1 | |
| FLGIM | Indicator: Actual dates set manually | PS_FLGIM | CHAR | 1 | |
| FLGVI | Indicator: Actual dates from the activities | PS_FLGVI | CHAR | 1 | |
| PSTRM | Earliest scheduled start date (Basic) | PS_GSTRS | DATS | 8 | |
| PETRM | Latest scheduled finish date (basic) | PS_GLTRS | DATS | 8 | |
| ESTRM | Scheduled start date (Forecast) | PS_GSTPP | DATS | 8 | |
| EETRM | Latest scheduled finish date (Forecast) | PS_GLTPP | DATS | 8 | |
| VISTR | Tentative actual start date for WBS element | PS_ISTVORL | DATS | 8 | |
| VIEND | Tentative actual finish date for WBS element | PS_IENVORL | DATS | 8 | |
| PSTRS | Latest scheduled start date (basic) | PS_GSTRE | DATS | 8 | |
| PETRF | Earliest scheduled finish date (basic) | PS_GETRE | DATS | 8 | |
| ESTRS | Latest scheduled start date (forecast) | PS_GSTRP | DATS | 8 | |
| EETRF | Earliest scheduled finish date (forecast) | PS_GLTRP | DATS | 8 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VSPRTE_CN
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VSPRTE_CN | MANDT | 1: 1 | T000 |
| VSPRTE_CN | PSPHI | 1: CN | VSPROJ_CN |