SAP ABAP Table VSPROJB (Versions: Doc. table structure for VSPROJ_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	VSPROJB	Table Relationship Diagram
Short Description	Versions: Doc. table structure for VSPROJ_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: Project definition
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_INTNR	PS_PSPNR	NUMC	8	0	Current number for project or project item	*
6	.INCLUDE	☐				0	0	PS: Data portion of project definition Include
7	PSPID	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
8	.INCLUDE	☐				0	0	PS: Data portion of project definition include
9	POST1	☐	PS_POST1	TEXT40	CHAR	40	0	PS: Short description (first text line)
10	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
11	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
12	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
13	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
14	AEDAT	☐	UPDAT	DATUM	DATS	8	0	Date on which object was last changed
15	KIMSK	☐	PS_KIMSK	PS_PROID	CHAR	24	0	Selection mask for WBS element short IDs
16	AUTOD	☐	PS_AUTOD	XFELD	CHAR	1	0	Automatic value transfer from WBS element to project def.
17	STSPD	☐	PS_STSPD	J_STSMA	CHAR	8	0	Status profile for project definition	TJ20
18	STSPR	☐	PS_STSPR	J_STSMA	CHAR	8	0	Status profile for WBS element	TJ20
19	VERNR	☐	PS_VERNR	PS_VERNR	NUMC	8	0	Number of the responsible person (project manager)	TCJ04
20	VERNA	☐	PS_VERNA	PS_VERNA	CHAR	25	0	Name of responsible person (Project manager)
21	ASTNR	☐	PS_ASTNR	PS_ASTNR	NUMC	8	0	Applicant number	TCJ05
22	ASTNA	☐	PS_ASTNA	PS_ASTNA	CHAR	25	0	Applicant
23	VBUKR	☐	PS_VBUKR	BUKRS	CHAR	4	0	Company code for the project	T001
24	VGSBR	☐	PS_VGSBR	GSBER	CHAR	4	0	Business area for the project	TGSB
25	VKOKR	☐	PS_VKOKR	CACCD	CHAR	4	0	Controlling area for the project	TKA01
26	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
27	PWHIE	☐	PS_PWHIE	WAERS	CUKY	5	0	WBS currency (project definition)	TCURC
28	ZUORD	☐	PS_ZUORD	PS_ZUORD	NUMC	1	0	Network assignment
29	TRMEQ	☐	PS_TRMEQ	X	CHAR	1	0	Indicator: WBS dates detailed by activity dates
30	PLFAZ	☐	PS_PLFAZ	DATUM	DATS	8	0	Project planned start date
31	PLSEZ	☐	PS_PLSEZ	DATUM	DATS	8	0	Project planned finish date
32	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
33	KALID	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
34	VGPLF	☐	PS_VGPLF	PSPLFRM	NUMC	1	0	Planning method for project basic dates
35	EWPLF	☐	PS_EWPLF	PSPLFRM	NUMC	1	0	Planning method for project forecast dates
36	ZTEHT	☐	PS_ZTEHT	MEINS	UNIT	3	0	Time unit in time scheduling	T006
37	NZANZ	☐	NETZOBERFL	X	CHAR	1	0	Indicator: Network header visible to end user
38	PLNAW	☐	PLNAW	PLNAW	CHAR	1	0	Application of the task list	TCA09
39	VPROF	☐	PROFIDNZPL	PROFILID	CHAR	7	0	Network profile	TCN41
40	PROFL	☐	PROFIDPROJ	PROFIDPROJ	CHAR	7	0	Project profile	TCJ41
41	BPROF	☐	BP_BPROFIL	BP_PROFIL	CHAR	6	0	Budget Profile	TBP1C
42	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
43	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
44	KTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
45	AEDTE	☐	PS_AEDTE	DATUM	DATS	8	0	Date of last scheduling of the overall network (basic dates)
46	AEDTP	☐	PS_AEDTP	DATUM	DATS	8	0	Date of last scheduling of the overall network (forecast)
47	BERST	☐	PS_BERST	CHAR16	CHAR	16	0	Authorization key for project master data
48	BERTR	☐	PS_BERTR	CHAR16	CHAR	16	0	Authorization key for project dates (WBS)
49	BERKO	☐	PS_BERKO	CHAR16	CHAR	16	0	Authorization key for costs and revenues
50	BERBU	☐	PS_BERBU	CHAR16	CHAR	16	0	Authorization key for project budget
51	SPSNR	☐	PS_ISPSP	PS_ISPSP	NUMC	8	0	Current number for standard project	PROJS
52	BESTA	☐	PS_BESTAND	XFELD	CHAR	1	0	Project stock
53	SCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
54	XSTAT	☐	PS_XSTAT	XFELD	CHAR	1	0	Statistical WBS element
55	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
56	ZSCHM	☐	PS_ZSCHM	PS_ZSCHM	CHAR	7	0	Interest Profile for Project/Order Interest Calculation	TPI01
57	SCPRF	☐	PS_SCHDPRF	PS_SCHDPRF	CHAR	12	0	Profile for WBS scheduling	TCXPS
58	IMPRF	☐	IM_PROFIL	IM_PROFIL	CHAR	6	0	Investment measure profile	TAPRF
59	FMPRF	☐	PSFM_PRF	BP_PROFIL	CHAR	6	0	Payment plan profile	TBP1C
60	ABGSL	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
61	POSTU	☐	PS_POSTU	CHAR40	CHAR	40	0	PS: Short description (1st text line) in all caps
62	PPROF	☐	BP_PPROFIL	BP_PROFIL	CHAR	6	0	Planning profile	TBP1C
63	PLINT	☐	PLINT	XFELD	CHAR	1	0	Indicator for Integrated Planning
64	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
65	INACT	☐	PS_INACT	XFELD	CHAR	1	0	Indicator: Project definition inactive
66	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
67	SMPRF	☐	SIM_PROFIL	SIM_PROFIL	CHAR	7	0	Simulation profile	TCN54
68	FLGVRG	☐	PS_FLGVRG	PS_FLGVRG	CHAR	1	0	Indicator: Bottom-up calculation with activity dates
69	GRTOP	☐	GRONTOP	XFELD	CHAR	1	0	Indicator: Automatic requirements grouping
70	PGPRF	☐	PGPROFID	PGPROFID	CHAR	6	0	Distribution profile	TPGPRF
71	STORT	☐	PS_STORT	AP_STAND	CHAR	10	0	Location	T499S
72	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
73	KZERB	☐	PS_KZERB	XFELD	CHAR	1	0	Indicator: Project summarization
74	PARGR	☐	PARGR	PARGR	CHAR	4	0	Partner Determination Procedure	V_TVPG_S
75	FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
76	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
77	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
78	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
79	DPPPROF	☐	AD01PROFNR	AD01PROFNR	CHAR	8	0	Dynamic Item Processor Profile	AD01C_PROF
80	VPKSTU	☐	SEU_LEVEL	SEU_LEVEL	NUMC	2	0	Node level
81	PSPID_EDIT	☐	PS_PSPID_EDIT	PS_PSPID_EDIT	CHAR	24	0	Project Number (External) Edited
82	.INCLUDE	☐				0	0	JV data: (vname,recid,etype),otype,jibcl,jibsa
83	.INCLUDE	☐				0	0	General assignments of application objects
84	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
85	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
86	ETYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	T8JE
87	OTYPE	☐	JV_OTYPE	JV_OTYPE	CHAR	4	0	Joint Venture Object Type
88	JIBCL	☐	JV_JIBCL	JV_JIBCL	CHAR	3	0	JIB/JIBE Class	T8J6A
89	JIBSA	☐	JV_JIBSA	JV_JIBSA	CHAR	5	0	JIB/JIBE Subclass A	T8J6C
90	.INCLUDE	☐				0	0
91	SCHTYP	☐	PS_SCHED_TYPE	PS_SCHED_TYPE	CHAR	1	0	Scheduling scenario
92	SPROG	☐	PS_SPROG	DATE	DATS	8	0	Forecast start date of project definition
93	EPROG	☐	PS_EPROG	DATE	DATS	8	0	Forecast finish date for project definition
94	.INCLUDE	☐				0	0	Versions include Proj.
95	ORGKEY	☐	PS_INTNR	PS_PSPNR	NUMC	8	0	Current number for project or project item	*
96	INCAT	☐	VSINACT	XFELD	CHAR	1	0	Version inactive indicator
97	.INCLUDE	☐				0	0	Structure for project leading status
98	PROJ_STATUS	☐	ACTCMB_DELE	ACTCMB_DOM	INT1	3	0	Status Combination	ACTCMB_TAB
99	.INCLU--AP	☐				0	0	Append structure for Regulatory Reporting
100	FERC_IND	☐	FE_IND	FE_IND	CHAR	4	0	Regulatory indicator	FERC_C7
101	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	VSPROJB	ABGSL	TKKAA	ABGSL	REF	C	CN
2	VSPROJB	ASTNR	TCJ05	ASTNR
3	VSPROJB	BPROF	TBP1C	PROFIL
4	VSPROJB	DPPPROF	AD01C_PROF	PROFNR
5	VSPROJB	ETYPE	T8JE	ETYPE
6	VSPROJB	FERC_IND	FERC_C7	IND	REF
7	VSPROJB	FMPRF	TBP1C	PROFIL	REF	C	CN
8	VSPROJB	FUNC_AREA	TFKB	FKBER
9	VSPROJB	IMPRF	TAPRF	IVPRO		C	CN
10	VSPROJB	JIBCL	T8J6A	CLASS
11	VSPROJB	JIBSA	T8J6C	SUBCLASS
12	VSPROJB	KALID	TFACD	IDENT
13	VSPROJB	KOSTL	CSKS	KOSTL
14	VSPROJB	KTRG	CKPH	KSTRG
15	VSPROJB	MANDT	T000	MANDT	KEY	1	CN
16	VSPROJB	OBJNR	ONR00	OBJNR	REF	C	C
17	VSPROJB	PARGR	V_TVPG_S	PARGR	REF	C	CN
18	VSPROJB	PGPRF	TPGPRF	PROFID		1	CN
19	VSPROJB	PLNAW	TCA09	PLNAW
20	VSPROJB	PPROF	TBP1C	PROFIL	REF	C	CN
21	VSPROJB	PRCTR	CEPC	PRCTR
22	VSPROJB	PROFL	TCJ41	PROFIDPROJ
23	VSPROJB	PROJ_STATUS	ACTCMB_TAB	ACTCMB
24	VSPROJB	PWHIE	TCURC	WAERS
25	VSPROJB	RECID	T8JJ	RECID
26	VSPROJB	SCPRF	TCXPS	PROFIL	REF	C	CN
27	VSPROJB	SMPRF	TCN54	VER_PROFIL		1	CN
28	VSPROJB	SPART	TVTA	SPART
29	VSPROJB	SPSNR	PROJS	PSPNR
30	VSPROJB	STORT	T499S	STAND
31	VSPROJB	STSPD	TJ20	STSMA
32	VSPROJB	STSPR	TJ20	STSMA
33	VSPROJB	TXJCD	TTXJ	TXJCD
34	VSPROJB	TXTSP	T002	SPRAS
35	VSPROJB	VBUKR	T001	BUKRS
36	VSPROJB	VERNR	TCJ04	VERNR
37	VSPROJB	VGSBR	TGSB	GSBER
38	VSPROJB	VKOKR	TKA01	KOKRS
39	VSPROJB	VKORG	TVKO	VKORG
40	VSPROJB	VNAME	T8JV	VNAME
41	VSPROJB	VPROF	TCN41	PROFIDNETZ
42	VSPROJB	VTWEG	TVKOV	VTWEG
43	VSPROJB	WERKS	T001W	WERKS
44	VSPROJB	ZSCHM	TPI01	ZSCHM
45	VSPROJB	ZTEHT	T006	MSEHI

History

Last changed by/on	SAP	20130529
SAP Release Created in