SAP ABAP Table JVGLFLEXP (General Ledger: Plan Line Items)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ CA-JVA (Application Component) Joint Venture und Production Sharing Accounting
     ⤷ GJVA_FAGL (Package) JVA NewGL integration # none switched objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JVGLFLEXP	Table Relationship Diagram
Short Description	General Ledger: Plan Line Items

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	RCLNT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	RYEAR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
3	DOCNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
4	.INCLUDE	☑				0	0	General Ledger: Technical Fields in Key of Line Items
5	RLDNR	☑	FAGL_RLDNR	RLDNR	CHAR	2	0	Ledger in General Ledger Accounting	V_FAGL_T881_DBAL
6	.INCLUDE	☑				0	0	General Ledger: Additional Acct Assignmt (SAP) in Key of LIs
7	RBUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	DOCLN	☑	DOCLN6	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
9	DOCCT	☑	DOCCT	DOCCT	CHAR	1	0	Document Type
10	RPMAX	☑	RPMAX	RPMAX	NUMC	3	0	Period
11	.INCLUDE	☐				0	0	General ledger: Transaction attributes
12	ACTIV	☐	ACTI1	ACTIVITY	CHAR	4	0	FI-SL Business Transaction	T022
13	RMVCT	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	T856
14	.INCLUDE	☐				0	0	RTCUR + RUNIT
15	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	*
16	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
17	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
18	.INCLUDE	☐				0	0	General Ledger: Technical Fields in Data Part of Line Items
19	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
20	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	T894
21	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
22	.INCLUDE	☐				0	0	General ledger: Main account assignment
23	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	SKB1
24	COST_ELEM	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKB
25	.INCLUDE	☐				0	0	General Ledger: Additional Acct Assignmt in Data Part of LIs
26	RCNTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
27	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
28	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
29	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
30	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
31	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
32	.INCLUDE	☐				0	0
33	.INCLUDE	☐				0	0
34	.INCLUDE	☐				0	0	General ledger: Sender SAP additional account assignment
35	SCNTR	☐	SKOST	KOSTL	CHAR	10	0	Sender cost center	CSKS
36	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
37	SFAREA	☐	SFKBER	FKBER	CHAR	16	0	Partner Functional Area	TFKB
38	SBUSA	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	TGSB
39	RASSC	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
40	PSEGMENT	☐	FB_PSEGMENT	FB_SEGMENT	CHAR	10	0	Partner Segment for Segmental Reporting	FAGL_SEGM
41	.INCLUDE	☐				0	0	General Ledger: Joint-Venture Accounting Fields
42	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
43	EGRUP	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	*
44	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	*
45	.INCLUDE	☐				0	0	Data Fields of a GL Totals Table
46	.INCLUDE	☐				0	0	Field Group TSL
47	TSLVT	☐	TSLVT12	WERTV12	CURR	23	2	Balance carried forward in transaction currency
48	TSL01	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
49	TSL02	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
50	TSL03	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
51	TSL04	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
52	TSL05	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
53	TSL06	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
54	TSL07	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
55	TSL08	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
56	TSL09	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
57	TSL10	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
58	TSL11	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
59	TSL12	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
60	TSL13	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
61	TSL14	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
62	TSL15	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
63	TSL16	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
64	.INCLUDE	☐				0	0	Field Group HSL
65	HSLVT	☐	HSLVT12	WERTV12	CURR	23	2	Balance carried forward in local currency
66	HSL01	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
67	HSL02	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
68	HSL03	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
69	HSL04	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
70	HSL05	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
71	HSL06	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
72	HSL07	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
73	HSL08	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
74	HSL09	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
75	HSL10	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
76	HSL11	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
77	HSL12	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
78	HSL13	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
79	HSL14	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
80	HSL15	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
81	HSL16	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
82	.INCLUDE	☐				0	0	Field Group KSL
83	KSLVT	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
84	KSL01	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
85	KSL02	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
86	KSL03	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
87	KSL04	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
88	KSL05	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
89	KSL06	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
90	KSL07	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
91	KSL08	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
92	KSL09	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
93	KSL10	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
94	KSL11	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
95	KSL12	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
96	KSL13	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
97	KSL14	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
98	KSL15	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
99	KSL16	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
100	.INCLUDE	☐				0	0	Field Group OSL
101	OSLVT	☐	OSLVT12	WERTV12	CURR	23	2	Balance carried forward in fourth currency
102	OSL01	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
103	OSL02	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
104	OSL03	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
105	OSL04	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
106	OSL05	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
107	OSL06	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
108	OSL07	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
109	OSL08	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
110	OSL09	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
111	OSL10	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
112	OSL11	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
113	OSL12	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
114	OSL13	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
115	OSL14	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
116	OSL15	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
117	OSL16	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
118	.INCLUDE	☐				0	0	Field Group MSL
119	MSLVT	☐	MSLVT12	MENGV12	QUAN	23	3	Balance carried forward of quantity
120	MSL01	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
121	MSL02	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
122	MSL03	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
123	MSL04	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
124	MSL05	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
125	MSL06	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
126	MSL07	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
127	MSL08	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
128	MSL09	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
129	MSL10	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
130	MSL11	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
131	MSL12	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
132	MSL13	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
133	MSL14	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
134	MSL15	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
135	MSL16	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
136	.INCLUDE	☐				0	0	Mandatory Fields of a GL Plan Line Item Table
137	DRCRK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
138	DOCTY	☐	FAGL_DOCTY	FAGL_DOCTY	CHAR	2	0	Document Type for Plan Documents in General Ledger	FAGL_T889A
139	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
140	REFDOCNR	☐	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
141	REFDOCLN	☐	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
142	REFDOCCT	☐	REFDOCCT	DOCCT	CHAR	1	0	Reference document category
143	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	USR02
144	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JVGLFLEXP	ACTIV	T022	ACTIVITY
2	JVGLFLEXP	COST_ELEM	CSKB	KSTAR
3	JVGLFLEXP	DOCTY	FAGL_T889A	DOCTY
4	JVGLFLEXP	LOGSYS	TBDLS	LOGSYS
5	JVGLFLEXP	PPRCTR	CEPC	PRCTR
6	JVGLFLEXP	PRCTR	CEPC	PRCTR
7	JVGLFLEXP	PSEGMENT	FAGL_SEGM	SEGMENT
8	JVGLFLEXP	RACCT	SKB1	SAKNR
9	JVGLFLEXP	RASSC	T880	RCOMP	KEY	1	CN
10	JVGLFLEXP	RBUKRS	T001	BUKRS
11	JVGLFLEXP	RCLNT	T000	MANDT	KEY	1	CN
12	JVGLFLEXP	RCNTR	CSKS	KOSTL
13	JVGLFLEXP	RLDNR	V_FAGL_T881_DBAL	RLDNR
14	JVGLFLEXP	RMVCT	T856	TRTYP
15	JVGLFLEXP	RVERS	T894	RVERS
16	JVGLFLEXP	SBUSA	TGSB	GSBER	KEY	1	CN
17	JVGLFLEXP	SCNTR	CSKS	KOSTL
18	JVGLFLEXP	SEGMENT	FAGL_SEGM	SEGMENT
19	JVGLFLEXP	SFAREA	TFKB	FKBER	KEY	1	CN
20	JVGLFLEXP	USNAM	USR02	BNAME

History

Last changed by/on	SAP	20110901
SAP Release Created in	605