SAP ABAP Table PROJ_REQ (Project definition for appropriation request)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ AIP (Package) IM capital investment prog.(master data, budget, info syst.)

Basic Data

Table Category	INTTAB	Structure
Structure	PROJ_REQ	Table Relationship Diagram
Short Description	Project definition for appropriation request

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PROJ_REQ	ABGSL	TKKAA	ABGSL	REF	C	CN
2	PROJ_REQ	ASTNR	TCJ05	ASTNR	REF	C	CN
3	PROJ_REQ	BPROF	TBP1C	PROFIL	REF	C	CN
4	PROJ_REQ	DPPPROF	AD01C_PROF	PROFNR
5	PROJ_REQ	ETYPE	T8JE	ETYPE	REF	C	CN
6	PROJ_REQ	FERC_IND	FERC_C7	IND	REF
7	PROJ_REQ	FMPRF	TBP1C	PROFIL	REF		CN
8	PROJ_REQ	FUNC_AREA	TFKB	FKBER
9	PROJ_REQ	IMPRF	TAPRF	IVPRO	REF	C	CN
10	PROJ_REQ	JIBCL	T8J6A	CLASS
11	PROJ_REQ	JIBSA	T8J6C	SUBCLASS
12	PROJ_REQ	KALID	TFACD	IDENT	REF	C	CN
13	PROJ_REQ	KOSTL	CSKS	KOSTL	REF	C	CN
14	PROJ_REQ	KTRG	CKPH	KSTRG	REF	C	CN
15	PROJ_REQ	MANDT	T000	MANDT	KEY	1	CN
16	PROJ_REQ	OBJNR	ONR00	OBJNR	REF	C	C
17	PROJ_REQ	PARGR	V_TVPG_S	PARGR	REF
18	PROJ_REQ	PGPRF	TPGPRF	PROFID		1	CN
19	PROJ_REQ	PLNAW	TCA09	PLNAW	REF	C	CN
20	PROJ_REQ	PPROF	TBP1C	PROFIL	REF	C	CN
21	PROJ_REQ	PRCTR	CEPC	PRCTR	REF	C	CN
22	PROJ_REQ	PROFL	TCJ41	PROFIDPROJ	REF	C	CN
23	PROJ_REQ	PWHIE	TCURC	WAERS	REF	C	CN
24	PROJ_REQ	RECID	T8JJ	RECID	REF	C	CN
25	PROJ_REQ	SCPRF	TCXPS	PROFIL	REF	C	CN
26	PROJ_REQ	SMPRF	TCN54	VER_PROFIL		1	CN
27	PROJ_REQ	SPART	TVTA	SPART
28	PROJ_REQ	SPSNR	PROJS	PSPNR	REF	C	CN
29	PROJ_REQ	STORT	T499S	STAND
30	PROJ_REQ	STSPD	TJ20	STSMA	REF	C	CN
31	PROJ_REQ	STSPR	TJ20	STSMA	REF	C	CN
32	PROJ_REQ	TXJCD	TTXJ	TXJCD	REF	C	CN
33	PROJ_REQ	TXTSP	T002	SPRAS	REF	C	CN
34	PROJ_REQ	VBUKR	T001	BUKRS	REF	C	CN
35	PROJ_REQ	VERNR	TCJ04	VERNR	REF	C	CN
36	PROJ_REQ	VGSBR	TGSB	GSBER	REF	C	CN
37	PROJ_REQ	VKOKR	TKA01	KOKRS	REF	C	CN
38	PROJ_REQ	VKORG	TVKO	VKORG
39	PROJ_REQ	VNAME	T8JV	VNAME	REF	C	CN
40	PROJ_REQ	VPROF	TCN41	PROFIDNETZ	REF	C	CN
41	PROJ_REQ	VTWEG	TVKOV	VTWEG
42	PROJ_REQ	WERKS	T001W	WERKS	REF	C	CN
43	PROJ_REQ	ZSCHM	TPI01	ZSCHM	REF	C	CN
44	PROJ_REQ	ZTEHT	T006	MSEHI	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in