SAP ABAP Table OLR3_PROJI (PSIS - Individual Overviews: Project Definitions)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-ST (Application Component) Structures
     ⤷ R3_OBJECTLINK_R3 (Package) Object Link cProjects and R/3

Basic Data

Table Category	INTTAB	Structure
Structure	OLR3_PROJI	Table Relationship Diagram
Short Description	PSIS - Individual Overviews: Project Definitions

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	Project Definition Structure for Project Reporting
2	ARNUMMER	☐	ADMI_RUN_D	ADMI_RUN	CHAR	6	0	Archiving Session Number
3	VSGRUPPE	☐	VSGRUPPE	TEXT20	CHAR	20	0	Group for a project version
4	VSNUMMER	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
5	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
6	PSPID	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
7	POST1	☐	PS_POST1	TEXT40	CHAR	40	0	PS: Short description (first text line)
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	KIMSK	☐	PS_KIMSK	PS_PROID	CHAR	24	0	Selection mask for WBS element short IDs
10	VERNR	☐	PS_VERNR	PS_VERNR	NUMC	8	0	Number of the responsible person (project manager)	TCJ04
11	VERNA	☐	PS_VERNA	PS_VERNA	CHAR	25	0	Name of responsible person (Project manager)
12	ASTNR	☐	PS_ASTNR	PS_ASTNR	NUMC	8	0	Applicant number	TCJ05
13	ASTNA	☐	PS_ASTNA	PS_ASTNA	CHAR	25	0	Applicant
14	VBUKR	☐	PS_VBUKR	BUKRS	CHAR	4	0	Company code for the project	T001
15	VGSBR	☐	PS_VGSBR	GSBER	CHAR	4	0	Business area for the project	TGSB
16	VKOKR	☐	PS_VKOKR	CACCD	CHAR	4	0	Controlling area for the project	TKA01
17	PWHIE	☐	PS_PWHIE	WAERS	CUKY	5	0	WBS currency (project definition)	TCURC
18	ZUORD	☐	PS_ZUORD	PS_ZUORD	NUMC	1	0	Network assignment
19	PLFAZ	☐	PS_PLFAZ	DATUM	DATS	8	0	Project planned start date
20	PLSEZ	☐	PS_PLSEZ	DATUM	DATS	8	0	Project planned finish date
21	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
22	KALID	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
23	VGPLF	☐	PS_VGPLF	PSPLFRM	NUMC	1	0	Planning method for project basic dates
24	EWPLF	☐	PS_EWPLF	PSPLFRM	NUMC	1	0	Planning method for project forecast dates
25	ZTEHT	☐	PS_ZTEHT	MEINS	UNIT	3	0	Time unit in time scheduling	T006
26	VPROF	☐	PROFIDNZPL	PROFILID	CHAR	7	0	Network profile	TCN41
27	PROFL	☐	PROFIDPROJ	PROFIDPROJ	CHAR	7	0	Project profile	TCJ41
28	BPROF	☐	BP_BPROFIL	BP_PROFIL	CHAR	6	0	Budget Profile	TBP1C
29	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
30	AEDTE	☐	PS_AEDTE	DATUM	DATS	8	0	Date of last scheduling of the overall network (basic dates)
31	AEDTP	☐	PS_AEDTP	DATUM	DATS	8	0	Date of last scheduling of the overall network (forecast)
32	AEDTI	☐	PS_AEDTI	DATUM	DATS	8	0	Date of the last scheduling of the overall network (actual)
33	BESTA	☐	PS_BESTAND	XFELD	CHAR	1	0	Project stock
34	SCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
35	XSTAT	☐	PS_XSTAT	XFELD	CHAR	1	0	Statistical WBS element
36	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
37	ZSCHM	☐	PS_ZSCHM	PS_ZSCHM	CHAR	7	0	Interest Profile for Project/Order Interest Calculation	TPI01
38	SCPRF	☐	PS_SCHDPRF	PS_SCHDPRF	CHAR	12	0	Profile for WBS scheduling	TCXPS
39	IMPRF	☐	IM_PROFIL	IM_PROFIL	CHAR	6	0	Investment measure profile	TAPRF
40	FMPRF	☐	PSFM_PRF	BP_PROFIL	CHAR	6	0	Payment plan profile	TBP1C
41	PPROF	☐	BP_PPROFIL	BP_PROFIL	CHAR	6	0	Planning profile	*
42	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
43	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
44	ETYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	T8JE
45	OTYPE	☐	JV_OTYPE	JV_OTYPE	CHAR	4	0	Joint Venture Object Type
46	JIBCL	☐	JV_JIBCL	JV_JIBCL	CHAR	3	0	JIB/JIBE Class	T8J6A
47	JIBSA	☐	JV_JIBSA	JV_JIBSA	CHAR	5	0	JIB/JIBE Subclass A	T8J6C
48	STATXT	☐	STATUSTEXT_2	CHAR80	CHAR	80	0	Edited status text
49	FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
50	.INCLUDE	☐				0	0
51	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
52	INT_ID	☐	OBJEKT_ID	CHAR30	CHAR	30	0	ID/Object key
53	LOEKZ	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
54	LIGHT	☐	LVC_EXLED	CHAR1	CHAR	1	0	ALV control: Exception as LED

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OLR3_PROJI	ASTNR	TCJ05	ASTNR	REF	C	CN
2	OLR3_PROJI	BPROF	TBP1C	PROFIL	REF
3	OLR3_PROJI	ETYPE	T8JE	ETYPE	REF
4	OLR3_PROJI	FMPRF	TBP1C	PROFIL	REF	C	CN
5	OLR3_PROJI	IMPRF	TAPRF	IVPRO	REF	C	CN
6	OLR3_PROJI	JIBCL	T8J6A	CLASS	REF
7	OLR3_PROJI	JIBSA	T8J6C	SUBCLASS	REF
8	OLR3_PROJI	KALID	TFACD	IDENT
9	OLR3_PROJI	PRCTR	CEPC	PRCTR	REF	C	CN
10	OLR3_PROJI	PROFL	TCJ41	PROFIDPROJ	REF
11	OLR3_PROJI	PWHIE	TCURC	WAERS
12	OLR3_PROJI	RECID	T8JJ	RECID	REF
13	OLR3_PROJI	SCPRF	TCXPS	PROFIL	REF	C	CN
14	OLR3_PROJI	TXJCD	TTXJ	TXJCD	REF	C	CN
15	OLR3_PROJI	TXTSP	T002	SPRAS
16	OLR3_PROJI	VBUKR	T001	BUKRS
17	OLR3_PROJI	VERNR	TCJ04	VERNR	REF	C	CN
18	OLR3_PROJI	VGSBR	TGSB	GSBER
19	OLR3_PROJI	VKOKR	TKA01	KOKRS
20	OLR3_PROJI	VNAME	T8JV	VNAME	REF
21	OLR3_PROJI	VPROF	TCN41	PROFIDNETZ	REF
22	OLR3_PROJI	WERKS	T001W	WERKS
23	OLR3_PROJI	ZSCHM	TPI01	ZSCHM	REF	C	CN
24	OLR3_PROJI	ZTEHT	T006	MSEHI	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	2002_1_470