SAP VSPROJ_CN Version: Project definition Table
Overview
VSPROJ_CN is a standard SAP S/4HANA table that stores Version: Project definition data. There are total 112 fields in the VSPROJ_CN table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VSPROJ_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 VSPROJ_CN to other SAP tables and standard CDS views available based on VSPROJ_CN table in S/4HANA 2020.
Techincal Settings of VSPROJ_CN
Below are technical details of the table VSPROJ_CN
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VSPROJ_CN Fields
The following table gives you an overview of the fields available in VSPROJ_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 | |
| PSPNR | Project (internal) | PS_INTNR | NUMC | 8 | |
| PSPID | Project definition | PS_PSPID | CHAR | 24 | |
| POST1 | PS: Short description (1st text line) | PS_POST1 | CHAR | 40 | |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| AENAM | Name of person who changed object | AENAM | CHAR | 12 | |
| AEDAT | Date on which object was last changed | UPDAT | DATS | 8 | |
| KIMSK | Selection mask for WBS element short IDs | PS_KIMSK | CHAR | 24 | |
| AUTOD | Automatic value transfer from WBS element to project def. | PS_AUTOD | CHAR | 1 | |
| STSPD | Status profile for project definition | PS_STSPD | TJ20 | CHAR | 8 |
| STSPR | Status profile for WBS element | PS_STSPR | TJ20 | CHAR | 8 |
| VERNR | Number of the Responsible Person (Project Manager) | PS_VERNR | TCJ04 | NUMC | 8 |
| VERNA | Name of responsible person (Project manager) | PS_VERNA | CHAR | 25 | |
| ASTNR | Applicant number | PS_ASTNR | TCJ05 | NUMC | 8 |
| ASTNA | Applicant | PS_ASTNA | CHAR | 25 | |
| VBUKR | Company code for the project | PS_VBUKR | T001 | CHAR | 4 |
| VGSBR | Business area for the project | PS_VGSBR | TGSB | CHAR | 4 |
| VKOKR | Controlling area for the project | PS_VKOKR | TKA01 | CHAR | 4 |
| PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 |
| PWHIE | WBS currency (project definition) | PS_PWHIE | TCURC | CUKY | 5 |
| ZUORD | Network assignment | PS_ZUORD | NUMC | 1 | |
| TRMEQ | Indicator: WBS dates detailed by activity dates | PS_TRMEQ | CHAR | 1 | |
| PLFAZ | Project planned start date | PS_PLFAZ_CHG | DATS | 8 | |
| PLSEZ | Project planned finish date | PS_PLSEZ_CHG | DATS | 8 | |
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 |
| KALID | Factory calendar key | FABKL | TFACD | CHAR | 2 |
| VGPLF | Planning method for project basic dates | PS_VGPLF | NUMC | 1 | |
| EWPLF | Planning method for project forecast dates | PS_EWPLF | NUMC | 1 | |
| ZTEHT | Time unit in time scheduling | PS_ZTEHT | T006 | UNIT | 3 |
| NZANZ | Indicator: Network header visible to end user | NETZOBERFL | CHAR | 1 | |
| PLNAW | Application of the task list | PLNAW | TCA09 | CHAR | 1 |
| VPROF | Network Profile | PROFIDNZPL | TCN41 | CHAR | 7 |
| PROFL | Project Profile | PROFIDPROJ | TCJ41 | CHAR | 7 |
| BPROF | Budget Profile | BP_BPROFIL | TBP1C | CHAR | 6 |
| TXTSP | Language Key | SPRAS | T002 | LANG | 1 |
| KOSTL | Cost Center | KOSTL | CSKS | CHAR | 10 |
| KTRG | Cost Object | KSTRG | CKPH | CHAR | 12 |
| AEDTE | Date of last scheduling of the overall network (basic dates) | PS_AEDTE | DATS | 8 | |
| AEDTP | Date of last scheduling of the overall network (forecast) | PS_AEDTP | DATS | 8 | |
| BERST | Authorization key for project master data | PS_BERST | CHAR | 16 | |
| BERTR | Authorization key for project dates (WBS) | PS_BERTR | CHAR | 16 | |
| BERKO | Authorization key for costs and revenues | PS_BERKO | CHAR | 16 | |
| BERBU | Authorization key for project budget | PS_BERBU | CHAR | 16 | |
| SPSNR | Current number for standard project | PS_ISPSP | PROJS | NUMC | 8 |
| BESTA | Project stock | PS_BESTAND | CHAR | 1 | |
| SCOPE | Object Class | SCOPE_CV | CHAR | 2 | |
| XSTAT | Statistical WBS element | PS_XSTAT | CHAR | 1 | |
| TXJCD | Tax Jurisdiction | TXJCD | TTXJ | CHAR | 15 |
| ZSCHM | Interest Profile for Project/Order Interest Calculation | PS_ZSCHM | TPI01 | CHAR | 7 |
| SCPRF | Profile for WBS scheduling | PS_SCHDPRF | TCXPS | CHAR | 12 |
| IMPRF | Investment Measure Profile | IM_PROFIL | TAPRF | CHAR | 6 |
| FMPRF | Payment plan profile | PSFM_PRF | TBP1C | CHAR | 6 |
| ABGSL | Results Analysis Key | ABGR_SCHL | TKKAA | CHAR | 6 |
| POSTU | PS: Short description (1st text line) in all caps | PS_POSTU | CHAR | 40 | |
| PPROF | Planning Profile | BP_PPROFIL | TBP1C | CHAR | 6 |
| PLINT | Indicator for Integrated Planning | PLINT | CHAR | 1 | |
| LOEVM | Deletion Indicator | LOEVM | CHAR | 1 | |
| INACT | Indicator: Project definition inactive | PS_INACT | CHAR | 1 | |
| KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | |
| SMPRF | Simulation profile | SIM_PROFIL | TCN54 | CHAR | 7 |
| FLGVRG | Indicator: Bottom-up calculation with activity dates | PS_FLGVRG | CHAR | 1 | |
| GRTOP | Indicator: Automatic requirements grouping | GRONTOP | CHAR | 1 | |
| PGPRF | Distribution profile | PGPROFID | TPGPRF | CHAR | 6 |
| STORT | Location | PS_STORT | T499S | CHAR | 10 |
| LOGSYSTEM | Logical System | LOGSYSTEM | * | CHAR | 10 |
| KZERB | Indicator: Project summarization via master data charact. | PS_KZERB | CHAR | 1 | |
| PARGR | Partner Determination Procedure | PARGR | V_TVPG_S | CHAR | 4 |
| FUNC_AREA | Functional Area | FKBER | TFKB | CHAR | 16 |
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 |
| VTWEG | Distribution Channel | VTWEG | TVKOV | CHAR | 2 |
| SPART | Division | SPART | TVTA | CHAR | 2 |
| DPPPROF | Dynamic Item Processor Profile | AD01PROFNR | AD01C_PROF | CHAR | 8 |
| VPKSTU | Node level | SEU_LEVEL | NUMC | 2 | |
| PSPID_EDIT | Project Number (External) Edited | PS_PSPID_EDIT | CHAR | 24 | |
| VNAME | Joint venture | JV_NAME | T8JV | CHAR | 6 |
| RECID | Recovery Indicator | JV_RECIND | T8JJ | CHAR | 2 |
| ETYPE | Equity type | JV_ETYPE | T8JE | CHAR | 3 |
| OTYPE | Joint Venture Object Type | JV_OTYPE | CHAR | 4 | |
| JIBCL | JIB/JIBE Class | JV_JIBCL | T8J6A | CHAR | 3 |
| JIBSA | JIB/JIBE Subclass A | JV_JIBSA | T8J6C | CHAR | 5 |
| EEW_PROJ_PS_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | |
| SCHTYP | Scheduling scenario | PS_SCHED_TYPE | CHAR | 1 | |
| SPROG | Forecast start date of project definition | PS_SPROG | DATS | 8 | |
| EPROG | Forecast finish date for project definition | PS_EPROG | DATS | 8 | |
| ORGKEY | Project (internal) | PS_INTNR | * | NUMC | 8 |
| INCAT | Version inactive indicator | VSINACT | CHAR | 1 | |
| PROJ_STATUS | Status Combination | ACTCMB_DELE | ACTCMB_TAB | INT1 | 3 |
| SLWID | Key word ID for user-defined fields | SLWID | TCN00 | CHAR | 7 |
| USR00 | User field with 20 characters | USRCHAR20 | CHAR | 20 | |
| USR01 | User field with 20 characters | USRCHAR20 | CHAR | 20 | |
| USR02 | User field with 10 characters | USRCHAR10 | CHAR | 10 | |
| USR03 | User field with 10 characters | USRCHAR10 | CHAR | 10 | |
| USR04 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13 | |
| USE04 | User field: Unit for quantity fields | USRUNIT | * | UNIT | 3 |
| USR05 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13 | |
| USE05 | User field: Unit for quantity fields | USRUNIT | * | UNIT | 3 |
| USR06 | User-defined field for values (length 103) | USRCURR13 | CURR | 13 | |
| USE06 | User field: Unit for value fields | USRCUKY | TCURC | CUKY | 5 |
| USR07 | User-defined field for values (length 103) | USRCURR13 | CURR | 13 | |
| USE07 | User field: Unit for value fields | USRCUKY | TCURC | CUKY | 5 |
| USR08 | User field for date | USRDATE | DATS | 8 | |
| USR09 | User field for date | USRDATE | DATS | 8 | |
| USR10 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 | |
| USR11 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 | |
| CPD_UPDAT | Time Stamp | /CPD/PFP_SC_TSTMP | DEC | 15 | |
| FERC_IND | Regulatory indicator | FE_IND | FERC_C7 | CHAR | 4 |
| AVC_PROFILE | Budget Availability Control: Profile | FCO_AVC_PROFILE | * | CHAR | 6 |
| AVC_ACTIVE | Availability control indicator(AVC) | PS_S4_AVC_IND | CHAR | 1 | |
| CPCURR | Custom Project Currency | PS_S4_WAERS | * | CUKY | 5 |
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 VSPROJ_CN
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VSPROJ_CN | ABGSL | C: CN | TKKAA |
| VSPROJ_CN | ASTNR | : | TCJ05 |
| VSPROJ_CN | BPROF | : | TBP1C |
| VSPROJ_CN | DPPPROF | : | AD01C_PROF |
| VSPROJ_CN | ETYPE | : | T8JE |
| VSPROJ_CN | FERC_IND | : | FERC_C7 |
| VSPROJ_CN | FMPRF | C: CN | TBP1C |
| VSPROJ_CN | FUNC_AREA | : | TFKB |
| VSPROJ_CN | IMPRF | C: CN | TAPRF |
| VSPROJ_CN | JIBCL | : | T8J6A |
| VSPROJ_CN | JIBSA | : | T8J6C |
| VSPROJ_CN | KALID | : | TFACD |
| VSPROJ_CN | KOSTL | : | CSKS |
| VSPROJ_CN | KTRG | : | CKPH |
| VSPROJ_CN | MANDT | 1: CN | T000 |
| VSPROJ_CN | OBJNR | C: C | ONR00 |
| VSPROJ_CN | PARGR | C: CN | V_TVPG_S |
| VSPROJ_CN | PGPRF | 1: CN | TPGPRF |
| VSPROJ_CN | PLNAW | : | TCA09 |
| VSPROJ_CN | PPROF | C: CN | TBP1C |
| VSPROJ_CN | PRCTR | : | CEPC |
| VSPROJ_CN | PROFL | : | TCJ41 |
| VSPROJ_CN | PROJ_STATUS | : | ACTCMB_TAB |
| VSPROJ_CN | PWHIE | : | TCURC |
| VSPROJ_CN | RECID | : | T8JJ |
| VSPROJ_CN | SCPRF | C: CN | TCXPS |
| VSPROJ_CN | SLWID | : | TCN00 |
| VSPROJ_CN | SMPRF | 1: CN | TCN54 |
| VSPROJ_CN | SPART | : | TVTA |
| VSPROJ_CN | SPSNR | : | PROJS |
| VSPROJ_CN | STORT | : | T499S |
| VSPROJ_CN | STSPD | : | TJ20 |
| VSPROJ_CN | STSPR | : | TJ20 |
| VSPROJ_CN | TXJCD | : | TTXJ |
| VSPROJ_CN | TXTSP | : | T002 |
| VSPROJ_CN | USE06 | : | TCURC |
| VSPROJ_CN | USE07 | : | TCURC |
| VSPROJ_CN | VBUKR | : | T001 |
| VSPROJ_CN | VERNR | : | TCJ04 |
| VSPROJ_CN | VGSBR | : | TGSB |
| VSPROJ_CN | VKOKR | : | TKA01 |
| VSPROJ_CN | VKORG | : | TVKO |
| VSPROJ_CN | VNAME | : | T8JV |
| VSPROJ_CN | VPROF | : | TCN41 |
| VSPROJ_CN | VTWEG | : | TVKOV |
| VSPROJ_CN | WERKS | : | T001W |
| VSPROJ_CN | ZSCHM | : | TPI01 |
| VSPROJ_CN | ZTEHT | : | T006 |