SAP ABAP Table VSPROJ_CN (Version: Project definition)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VSPROJ_CN	Table Relationship Diagram
Short Description	Version: Project definition

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_INTNR	PS_PSPNR	NUMC	8	0	Current number for project or project item	*
5	.INCLUDE	☐				0	0	PS: Data portion of project definition Include
6	PSPID	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
7	.INCLUDE	☐				0	0	PS: Data portion of project definition include
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	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
11	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
12	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
13	AEDAT	☐	UPDAT	DATUM	DATS	8	0	Date on which object was last changed
14	KIMSK	☐	PS_KIMSK	PS_PROID	CHAR	24	0	Selection mask for WBS element short IDs
15	AUTOD	☐	PS_AUTOD	XFELD	CHAR	1	0	Automatic value transfer from WBS element to project def.
16	STSPD	☐	PS_STSPD	J_STSMA	CHAR	8	0	Status profile for project definition	TJ20
17	STSPR	☐	PS_STSPR	J_STSMA	CHAR	8	0	Status profile for WBS element	TJ20
18	VERNR	☐	PS_VERNR	PS_VERNR	NUMC	8	0	Number of the responsible person (project manager)	*
19	VERNA	☐	PS_VERNA	PS_VERNA	CHAR	25	0	Name of responsible person (Project manager)
20	ASTNR	☐	PS_ASTNR	PS_ASTNR	NUMC	8	0	Applicant number	*
21	ASTNA	☐	PS_ASTNA	PS_ASTNA	CHAR	25	0	Applicant
22	VBUKR	☐	PS_VBUKR	BUKRS	CHAR	4	0	Company code for the project	T001
23	VGSBR	☐	PS_VGSBR	GSBER	CHAR	4	0	Business area for the project	*
24	VKOKR	☐	PS_VKOKR	CACCD	CHAR	4	0	Controlling area for the project	TKA01
25	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
26	PWHIE	☐	PS_PWHIE	WAERS	CUKY	5	0	WBS currency (project definition)	TCURC
27	ZUORD	☐	PS_ZUORD	PS_ZUORD	NUMC	1	0	Network assignment
28	TRMEQ	☐	PS_TRMEQ	X	CHAR	1	0	Indicator: WBS dates detailed by activity dates
29	PLFAZ	☐	PS_PLFAZ	DATUM	DATS	8	0	Project planned start date
30	PLSEZ	☐	PS_PLSEZ	DATUM	DATS	8	0	Project planned finish date
31	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
32	KALID	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
33	VGPLF	☐	PS_VGPLF	PSPLFRM	NUMC	1	0	Planning method for project basic dates
34	EWPLF	☐	PS_EWPLF	PSPLFRM	NUMC	1	0	Planning method for project forecast dates
35	ZTEHT	☐	PS_ZTEHT	MEINS	UNIT	3	0	Time unit in time scheduling	T006
36	NZANZ	☐	NETZOBERFL	X	CHAR	1	0	Indicator: Network header visible to end user
37	PLNAW	☐	PLNAW	PLNAW	CHAR	1	0	Application of the task list	*
38	VPROF	☐	PROFIDNZPL	PROFILID	CHAR	7	0	Network profile	*
39	PROFL	☐	PROFIDPROJ	PROFIDPROJ	CHAR	7	0	Project profile	*
40	BPROF	☐	BP_BPROFIL	BP_PROFIL	CHAR	6	0	Budget Profile	*
41	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
42	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
43	KTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
44	AEDTE	☐	PS_AEDTE	DATUM	DATS	8	0	Date of last scheduling of the overall network (basic dates)
45	AEDTP	☐	PS_AEDTP	DATUM	DATS	8	0	Date of last scheduling of the overall network (forecast)
46	BERST	☐	PS_BERST	CHAR16	CHAR	16	0	Authorization key for project master data
47	BERTR	☐	PS_BERTR	CHAR16	CHAR	16	0	Authorization key for project dates (WBS)
48	BERKO	☐	PS_BERKO	CHAR16	CHAR	16	0	Authorization key for costs and revenues
49	BERBU	☐	PS_BERBU	CHAR16	CHAR	16	0	Authorization key for project budget
50	SPSNR	☐	PS_ISPSP	PS_ISPSP	NUMC	8	0	Current number for standard project	PROJS
51	BESTA	☐	PS_BESTAND	XFELD	CHAR	1	0	Project stock
52	SCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
53	XSTAT	☐	PS_XSTAT	XFELD	CHAR	1	0	Statistical WBS element
54	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
55	ZSCHM	☐	PS_ZSCHM	PS_ZSCHM	CHAR	7	0	Interest Profile for Project/Order Interest Calculation	*
56	SCPRF	☐	PS_SCHDPRF	PS_SCHDPRF	CHAR	12	0	Profile for WBS scheduling	*
57	IMPRF	☐	IM_PROFIL	IM_PROFIL	CHAR	6	0	Investment measure profile	*
58	FMPRF	☐	PSFM_PRF	BP_PROFIL	CHAR	6	0	Payment plan profile	*
59	ABGSL	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	*
60	POSTU	☐	PS_POSTU	CHAR40	CHAR	40	0	PS: Short description (1st text line) in all caps
61	PPROF	☐	BP_PPROFIL	BP_PROFIL	CHAR	6	0	Planning profile	*
62	PLINT	☐	PLINT	XFELD	CHAR	1	0	Indicator for Integrated Planning
63	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
64	INACT	☐	PS_INACT	XFELD	CHAR	1	0	Indicator: Project definition inactive
65	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
66	SMPRF	☐	SIM_PROFIL	SIM_PROFIL	CHAR	7	0	Simulation profile	*
67	FLGVRG	☐	PS_FLGVRG	PS_FLGVRG	CHAR	1	0	Indicator: Bottom-up calculation with activity dates
68	GRTOP	☐	GRONTOP	XFELD	CHAR	1	0	Indicator: Automatic requirements grouping
69	PGPRF	☐	PGPROFID	PGPROFID	CHAR	6	0	Distribution profile	*
70	STORT	☐	PS_STORT	AP_STAND	CHAR	10	0	Location	*
71	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
72	KZERB	☐	PS_KZERB	XFELD	CHAR	1	0	Indicator: Project summarization
73	.INCLUDE	☐				0	0	JV data: (vname,recid,etype),otype,jibcl,jibsa
74	.INCLUDE	☐				0	0	General assignments of application objects
75	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
76	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	*
77	ETYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	*
78	OTYPE	☐	JV_OTYPE	JV_OTYPE	CHAR	4	0	Joint Venture Object Type
79	JIBCL	☐	JV_JIBCL	JV_JIBCL	CHAR	3	0	JIB/JIBE Class	*
80	JIBSA	☐	JV_JIBSA	JV_JIBSA	CHAR	5	0	JIB/JIBE Subclass A	*
81	.INCLUDE	☐				0	0
82	.INCLUDE	☐				0	0	Versions include Proj.
83	ORGKEY	☐	PS_INTNR	PS_PSPNR	NUMC	8	0	Current number for project or project item	*
84	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	VSPROJ_CN	KALID	TFACD	IDENT
2	VSPROJ_CN	KOSTL	CSKS	KOSTL
3	VSPROJ_CN	MANDT	T000	MANDT	KEY	1	CN
4	VSPROJ_CN	OBJNR	ONR00	OBJNR	REF	C	C
5	VSPROJ_CN	PWHIE	TCURC	WAERS
6	VSPROJ_CN	SPSNR	PROJS	PSPNR
7	VSPROJ_CN	STSPD	TJ20	STSMA
8	VSPROJ_CN	STSPR	TJ20	STSMA
9	VSPROJ_CN	TXTSP	T002	SPRAS
10	VSPROJ_CN	VBUKR	T001	BUKRS
11	VSPROJ_CN	VKOKR	TKA01	KOKRS
12	VSPROJ_CN	WERKS	T001W	WERKS
13	VSPROJ_CN	ZTEHT	T006	MSEHI

History

Last changed by/on	SAP	20130604
SAP Release Created in