SAP ABAP Table VSPRPS_CN (Version: WBS element master data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ SRM-EBP (Application Component) Enterprise Buyer
⤷ CNVS (Package) R/3 Application development: Version Management
⤷ SRM-EBP (Application Component) Enterprise Buyer
⤷ CNVS (Package) R/3 Application development: Version Management
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | VSPRPS_CN | Table Relationship Diagram |
Short Description | Version: WBS element master data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | .INCLUDE | 0 | 0 | Version: PS version, version-related key fields | |||||
3 | VSNMR | VSNMR | VSNMR | CHAR | 12 | 0 | Number or description of a version | ||
4 | PSPNR | PS_POSNR | PS_POSNR | NUMC | 8 | 0 | WBS Element | * | |
5 | .INCLUDE | 0 | 0 | PS: Data portion of WBS element master data Include | |||||
6 | POSID | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
7 | POST1 | PS_POST1 | TEXT40 | CHAR | 40 | 0 | PS: Short description (first text line) | ||
8 | OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | ONR00 | |
9 | PSPHI | PS_PSPHI | PS_PSPNR | NUMC | 8 | 0 | Current number of the appropriate project | VSPROJ_CN | |
10 | .INCLUDE | 0 | 0 | PS: Data portion of WBS element master data Include | |||||
11 | POSKI | PS_POSKI | PS_PROKI | CHAR | 16 | 0 | WBS element short identification | ||
12 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
13 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
14 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
15 | AEDAT | UPDAT | DATUM | DATS | 8 | 0 | Date on which object was last changed | ||
16 | VERNR | PS_VERNR | PS_VERNR | NUMC | 8 | 0 | Number of the responsible person (project manager) | * | |
17 | VERNA | PS_VERNA | PS_VERNA | CHAR | 25 | 0 | Name of responsible person (Project manager) | ||
18 | ASTNR | PS_ASTNR | PS_ASTNR | NUMC | 8 | 0 | Applicant number | * | |
19 | ASTNA | PS_ASTNA | PS_ASTNA | CHAR | 25 | 0 | Applicant | ||
20 | PBUKR | PS_PBUKR | BUKRS | CHAR | 4 | 0 | Company code for WBS element | T001 | |
21 | PGSBR | PS_PGSBR | GSBER | CHAR | 4 | 0 | Business area for WBS element | * | |
22 | PKOKR | PS_PKOKR | CACCD | CHAR | 4 | 0 | Controlling area for WBS element | TKA01 | |
23 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
24 | PRART | PS_PRART | PS_PRART | CHAR | 2 | 0 | Project type | * | |
25 | STUFE | PS_STUFE | INT1 | INT1 | 3 | 0 | Level in project hierarchy | ||
26 | PLAKZ | PS_PLAKZ | XFELD | CHAR | 1 | 0 | Indicator: Planning element | ||
27 | BELKZ | PS_BELKZ | XFELD | CHAR | 1 | 0 | Indicator: Account assignment element | ||
28 | FAKKZ | PS_FAKKZ | XFELD | CHAR | 1 | 0 | Indicator: Billing element | ||
29 | NPFAZ | PS_NPFAR | XFELD | CHAR | 1 | 0 | Relationship of network activity to production order | ||
30 | ZUORD | PS_ZUORD | PS_ZUORD | NUMC | 1 | 0 | Network assignment | ||
31 | TRMEQ | PS_TRMEQ | X | CHAR | 1 | 0 | Indicator: WBS dates detailed by activity dates | ||
32 | KVEWE | KVEWE | KVEWE | CHAR | 1 | 0 | Usage of the Condition Table | * | |
33 | KAPPL | KAPPL | KAPPL | CHAR | 2 | 0 | Application | * | |
34 | KALSM | AUFKALSM | KALSM | CHAR | 6 | 0 | Costing Sheet | T683 | |
35 | ZSCHL | AUFZSCHL | CHAR6 | CHAR | 6 | 0 | Overhead key | ||
36 | ABGSL | ABGR_SCHL | ABGR_SCHL | CHAR | 6 | 0 | Results Analysis Key | * | |
37 | AKOKR | PS_AKOKR | CACCD | CHAR | 4 | 0 | Controlling area of requesting cost center | TKA01 | |
38 | AKSTL | PS_AKSTL | KOSTL | CHAR | 10 | 0 | Requesting cost center | CSKS | |
39 | FKOKR | PS_FKOKR | CACCD | CHAR | 4 | 0 | Controlling area of responsible cost center | TKA01 | |
40 | FKSTL | PS_FKSTL | KOSTL | CHAR | 10 | 0 | Responsible cost center | CSKS | |
41 | FABKL | FABKL | WFCID | CHAR | 2 | 0 | Factory calendar key | TFACD | |
42 | PSPRI | NW_PRIO | NW_PRIO | CHAR | 1 | 0 | Priority | * | |
43 | EQUNR | EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | * | |
44 | TPLNR | TPLNR | TPLNR | CHAR | 30 | 0 | Functional Location | * | |
45 | PWPOS | PS_PWPOS | WAERS | CUKY | 5 | 0 | WBS element currency | TCURC | |
46 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
47 | TXTSP | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
48 | SLWID | SLWID | SLWID | CHAR | 7 | 0 | Key word ID for user-defined fields | * | |
49 | USR00 | USR00PRPS | USRCHAR20 | CHAR | 20 | 0 | 1st user field for 20 characters - WBS element- | ||
50 | USR01 | USR01PRPS | USRCHAR20 | CHAR | 20 | 0 | 2nd user field 20 digits - WBS element | ||
51 | USR02 | USR02PRPS | USRCHAR10 | CHAR | 10 | 0 | 3rd user-defined field 10 digits -WBS element | ||
52 | USR03 | USR03PRPS | USRCHAR10 | CHAR | 10 | 0 | 4th user-defined field 10 digits -WBS element | ||
53 | USR04 | USR04PRPS | USRQUAN13 | QUAN | 13 | 3 | 1st user-defined field for quantity(length 10,3) WBS element | ||
54 | USE04 | USE04PRPS | MEINS | UNIT | 3 | 0 | 1st user defined field for quantity field unit - WBS element | T006 | |
55 | USR05 | USR05PRPS | USRQUAN13 | QUAN | 13 | 3 | 2nd use field for quantity (length 10,3) WBS element | ||
56 | USE05 | USE05PRPS | MEINS | UNIT | 3 | 0 | 2nd user defined field for quantity field unit - WBS element | T006 | |
57 | USR06 | USR06PRPS | USRCURR13 | CURR | 13 | 3 | 1st user field for values (length 10,3) WBS element | ||
58 | USE06 | USE06PRPS | WAERS | CUKY | 5 | 0 | 1st user defined field for value field unit - WBS element | TCURC | |
59 | USR07 | USR07PRPS | USRCURR13 | CURR | 13 | 3 | 2nd user field for values (length 10,3) -WBS element | ||
60 | USE07 | USE07PRPS | WAERS | CUKY | 5 | 0 | 2nd user defined field for value field unit - WBS element | TCURC | |
61 | USR08 | USR08PRPS | USRDATE | DATS | 8 | 0 | 1st user field for date -WBS element | ||
62 | USR09 | USR09PRPS | USRDATE | DATS | 8 | 0 | 2nd user field for date -WBS element | ||
63 | USR10 | USR10PRPS | FLAG | CHAR | 1 | 0 | 1st user field for 'Ind. for evaluations' WBS elem. | ||
64 | USR11 | USR11PRPS | FLAG | CHAR | 1 | 0 | 2nd user field for 'Indicator for eval.s' WBS elemnt | ||
65 | KOSTL | PS_KOSTL | KOSTL | CHAR | 10 | 0 | Cost center to which costs are actually posted | CSKS | |
66 | KTRG | KSTRG | KSTRG | CHAR | 12 | 0 | Cost Object | * | |
67 | BERST | PS_BERST | CHAR16 | CHAR | 16 | 0 | Authorization key for project master data | ||
68 | BERTR | PS_BERTR | CHAR16 | CHAR | 16 | 0 | Authorization key for project dates (WBS) | ||
69 | BERKO | PS_BERKO | CHAR16 | CHAR | 16 | 0 | Authorization key for costs and revenues | ||
70 | BERBU | PS_BERBU | CHAR16 | CHAR | 16 | 0 | Authorization key for project budget | ||
71 | CLASF | PS_CLASF | XFELD | CHAR | 1 | 0 | Indicator: WBS element used in project summarization | ||
72 | SPSNR | PS_SPSNR | PS_SPSNR | NUMC | 8 | 0 | Std WBS: Internal project item number (w/exit on ID) | PRPSS | |
73 | SCOPE | SCOPE_CV | SCOPE_CV | CHAR | 2 | 0 | Object Class | ||
74 | XSTAT | PS_XSTAT | XFELD | CHAR | 1 | 0 | Statistical WBS element | ||
75 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
76 | ZSCHM | PS_ZSCHM | PS_ZSCHM | CHAR | 7 | 0 | Interest Profile for Project/Order Interest Calculation | * | |
77 | IMPRF | IM_PROFIL | IM_PROFIL | CHAR | 6 | 0 | Investment measure profile | * | |
78 | EVGEW | EV_WEIGHTD | DEC8 | DEC | 8 | 0 | Aggregation weight for POC (PS progress) | ||
79 | AENNR | AENNR | AENNR | CHAR | 12 | 0 | Change Number | AENR | |
80 | SUBPR | PS_SUBPR | PS_SUBPR | CHAR | 12 | 0 | Sub-project in work breakdown structure | * | |
81 | POSTU | PS_POSTU | CHAR40 | CHAR | 40 | 0 | PS: Short description (1st text line) in all caps | ||
82 | PLINT | PLINT | XFELD | CHAR | 1 | 0 | Indicator for Integrated Planning | ||
83 | LOEVM | LOEVM | XFELD | CHAR | 1 | 0 | Deletion Indicator | ||
84 | KZBWS | KZBWS | KZBWS | CHAR | 1 | 0 | Valuation of Special Stock | ||
85 | FPLNR | FPLNR | FPLNR | CHAR | 10 | 0 | Billing plan number / invoicing plan number | * | |
86 | TADAT | TABGDAT | DATUM | DATS | 8 | 0 | Technically complete date | ||
87 | IZWEK | IZWEK | IZWEK | CHAR | 2 | 0 | Reason for investment | * | |
88 | ISIZE | IM_SIZECL | SIZECL | CHAR | 2 | 0 | Scale of investment objects | * | |
89 | IUMKZ | AM_UMWKZ | AM_UMWKZ | CHAR | 5 | 0 | Reason for environmental investment | * | |
90 | ABUKR | IM_ABUKRS | BUKRS | CHAR | 4 | 0 | Requesting company code | T001 | |
91 | GRPKZ | GRPSPKZ | GRPSPKZ | CHAR | 1 | 0 | Indicator: Grouping WBS element | ||
92 | PGPRF | PGPROFID | PGPROFID | CHAR | 6 | 0 | Distribution profile | * | |
93 | LOGSYSTEM | LOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
94 | STORT | PS_STORT | AP_STAND | CHAR | 10 | 0 | Location | * | |
95 | .INCLUDE | 0 | 0 | PLP: Data Part - Include Production Lot Master Data | |||||
96 | PSPKZ | PL_PSPKZ | XFELD | CHAR | 1 | 0 | Indicator: WBS element for production lot | ||
97 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | ||
98 | VLPSP | PL_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | WBS: Reference work breakdown structure element | * | |
99 | VLPKZ | PL_VLPKZ | XFELD | CHAR | 1 | 0 | Indicator: Reference WBS element for production lot | ||
100 | SORT1 | PL_SORT1 | CHAR10 | CHAR | 10 | 0 | Sort string 1 for production lot | ||
101 | SORT2 | PL_SORT2 | CHAR10 | CHAR | 10 | 0 | Sort string 2 for production lot | ||
102 | SORT3 | PL_SORT3 | CHAR10 | CHAR | 10 | 0 | Sort string 3 for production lot | ||
103 | .INCLUDE | 0 | 0 | JV data: (vname,recid,etype),otype,jibcl,jibsa | |||||
104 | .INCLUDE | 0 | 0 | General assignments of application objects | |||||
105 | VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | * | |
106 | RECID | JV_RECIND | JV_RECIND | CHAR | 2 | 0 | Recovery Indicator | * | |
107 | ETYPE | JV_ETYPE | JV_ETYPE | CHAR | 3 | 0 | Equity type | * | |
108 | OTYPE | JV_OTYPE | JV_OTYPE | CHAR | 4 | 0 | Joint Venture Object Type | ||
109 | JIBCL | JV_JIBCL | JV_JIBCL | CHAR | 3 | 0 | JIB/JIBE Class | * | |
110 | JIBSA | JV_JIBSA | JV_JIBSA | CHAR | 5 | 0 | JIB/JIBE Subclass A | * | |
111 | .INCLUDE | 0 | 0 | ||||||
112 | .INCLUDE | 0 | 0 | Versions include Proj. | |||||
113 | ORGKEY | PS_INTNR | PS_PSPNR | NUMC | 8 | 0 | Current number for project or project item | * | |
114 | INCAT | VSINACT | XFELD | CHAR | 1 | 0 | Version inactive indicator |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VSPRPS_CN | ABUKR | T001 | BUKRS | 1 | CN | |
2 | VSPRPS_CN | AENNR | AENR | AENNR | REF | C | CN |
3 | VSPRPS_CN | AKOKR | TKA01 | KOKRS | |||
4 | VSPRPS_CN | AKSTL | CSKS | KOSTL | |||
5 | VSPRPS_CN | FABKL | TFACD | IDENT | |||
6 | VSPRPS_CN | FKOKR | TKA01 | KOKRS | |||
7 | VSPRPS_CN | FKSTL | CSKS | KOSTL | |||
8 | VSPRPS_CN | KALSM | T683 | KALSM | |||
9 | VSPRPS_CN | KOSTL | CSKS | KOSTL | |||
10 | VSPRPS_CN | MANDT | T000 | MANDT | KEY | 1 | CN |
11 | VSPRPS_CN | OBJNR | ONR00 | OBJNR | REF | C | C |
12 | VSPRPS_CN | PBUKR | T001 | BUKRS | |||
13 | VSPRPS_CN | PKOKR | TKA01 | KOKRS | |||
14 | VSPRPS_CN | PSPHI | VSPROJ_CN | VSNMR | REF | 1 | CN |
15 | VSPRPS_CN | PWPOS | TCURC | WAERS | |||
16 | VSPRPS_CN | SPSNR | PRPSS | PSPNR | |||
17 | VSPRPS_CN | TXTSP | T002 | SPRAS | |||
18 | VSPRPS_CN | USE04 | T006 | MSEHI | |||
19 | VSPRPS_CN | USE05 | T006 | MSEHI | |||
20 | VSPRPS_CN | USE06 | TCURC | WAERS | |||
21 | VSPRPS_CN | USE07 | TCURC | WAERS | |||
22 | VSPRPS_CN | WERKS | T001W | WERKS |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |