SAP ABAP Table VSPRPSB (Versions: Doc. table structure for VSPRPS_CN)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ CNVS (Package) R/3 Application development: Version Management

Basic Data

Table Category	INTTAB	Structure
Structure	VSPRPSB	Table Relationship Diagram
Short Description	Versions: Doc. table structure for VSPRPS_CN

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Version: WBS element master data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	.INCLUDE	☐				0	0	Version: PS version, version-related key fields
4	VSNMR	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
5	PSPNR	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
6	.INCLUDE	☐				0	0	PS: Data portion of WBS element master data Include
7	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
8	POST1	☐	PS_POST1	TEXT40	CHAR	40	0	PS: Short description (first text line)
9	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
10	PSPHI	☐	PS_PSPHI	PS_PSPNR	NUMC	8	0	Current number of the appropriate project	VSPROJ_CN
11	.INCLUDE	☐				0	0	PS: Data portion of WBS element master data Include
12	POSKI	☐	PS_POSKI	PS_PROKI	CHAR	16	0	WBS element short identification
13	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
14	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
15	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
16	AEDAT	☐	UPDAT	DATUM	DATS	8	0	Date on which object was last changed
17	VERNR	☐	PS_VERNR	PS_VERNR	NUMC	8	0	Number of the responsible person (project manager)	TCJ04
18	VERNA	☐	PS_VERNA	PS_VERNA	CHAR	25	0	Name of responsible person (Project manager)
19	ASTNR	☐	PS_ASTNR	PS_ASTNR	NUMC	8	0	Applicant number	TCJ05
20	ASTNA	☐	PS_ASTNA	PS_ASTNA	CHAR	25	0	Applicant
21	PBUKR	☐	PS_PBUKR	BUKRS	CHAR	4	0	Company code for WBS element	T001
22	PGSBR	☐	PS_PGSBR	GSBER	CHAR	4	0	Business area for WBS element	TGSB
23	PKOKR	☐	PS_PKOKR	CACCD	CHAR	4	0	Controlling area for WBS element	TKA01
24	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
25	PRART	☐	PS_PRART	PS_PRART	CHAR	2	0	Project type	TCJ1
26	STUFE	☐	PS_STUFE	INT1	INT1	3	0	Level in project hierarchy
27	PLAKZ	☐	PS_PLAKZ	XFELD	CHAR	1	0	Indicator: Planning element
28	BELKZ	☐	PS_BELKZ	XFELD	CHAR	1	0	Indicator: Account assignment element
29	FAKKZ	☐	PS_FAKKZ	XFELD	CHAR	1	0	Indicator: Billing element
30	NPFAZ	☐	PS_NPFAR	XFELD	CHAR	1	0	Relationship of network activity to production order
31	ZUORD	☐	PS_ZUORD	PS_ZUORD	NUMC	1	0	Network assignment
32	TRMEQ	☐	PS_TRMEQ	X	CHAR	1	0	Indicator: WBS dates detailed by activity dates
33	KVEWE	☐	KVEWE	KVEWE	CHAR	1	0	Usage of the Condition Table	T681V
34	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
35	KALSM	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	T683
36	ZSCHL	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
37	ABGSL	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
38	AKOKR	☐	PS_AKOKR	CACCD	CHAR	4	0	Controlling area of requesting cost center	TKA01
39	AKSTL	☐	PS_AKSTL	KOSTL	CHAR	10	0	Requesting cost center	CSKS
40	FKOKR	☐	PS_FKOKR	CACCD	CHAR	4	0	Controlling area of responsible cost center	TKA01
41	FKSTL	☐	PS_FKSTL	KOSTL	CHAR	10	0	Responsible cost center	CSKS
42	FABKL	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
43	PSPRI	☐	NW_PRIO	NW_PRIO	CHAR	1	0	Priority	TCN07
44	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
45	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
46	PWPOS	☐	PS_PWPOS	WAERS	CUKY	5	0	WBS element currency	TCURC
47	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
48	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
49	SLWID	☐	SLWID	SLWID	CHAR	7	0	Key word ID for user-defined fields	TCN00
50	USR00	☐	USR00PRPS	USRCHAR20	CHAR	20	0	1st user field for 20 characters - WBS element-
51	USR01	☐	USR01PRPS	USRCHAR20	CHAR	20	0	2nd user field 20 digits - WBS element
52	USR02	☐	USR02PRPS	USRCHAR10	CHAR	10	0	3rd user-defined field 10 digits -WBS element
53	USR03	☐	USR03PRPS	USRCHAR10	CHAR	10	0	4th user-defined field 10 digits -WBS element
54	USR04	☐	USR04PRPS	USRQUAN13	QUAN	13	3	1st user-defined field for quantity(length 10,3) WBS element
55	USE04	☐	USE04PRPS	MEINS	UNIT	3	0	1st user defined field for quantity field unit - WBS element	T006
56	USR05	☐	USR05PRPS	USRQUAN13	QUAN	13	3	2nd use field for quantity (length 10,3) WBS element
57	USE05	☐	USE05PRPS	MEINS	UNIT	3	0	2nd user defined field for quantity field unit - WBS element	T006
58	USR06	☐	USR06PRPS	USRCURR13	CURR	13	3	1st user field for values (length 10,3) WBS element
59	USE06	☐	USE06PRPS	WAERS	CUKY	5	0	1st user defined field for value field unit - WBS element	TCURC
60	USR07	☐	USR07PRPS	USRCURR13	CURR	13	3	2nd user field for values (length 10,3) -WBS element
61	USE07	☐	USE07PRPS	WAERS	CUKY	5	0	2nd user defined field for value field unit - WBS element	TCURC
62	USR08	☐	USR08PRPS	USRDATE	DATS	8	0	1st user field for date -WBS element
63	USR09	☐	USR09PRPS	USRDATE	DATS	8	0	2nd user field for date -WBS element
64	USR10	☐	USR10PRPS	FLAG	CHAR	1	0	1st user field for 'Ind. for evaluations' WBS elem.
65	USR11	☐	USR11PRPS	FLAG	CHAR	1	0	2nd user field for 'Indicator for eval.s' WBS elemnt
66	KOSTL	☐	PS_KOSTL	KOSTL	CHAR	10	0	Cost center to which costs are actually posted	CSKS
67	KTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
68	BERST	☐	PS_BERST	CHAR16	CHAR	16	0	Authorization key for project master data
69	BERTR	☐	PS_BERTR	CHAR16	CHAR	16	0	Authorization key for project dates (WBS)
70	BERKO	☐	PS_BERKO	CHAR16	CHAR	16	0	Authorization key for costs and revenues
71	BERBU	☐	PS_BERBU	CHAR16	CHAR	16	0	Authorization key for project budget
72	CLASF	☐	PS_CLASF	XFELD	CHAR	1	0	Indicator: WBS element used in project summarization
73	SPSNR	☐	PS_SPSNR	PS_SPSNR	NUMC	8	0	Std WBS: Internal project item number (w/exit on ID)	PRPSS
74	SCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
75	XSTAT	☐	PS_XSTAT	XFELD	CHAR	1	0	Statistical WBS element
76	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
77	ZSCHM	☐	PS_ZSCHM	PS_ZSCHM	CHAR	7	0	Interest Profile for Project/Order Interest Calculation	TPI01
78	IMPRF	☐	IM_PROFIL	IM_PROFIL	CHAR	6	0	Investment measure profile	TAPRF
79	EVGEW	☐	EV_WEIGHTD	DEC8	DEC	8	0	Aggregation weight for POC (PS progress)
80	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
81	SUBPR	☐	PS_SUBPR	PS_SUBPR	CHAR	12	0	Sub-project in work breakdown structure	PRTP
82	POSTU	☐	PS_POSTU	CHAR40	CHAR	40	0	PS: Short description (1st text line) in all caps
83	PLINT	☐	PLINT	XFELD	CHAR	1	0	Indicator for Integrated Planning
84	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
85	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
86	FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	*
87	TADAT	☐	TABGDAT	DATUM	DATS	8	0	Technically complete date
88	IZWEK	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
89	ISIZE	☐	IM_SIZECL	SIZECL	CHAR	2	0	Scale of investment objects	TAIF5
90	IUMKZ	☐	AM_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	T087K
91	ABUKR	☐	IM_ABUKRS	BUKRS	CHAR	4	0	Requesting company code	T001
92	GRPKZ	☐	GRPSPKZ	GRPSPKZ	CHAR	1	0	Indicator: Grouping WBS element
93	PGPRF	☐	PGPROFID	PGPROFID	CHAR	6	0	Distribution profile	TPGPRF
94	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
95	PSPNR_LOGS	☐	NUM08	NUM08	NUMC	8	0	Numeric field length 8
96	STORT	☐	PS_STORT	AP_STAND	CHAR	10	0	Location	T499S
97	FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
98	KLVAR	☐	CK_KLVAR	KLVAR	CHAR	4	0	Costing Variant	*
99	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
100	POSID_EDIT	☐	PS_POSID_EDIT	PS_POSID_EDIT	CHAR	24	0	Work Breakdown Structure Element (WBS Element) Edited
101	.INCLUDE	☐				0	0	PLP: Data Part - Include Production Lot Master Data
102	PSPKZ	☐	PL_PSPKZ	XFELD	CHAR	1	0	Indicator: WBS element for production lot
103	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
104	VLPSP	☐	PL_PSP_PNR	PS_POSNR	NUMC	8	0	WBS: Reference work breakdown structure element	*
105	VLPKZ	☐	PL_VLPKZ	XFELD	CHAR	1	0	Indicator: Reference WBS element for production lot
106	SORT1	☐	PL_SORT1	CHAR10	CHAR	10	0	Sort string 1 for production lot
107	SORT2	☐	PL_SORT2	CHAR10	CHAR	10	0	Sort string 2 for production lot
108	SORT3	☐	PL_SORT3	CHAR10	CHAR	10	0	Sort string 3 for production lot
109	.INCLUDE	☐				0	0	JV data: (vname,recid,etype),otype,jibcl,jibsa
110	.INCLUDE	☐				0	0	General assignments of application objects
111	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
112	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
113	ETYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	T8JE
114	OTYPE	☐	JV_OTYPE	JV_OTYPE	CHAR	4	0	Joint Venture Object Type
115	JIBCL	☐	JV_JIBCL	JV_JIBCL	CHAR	3	0	JIB/JIBE Class	T8J6A
116	JIBSA	☐	JV_JIBSA	JV_JIBSA	CHAR	5	0	JIB/JIBE Subclass A	T8J6C
117	.INCLUDE	☐				0	0	Generic Project Planning: Assignment to WBS Element
118	CGPL_GUID16	☐	CGPL_GUID16_R3	SYSUUID	RAW	16	0	Generic project planning: GUID from external R/3 system
119	CGPL_LOGSYS	☐	CGPL_LOGSYS	LOGSYS	CHAR	10	0	Generic project planning: Log. system for CGPL_GUID16_R3	*
120	CGPL_OBJTYPE	☐	CGPL_OBJECT_TYPE_R3	CHAR3	CHAR	3	0	Generic project planning: object type from ext. R/3 system
121	ADPSP	☐	ADDCOMPARE_CORE	ADDCOMPARE_CORE	CHAR	40	0	Reference Element PM/PS	*
122	RFIPPNT	☐	CN_RPIP	CN_RFPNT	CHAR	20	0	Reference Point for Relationship Between iPPE and PS	TCNRPIP
123	.INCLUDE	☐				0	0
124	.INCLUDE	☐				0	0	Versions include Proj.
125	ORGKEY	☐	PS_INTNR	PS_PSPNR	NUMC	8	0	Current number for project or project item	*
126	INCAT	☐	VSINACT	XFELD	CHAR	1	0	Version inactive indicator
127	.INCLUDE	☐				0	0	Structure for WBS leading status
128	PRPS_STATUS	☐	ACTCMB_DELE	ACTCMB_DOM	INT1	3	0	Status Combination	ACTCMB_TAB
129	.INCLU--AP	☐				0	0	Append structure for Regulatory Reporting
130	FERC_IND	☐	FE_IND	FE_IND	CHAR	4	0	Regulatory indicator	FERC_C7
131	VBUKZ	☐	VBKZ	VERBUCHER	CHAR	1	0	Update indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VSPRPSB	ABGSL	TKKAA	ABGSL
2	VSPRPSB	ABUKR	T001	BUKRS		1	CN
3	VSPRPSB	AENNR	AENR	AENNR	REF	C	CN
4	VSPRPSB	AKOKR	TKA01	KOKRS
5	VSPRPSB	AKSTL	CSKS	KOSTL
6	VSPRPSB	ASTNR	TCJ05	ASTNR
7	VSPRPSB	EQUNR	EQUI	EQUNR
8	VSPRPSB	ETYPE	T8JE	ETYPE
9	VSPRPSB	FABKL	TFACD	IDENT
10	VSPRPSB	FERC_IND	FERC_C7	IND	REF
11	VSPRPSB	FKOKR	TKA01	KOKRS
12	VSPRPSB	FKSTL	CSKS	KOSTL
13	VSPRPSB	FUNC_AREA	TFKB	FKBER
14	VSPRPSB	IMPRF	TAPRF	IVPRO
15	VSPRPSB	ISIZE	TAIF5	SIZECL		1	CN
16	VSPRPSB	IUMKZ	T087K	UMWKZ		1	CN
17	VSPRPSB	IZWEK	T087I	IZWEK		1	CN
18	VSPRPSB	JIBCL	T8J6A	CLASS
19	VSPRPSB	JIBSA	T8J6C	SUBCLASS
20	VSPRPSB	KALSM	T683	KALSM
21	VSPRPSB	KAPPL	T681A	KAPPL
22	VSPRPSB	KOSTL	CSKS	KOSTL
23	VSPRPSB	KTRG	CKPH	KSTRG
24	VSPRPSB	KVEWE	T681V	KVEWE
25	VSPRPSB	MANDT	T000	MANDT	KEY	1	CN
26	VSPRPSB	OBJNR	ONR00	OBJNR	REF	C	C
27	VSPRPSB	PBUKR	T001	BUKRS
28	VSPRPSB	PGPRF	TPGPRF	PROFID		1	CN
29	VSPRPSB	PGSBR	TGSB	GSBER
30	VSPRPSB	PKOKR	TKA01	KOKRS
31	VSPRPSB	PRART	TCJ1	PRART
32	VSPRPSB	PRCTR	CEPC	PRCTR
33	VSPRPSB	PRPS_STATUS	ACTCMB_TAB	ACTCMB
34	VSPRPSB	PSPHI	VSPROJ_CN	VSNMR	REF	1	CN
35	VSPRPSB	PSPRI	TCN07	NPRIO	REF	C	CN
36	VSPRPSB	PWPOS	TCURC	WAERS
37	VSPRPSB	RECID	T8JJ	RECID
38	VSPRPSB	RFIPPNT	TCNRPIP	RFPNT		C	CN
39	VSPRPSB	SLWID	TCN00	SLWID
40	VSPRPSB	SPSNR	PRPSS	PSPNR
41	VSPRPSB	STORT	T499S	STAND
42	VSPRPSB	SUBPR	PRTP	SUBPR	REF	C	CN
43	VSPRPSB	TPLNR	IFLOT	TPLNR
44	VSPRPSB	TXJCD	TTXJ	TXJCD
45	VSPRPSB	TXTSP	T002	SPRAS
46	VSPRPSB	USE04	T006	MSEHI
47	VSPRPSB	USE05	T006	MSEHI
48	VSPRPSB	USE06	TCURC	WAERS
49	VSPRPSB	USE07	TCURC	WAERS
50	VSPRPSB	VERNR	TCJ04	VERNR
51	VSPRPSB	VNAME	T8JV	VNAME
52	VSPRPSB	WERKS	T001W	WERKS
53	VSPRPSB	ZSCHM	TPI01	ZSCHM

History

Last changed by/on	SAP	20130529
SAP Release Created in