SAP VSPRPS_CN Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data Table
Overview
VSPRPS_CN is a standard SAP S/4HANA table that stores Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data data. There are total 126 fields in the VSPRPS_CN table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VSPRPS_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 VSPRPS_CN to other SAP tables and standard CDS views available based on VSPRPS_CN table in S/4HANA 2020.
Techincal Settings of VSPRPS_CN
Below are technical details of the table VSPRPS_CN
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VSPRPS_CN Fields
The following table gives you an overview of the fields available in VSPRPS_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 | WBS Element | PS_POSNR | NUMC | 8 | |
| POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | |
| POST1 | PS: Short description (1st text line) | PS_POST1 | CHAR | 40 | |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| PSPHI | Current number of the appropriate project | PS_PSPHI | VSPROJ_CN | NUMC | 8 |
| POSKI | WBS element short identification | PS_POSKI | CHAR | 16 | |
| 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 | |
| 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 | |
| PBUKR | Company code for WBS element | PS_PBUKR | T001 | CHAR | 4 |
| PGSBR | Business area for WBS element | PS_PGSBR | TGSB | CHAR | 4 |
| PKOKR | Controlling area for WBS element | PS_PKOKR | TKA01 | CHAR | 4 |
| PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 |
| PRART | Project Type | PS_PRART | TCJ1 | CHAR | 2 |
| STUFE | Level in Project Hierarchy | PS_STUFE | INT1 | 3 | |
| PLAKZ | Indicator: Planning element | PS_PLAKZ | CHAR | 1 | |
| BELKZ | Indicator: Account assignment element | PS_BELKZ | CHAR | 1 | |
| FAKKZ | Indicator: Billing element | PS_FAKKZ | CHAR | 1 | |
| NPFAZ | Relationship of network activity to production order | PS_NPFAR | CHAR | 1 | |
| ZUORD | Network assignment | PS_ZUORD | NUMC | 1 | |
| TRMEQ | Indicator: WBS dates detailed by activity dates | PS_TRMEQ | CHAR | 1 | |
| KVEWE | Usage of the condition table | KVEWE | T681V | CHAR | 1 |
| KAPPL | Application | KAPPL | T681A | CHAR | 2 |
| KALSM | Costing Sheet | AUFKALSM | T683 | CHAR | 6 |
| ZSCHL | Overhead key | AUFZSCHL | CHAR | 6 | |
| ABGSL | Results Analysis Key | ABGR_SCHL | TKKAA | CHAR | 6 |
| AKOKR | Controlling area of requesting cost center | PS_AKOKR | TKA01 | CHAR | 4 |
| AKSTL | Requesting cost center | PS_AKSTL | CSKS | CHAR | 10 |
| FKOKR | Responsible Cost Center Controlling Area | PS_FKOKR | TKA01 | CHAR | 4 |
| FKSTL | Responsible Cost Center | PS_FKSTL | CSKS | CHAR | 10 |
| FABKL | Factory calendar key | FABKL | TFACD | CHAR | 2 |
| PSPRI | Priority | NW_PRIO | TCN07 | CHAR | 1 |
| EQUNR | Equipment Number | EQUNR | EQUI | CHAR | 18 |
| TPLNR | Functional Location | TPLNR | IFLOT | CHAR | 30 |
| PWPOS | WBS element currency | PS_PWPOS | TCURC | CUKY | 5 |
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 |
| TXTSP | Language Key | SPRAS | T002 | LANG | 1 |
| SLWID | Key word ID for user-defined fields | SLWID | TCN00 | CHAR | 7 |
| USR00 | 1st user field for 20 characters - WBS element- | USR00PRPS | CHAR | 20 | |
| USR01 | 2nd user field 20 digits - WBS element | USR01PRPS | CHAR | 20 | |
| USR02 | 3rd user-defined field 10 digits -WBS element | USR02PRPS | CHAR | 10 | |
| USR03 | 4th user-defined field 10 digits -WBS element | USR03PRPS | CHAR | 10 | |
| USR04 | 1st user-defined field for quantity(length 103) WBS element | USR04PRPS | QUAN | 13 | |
| USE04 | 1st user defined field for quantity field unit - WBS element | USE04PRPS | T006 | UNIT | 3 |
| USR05 | 2nd use field for quantity (length 103) WBS element | USR05PRPS | QUAN | 13 | |
| USE05 | 2nd user defined field for quantity field unit - WBS element | USE05PRPS | T006 | UNIT | 3 |
| USR06 | 1st user field for values (length 103) WBS element | USR06PRPS | CURR | 13 | |
| USE06 | 1st user defined field for value field unit - WBS element | USE06PRPS | TCURC | CUKY | 5 |
| USR07 | 2nd user field for values (length 103) -WBS element | USR07PRPS | CURR | 13 | |
| USE07 | 2nd user defined field for value field unit - WBS element | USE07PRPS | TCURC | CUKY | 5 |
| USR08 | 1st user field for date -WBS element | USR08PRPS | DATS | 8 | |
| USR09 | 2nd user field for date -WBS element | USR09PRPS | DATS | 8 | |
| USR10 | 1st user field for 'Ind. for evaluations' WBS elem. | USR10PRPS | CHAR | 1 | |
| USR11 | 2nd user field for 'Indicator for eval.s' WBS elemnt | USR11PRPS | CHAR | 1 | |
| KOSTL | Cost center to which costs are actually posted | PS_KOSTL | CSKS | CHAR | 10 |
| KTRG | Cost Object | KSTRG | CKPH | CHAR | 12 |
| 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 | |
| CLASF | Indicator: WBS element used in project summarization | PS_CLASF | CHAR | 1 | |
| SPSNR | Std WBS: Internal project item number (w/exit on ID) | PS_SPSNR | PRPSS | NUMC | 8 |
| 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 |
| IMPRF | Investment Measure Profile | IM_PROFIL | TAPRF | CHAR | 6 |
| EVGEW | Aggregation weight for POC (PS progress) | EV_WEIGHTD | DEC | 8 | |
| AENNR | Change Number | AENNR | AENR | CHAR | 12 |
| SUBPR | Sub-project in work breakdown structure | PS_SUBPR | PRTP | CHAR | 12 |
| POSTU | PS: Short description (1st text line) in all caps | PS_POSTU | CHAR | 40 | |
| PLINT | Indicator for Integrated Planning | PLINT | CHAR | 1 | |
| LOEVM | Deletion Indicator | LOEVM | CHAR | 1 | |
| KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | |
| FPLNR | Billing plan number / invoicing plan number | FPLNR | * | CHAR | 10 |
| TADAT | Technically complete date | TABGDAT | DATS | 8 | |
| IZWEK | Reason for Investment | IZWEK | T087I | CHAR | 2 |
| ISIZE | Scale of investment objects | IM_SIZECL | TAIF5 | CHAR | 2 |
| IUMKZ | Reason for Environmental Investment | AM_UMWKZ | T087K | CHAR | 5 |
| ABUKR | Requesting company code | IM_ABUKRS | T001 | CHAR | 4 |
| GRPKZ | Indicator: Grouping WBS element | GRPSPKZ | CHAR | 1 | |
| PGPRF | Distribution profile | PGPROFID | TPGPRF | CHAR | 6 |
| LOGSYSTEM | Logical System | LOGSYSTEM | * | CHAR | 10 |
| PSPNR_LOGS | Numeric field length 8 | NUM08 | NUMC | 8 | |
| STORT | Location | PS_STORT | T499S | CHAR | 10 |
| FUNC_AREA | Functional Area | FKBER | TFKB | CHAR | 16 |
| KLVAR | Costing Variant | CK_KLVAR | * | CHAR | 4 |
| KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | * | NUMC | 12 |
| POSID_EDIT | Work Breakdown Structure Element (WBS Element) Edited | PS_POSID_EDIT | CHAR | 24 | |
| PSPKZ | Indicator: WBS element for production lot | PL_PSPKZ | CHAR | 1 | |
| MATNR | Material Number | MATNR | CHAR | 40 | |
| VLPSP | WBS: Reference work breakdown structure element | PL_PSP_PNR | * | NUMC | 8 |
| VLPKZ | Indicator: Reference WBS element for production lot | PL_VLPKZ | CHAR | 1 | |
| SORT1 | Sort string 1 for production lot | PL_SORT1 | CHAR | 10 | |
| SORT2 | Sort string 2 for production lot | PL_SORT2 | CHAR | 10 | |
| SORT3 | Sort string 3 for production lot | PL_SORT3 | CHAR | 10 | |
| 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 |
| CGPL_GUID16 | Generic project planning: GUID from external R/3 system | CGPL_GUID16_R3 | RAW | 16 | |
| CGPL_LOGSYS | Generic project planning: Log. system for CGPL_GUID16_R3 | CGPL_LOGSYS | * | CHAR | 10 |
| CGPL_OBJTYPE | Generic project planning: object type from ext. R/3 system | CGPL_OBJECT_TYPE_R3 | CHAR | 3 | |
| ADPSP | Reference Element PM/PS | ADDCOMPARE_CORE | CHAR | 40 | |
| RFIPPNT | Reference Point for Relationship Between iPPE and PS | CN_RPIP | TCNRPIP | CHAR | 20 |
| EEW_PRPS_PS_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | |
| RFUND | Fund | BP_GEBER | * | CHAR | 10 |
| RGRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | |
| FUND_FIX_ASSIGN | Indicator for Fund with Fixed Assignment | PSM_FUND_FIX_ASSIGNED | CHAR | 1 | |
| GRANT_FIX_ASSIGNED | Indicator for Grant with Fixed Assignment | PSM_GRANT_FIX_ASSIGNED | CHAR | 1 | |
| FUNC_AREA_FIX_ASSIGNED | Indicator for Functional Area with Fixed Assignment | PSM_FUNC_AREA_FIX_ASSIGNED | CHAR | 1 | |
| SPONSOREDPROG | Sponsored Program | GM_SPONSORED_PROG | * | CHAR | 20 |
| ORGKEY | Project (internal) | PS_INTNR | * | NUMC | 8 |
| INCAT | Version inactive indicator | VSINACT | CHAR | 1 | |
| PRPS_STATUS | Status Combination | ACTCMB_DELE | ACTCMB_TAB | INT1 | 3 |
| CPD_UPDAT | Time Stamp | /CPD/PFP_TSTMP | DEC | 15 | |
| FERC_IND | Regulatory indicator | FE_IND | FERC_C7 | CHAR | 4 |
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 VSPRPS_CN
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VSPRPS_CN | ABGSL | : | TKKAA |
| VSPRPS_CN | ABUKR | 1: CN | T001 |
| VSPRPS_CN | AENNR | C: CN | AENR |
| VSPRPS_CN | AKOKR | : | TKA01 |
| VSPRPS_CN | AKSTL | : | CSKS |
| VSPRPS_CN | ASTNR | : | TCJ05 |
| VSPRPS_CN | EQUNR | : | EQUI |
| VSPRPS_CN | ETYPE | : | T8JE |
| VSPRPS_CN | FABKL | : | TFACD |
| VSPRPS_CN | FERC_IND | : | FERC_C7 |
| VSPRPS_CN | FKOKR | : | TKA01 |
| VSPRPS_CN | FKSTL | : | CSKS |
| VSPRPS_CN | FUNC_AREA | : | TFKB |
| VSPRPS_CN | IMPRF | : | TAPRF |
| VSPRPS_CN | ISIZE | 1: CN | TAIF5 |
| VSPRPS_CN | IUMKZ | 1: CN | T087K |
| VSPRPS_CN | IZWEK | 1: CN | T087I |
| VSPRPS_CN | JIBCL | : | T8J6A |
| VSPRPS_CN | JIBSA | : | T8J6C |
| VSPRPS_CN | KALSM | : | T683 |
| VSPRPS_CN | KAPPL | : | T681A |
| VSPRPS_CN | KOSTL | : | CSKS |
| VSPRPS_CN | KTRG | : | CKPH |
| VSPRPS_CN | KVEWE | : | T681V |
| VSPRPS_CN | MANDT | 1: CN | T000 |
| VSPRPS_CN | OBJNR | C: C | ONR00 |
| VSPRPS_CN | PBUKR | : | T001 |
| VSPRPS_CN | PGPRF | 1: CN | TPGPRF |
| VSPRPS_CN | PGSBR | : | TGSB |
| VSPRPS_CN | PKOKR | : | TKA01 |
| VSPRPS_CN | PRART | : | TCJ1 |
| VSPRPS_CN | PRCTR | : | CEPC |
| VSPRPS_CN | PRPS_STATUS | : | ACTCMB_TAB |
| VSPRPS_CN | PSPHI | 1: CN | VSPROJ_CN |
| VSPRPS_CN | PSPRI | C: CN | TCN07 |
| VSPRPS_CN | PWPOS | : | TCURC |
| VSPRPS_CN | RECID | : | T8JJ |
| VSPRPS_CN | RFIPPNT | C: CN | TCNRPIP |
| VSPRPS_CN | SLWID | : | TCN00 |
| VSPRPS_CN | SPSNR | : | PRPSS |
| VSPRPS_CN | STORT | : | T499S |
| VSPRPS_CN | SUBPR | C: CN | PRTP |
| VSPRPS_CN | TPLNR | : | IFLOT |
| VSPRPS_CN | TXJCD | : | TTXJ |
| VSPRPS_CN | TXTSP | : | T002 |
| VSPRPS_CN | USE04 | : | T006 |
| VSPRPS_CN | USE05 | : | T006 |
| VSPRPS_CN | USE06 | : | TCURC |
| VSPRPS_CN | USE07 | : | TCURC |
| VSPRPS_CN | VERNR | : | TCJ04 |
| VSPRPS_CN | VNAME | : | T8JV |
| VSPRPS_CN | WERKS | : | T001W |
| VSPRPS_CN | ZSCHM | : | TPI01 |