SAP ABAP Table J_3GV_J3GPA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	J_3GV_J3GPA	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PSPNR	☑	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element
3	POSID	☑	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
4	POST1	☑	PS_POST1	TEXT40	CHAR	40	0	PS: Short description (first text line)
5	OBJNR	☑	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
6	PSPHI	☑	PS_PSPHI	PS_PSPNR	NUMC	8	0	Current number of the appropriate project	PROJ
7	POSKI	☑	PS_POSKI	PS_PROKI	CHAR	16	0	WBS element short identification
8	ERNAM	☑	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	ERDAT	☑	ERDAT	DATUM	DATS	8	0	Date on which the record was created
10	STAT	☑	J_STATUS	J_STATUS	CHAR	5	0	Object status
11	INACT	☐	J_INACT	J_INACT	CHAR	1	0	Indicator: Status Is Inactive
12	PBUKR	☐	PS_PBUKR	BUKRS	CHAR	4	0	Company code for WBS element	T001
13	PGSBR	☐	PS_PGSBR	GSBER	CHAR	4	0	Business area for WBS element	TGSB
14	PKOKR	☐	PS_PKOKR	CACCD	CHAR	4	0	Controlling area for WBS element	TKA01
15	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
16	PRART	☐	PS_PRART	PS_PRART	CHAR	2	0	Project type	TCJ1
17	STUFE	☐	PS_STUFE	INT1	INT1	3	0	Level in project hierarchy
18	PLAKZ	☐	PS_PLAKZ	XFELD	CHAR	1	0	Indicator: Planning element
19	BELKZ	☐	PS_BELKZ	XFELD	CHAR	1	0	Indicator: Account assignment element
20	FAKKZ	☐	PS_FAKKZ	XFELD	CHAR	1	0	Indicator: Billing element
21	NPFAZ	☐	PS_NPFAR	XFELD	CHAR	1	0	Relationship of network activity to production order
22	ZUORD	☐	PS_ZUORD	PS_ZUORD	NUMC	1	0	Network assignment
23	TRMEQ	☐	PS_TRMEQ	X	CHAR	1	0	Indicator: WBS dates detailed by activity dates
24	KVEWE	☐	KVEWE	KVEWE	CHAR	1	0	Usage of the Condition Table	T681V
25	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
26	KALSM	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	T683
27	ZSCHL	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key	TKZSL
28	ABGSL	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
29	AKOKR	☐	PS_AKOKR	CACCD	CHAR	4	0	Controlling area of requesting cost center	TKA01
30	AKSTL	☐	PS_AKSTL	KOSTL	CHAR	10	0	Requesting cost center	CSKS
31	FKOKR	☐	PS_FKOKR	CACCD	CHAR	4	0	Controlling area of responsible cost center	TKA01
32	FKSTL	☐	PS_FKSTL	KOSTL	CHAR	10	0	Responsible cost center	CSKS
33	FABKL	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
34	PSPRI	☐	NW_PRIO	NW_PRIO	CHAR	1	0	Priority	TCN07
35	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
36	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
37	PWPOS	☐	PS_PWPOS	WAERS	CUKY	5	0	WBS element currency	TCURC
38	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
39	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
40	KOSTL	☐	PS_KOSTL	KOSTL	CHAR	10	0	Cost center to which costs are actually posted	CSKS
41	KTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object
42	BERST	☐	PS_BERST	CHAR16	CHAR	16	0	Authorization key for project master data
43	BERTR	☐	PS_BERTR	CHAR16	CHAR	16	0	Authorization key for project dates (WBS)
44	BERKO	☐	PS_BERKO	CHAR16	CHAR	16	0	Authorization key for costs and revenues
45	BERBU	☐	PS_BERBU	CHAR16	CHAR	16	0	Authorization key for project budget
46	CLASF	☐	PS_CLASF	XFELD	CHAR	1	0	Indicator: WBS element used in project summarization
47	SPSNR	☐	PS_SPSNR	PS_SPSNR	NUMC	8	0	Std WBS: Internal project item number (w/exit on ID)	PRPSS
48	SCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
49	XSTAT	☐	PS_XSTAT	XFELD	CHAR	1	0	Statistical WBS element
50	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
51	ZSCHM	☐	PS_ZSCHM	PS_ZSCHM	CHAR	7	0	Interest Profile for Project/Order Interest Calculation	TPI01
52	IMPRF	☐	IM_PROFIL	IM_PROFIL	CHAR	6	0	Investment measure profile	TAPRF
53	EVGEW	☐	EV_WEIGHTD	DEC8	DEC	8	0	Aggregation weight for POC (PS progress)
54	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
55	SUBPR	☐	PS_SUBPR	PS_SUBPR	CHAR	12	0	Sub-project in work breakdown structure	PRTP
56	POSTU	☐	PS_POSTU	CHAR40	CHAR	40	0	PS: Short description (1st text line) in all caps
57	PLINT	☐	PLINT	XFELD	CHAR	1	0	Indicator for Integrated Planning
58	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
59	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
60	FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number
61	TADAT	☐	TABGDAT	DATUM	DATS	8	0	Technically complete date
62	IZWEK	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
63	ISIZE	☐	IM_SIZECL	SIZECL	CHAR	2	0	Scale of investment objects	TAIF5
64	IUMKZ	☐	AM_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	T087K
65	ABUKR	☐	IM_ABUKRS	BUKRS	CHAR	4	0	Requesting company code	T001

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_3GV_J3GPA	ABGSL	TKKAA	ABGSL	REF	C	CN
2	J_3GV_J3GPA	ABUKR	T001	BUKRS		1	CN
3	J_3GV_J3GPA	AENNR	AENR	AENNR	REF	C	CN
4	J_3GV_J3GPA	AKOKR	TKA01	KOKRS	REF	C	CN
5	J_3GV_J3GPA	AKSTL	CSKS	KOSTL	REF	C	CN
6	J_3GV_J3GPA	EQUNR	EQUI	EQUNR	REF	C	CN
7	J_3GV_J3GPA	FABKL	TFACD	IDENT	REF	1	CN
8	J_3GV_J3GPA	FKOKR	TKA01	KOKRS	REF	C	CN
9	J_3GV_J3GPA	FKSTL	CSKS	KOSTL	REF	C	CN
10	J_3GV_J3GPA	IMPRF	TAPRF	IVPRO	REF	C	CN
11	J_3GV_J3GPA	ISIZE	TAIF5	SIZECL		1	CN
12	J_3GV_J3GPA	IUMKZ	T087K	UMWKZ		1	CN
13	J_3GV_J3GPA	IZWEK	T087I	IZWEK		1	CN
14	J_3GV_J3GPA	KALSM	T683	KALSM	REF	C	CN
15	J_3GV_J3GPA	KAPPL	T681A	KAPPL	REF	C	CN
16	J_3GV_J3GPA	KOSTL	CSKS	KOSTL	REF	C	CN
17	J_3GV_J3GPA	KVEWE	T681V	KVEWE	REF	C	CN
18	J_3GV_J3GPA	MANDT	T000	MANDT	KEY	1	CN
19	J_3GV_J3GPA	OBJNR	ONR00	OBJNR	REF	C	C
20	J_3GV_J3GPA	PBUKR	T001	BUKRS	REF	C	CN
21	J_3GV_J3GPA	PGSBR	TGSB	GSBER	REF	C	CN
22	J_3GV_J3GPA	PKOKR	TKA01	KOKRS	REF	C	CN
23	J_3GV_J3GPA	PRART	TCJ1	PRART	REF	C	CN
24	J_3GV_J3GPA	PRCTR	CEPC	PRCTR	REF	C	CN
25	J_3GV_J3GPA	PSPHI	PROJ	PSPNR	REF	1	CN
26	J_3GV_J3GPA	PSPRI	TCN07	NPRIO	REF	C	CN
27	J_3GV_J3GPA	PWPOS	TCURC	WAERS	REF	C	CN
28	J_3GV_J3GPA	SPSNR	PRPSS	PSPNR	REF	C	C
29	J_3GV_J3GPA	SUBPR	PRTP	SUBPR	REF	C	CN
30	J_3GV_J3GPA	TPLNR	IFLOT	TPLNR	REF	C	CN
31	J_3GV_J3GPA	TXJCD	TTXJ	TXJCD	REF	C	CN
32	J_3GV_J3GPA	TXTSP	T002	SPRAS	REF	C	CN
33	J_3GV_J3GPA	WERKS	T001W	WERKS	REF	1	CN
34	J_3GV_J3GPA	ZSCHL	TKZSL	ZSCHL
35	J_3GV_J3GPA	ZSCHM	TPI01	ZSCHM	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in