SAP ABAP Table /CCIS/PROFTAXP (Plan Line Items Table for General Ledger)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-SL (Application Component) Special Purpose Ledger
     ⤷ /CCIS/TAX (Package) Tax Accounting

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	/CCIS/PROFTAXP	Table Relationship Diagram
Short Description	Plan Line Items Table for General Ledger

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
5	RLDNR	☑	FAGL_RLDNR	RLDNR	CHAR	2	0	Ledger in General Ledger Accounting	V_FAGL_T881_DBAL
6	.INCLUDE	☑				0	0	General ledger: SAP additional account assignment
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
19	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
20	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	*
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: SAP additional account assignment
26	RTAXOBJ	☐	J_3RF_TAX_OBJECT	J_3RF_TAX_OBJECT	CHAR	21	0	Tax Object	*
27	REXPTYPE	☐	J_3RF_TAX_EXPTYPE	J_3RF_TAX_EXPTYPE	CHAR	1	0	Type of Expenses
28	RACTIVTYP	☐	J_3RF_TAX_ACTTYPE	J_3RF_TAX_ACTTYPE	CHAR	10	0	Activity Type
29	RMATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
30	RMATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
31	RPRODUCT	☐	J_3RF_TAX_PRODUCT	MATNR	CHAR	18	0	Product type	*
32	RANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
33	RANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
34	RTAXREG	☐	J_3RF_TAX_REGCOD	J_3RF_TAX_REGCOD	CHAR	10	0	Tax Register Code
35	RTAXROW	☐	J_3RF_TAX_DECROW	J_3RF_TAX_DECROW	CHAR	17	0	Tax Return Row Number	J_3RFTAX_DECROW
36	RCONTRACT	☐	J_3RF_TAX_CONTRACT	J_3RF_TAX_CONTRACT	CHAR	18	0	Contract Number
37	RKTRLAGT	☐	J_3RF_TAX_KTRLAGT	KUNNR	CHAR	10	0	Customer number	*
38	RDIVISION	☐	J_3RF_TAX_DIVISION	J_3RF_TAX_DIVISION	CHAR	5	0	Division Number
39	.INCLUDE	☐				0	0
40	.INCLUDE	☐				0	0
41	.INCLUDE	☐				0	0	General ledger: Sender SAP additional account assignment
42	SBUKRS	☐	PBUKRS	BUKRS	CHAR	4	0	Company code of partner	T001
43	STAXOBJ	☐	J_3RF_TAX_SOBJECT	J_3RF_TAX_OBJECT	CHAR	21	0	Sending Tax Object	*
44	SEXPTYPE	☐	J_3RF_TAX_SEXPTYPE	J_3RF_TAX_EXPTYPE	CHAR	1	0	Sending Expenses Type
45	SACTIVTYP	☐	J_3RF_TAX_SACTTYPE	J_3RF_TAX_ACTTYPE	CHAR	10	0	Sending Activity Type
46	SACCT	☐	J_3RF_TAX_SACCT	SAKNR	CHAR	10	0	Account number	*
47	SMATKL	☐	J_3RF_TAX_SMATKL	MATKL	CHAR	9	0	Material group	T023
48	SPRODUCT	☐	J_3RF_TAX_SPRODUCT	MATNR	CHAR	18	0	Sender product type	*
49	SCONTRACT	☐	J_3RF_TAX_SCONTRACT	J_3RF_TAX_CONTRACT	CHAR	18	0	Sending Contract Number
50	SKTRLAGT	☐	J_3RF_TAX_SKTRLAGT	KUNNR	CHAR	10	0	Sending Customer number	*
51	SDIVISION	☐	J_3RF_TAX_SDIVISION	J_3RF_TAX_DIVISION	CHAR	5	0	Sending Division Number
52	.INCLUDE	☐				0	0	Data Fields of a GL Totals Table
53	.INCLUDE	☐				0	0	Field Group TSL
54	TSLVT	☐	TSLVT12	WERTV12	CURR	23	2	Balance carried forward in transaction currency
55	TSL01	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
56	TSL02	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
57	TSL03	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
58	TSL04	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
59	TSL05	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
60	TSL06	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
61	TSL07	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
62	TSL08	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
63	TSL09	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
64	TSL10	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
65	TSL11	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
66	TSL12	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
67	TSL13	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
68	TSL14	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
69	TSL15	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
70	TSL16	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
71	.INCLUDE	☐				0	0	Field Group HSL
72	HSLVT	☐	HSLVT12	WERTV12	CURR	23	2	Balance carried forward in local currency
73	HSL01	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
74	HSL02	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
75	HSL03	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
76	HSL04	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
77	HSL05	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
78	HSL06	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
79	HSL07	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
80	HSL08	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
81	HSL09	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
82	HSL10	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
83	HSL11	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
84	HSL12	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
85	HSL13	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
86	HSL14	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
87	HSL15	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
88	HSL16	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
89	.INCLUDE	☐				0	0	Field Group KSL
90	KSLVT	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
91	KSL01	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
92	KSL02	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
93	KSL03	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
94	KSL04	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
95	KSL05	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
96	KSL06	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
97	KSL07	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
98	KSL08	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
99	KSL09	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
100	KSL10	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
101	KSL11	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
102	KSL12	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
103	KSL13	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
104	KSL14	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
105	KSL15	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
106	KSL16	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
107	.INCLUDE	☐				0	0	Field Group OSL
108	OSLVT	☐	OSLVT12	WERTV12	CURR	23	2	Balance carried forward in fourth currency
109	OSL01	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
110	OSL02	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
111	OSL03	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
112	OSL04	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
113	OSL05	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
114	OSL06	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
115	OSL07	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
116	OSL08	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
117	OSL09	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
118	OSL10	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
119	OSL11	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
120	OSL12	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
121	OSL13	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
122	OSL14	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
123	OSL15	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
124	OSL16	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
125	.INCLUDE	☐				0	0	Field Group MSL
126	MSLVT	☐	MSLVT12	MENGV12	QUAN	23	3	Balance carried forward of quantity
127	MSL01	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
128	MSL02	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
129	MSL03	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
130	MSL04	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
131	MSL05	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
132	MSL06	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
133	MSL07	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
134	MSL08	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
135	MSL09	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
136	MSL10	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
137	MSL11	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
138	MSL12	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
139	MSL13	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
140	MSL14	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
141	MSL15	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
142	MSL16	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
143	.INCLUDE	☐				0	0	Mandatory Fields of a GL Plan Line Item Table
144	DRCRK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
145	DOCTY	☐	FAGL_DOCTY	FAGL_DOCTY	CHAR	2	0	Document Type for Plan Documents in General Ledger	FAGL_T889A
146	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
147	REFDOCNR	☐	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
148	REFDOCLN	☐	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
149	REFDOCCT	☐	REFDOCCT	DOCCT	CHAR	1	0	Reference document category
150	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	USR02
151	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	/CCIS/PROFTAXP	ACTIV	T022	ACTIVITY
2	/CCIS/PROFTAXP	COST_ELEM	CSKB	KSTAR
3	/CCIS/PROFTAXP	DOCTY	FAGL_T889A	DOCTY
4	/CCIS/PROFTAXP	LOGSYS	TBDLS	LOGSYS
5	/CCIS/PROFTAXP	RACCT	SKB1	SAKNR
6	/CCIS/PROFTAXP	RANLN1	ANLH	ANLN1
7	/CCIS/PROFTAXP	RANLN2	ANLA	ANLN2
8	/CCIS/PROFTAXP	RBUKRS	T001	BUKRS
9	/CCIS/PROFTAXP	RCLNT	T000	MANDT	KEY	1	CN
10	/CCIS/PROFTAXP	RLDNR	V_FAGL_T881_DBAL	RLDNR
11	/CCIS/PROFTAXP	RMATKL	T023	MATKL
12	/CCIS/PROFTAXP	RMATNR	MARA	MATNR
13	/CCIS/PROFTAXP	RMVCT	T856	TRTYP
14	/CCIS/PROFTAXP	RTAXROW	J_3RFTAX_DECROW	DECROW
15	/CCIS/PROFTAXP	SBUKRS	T001	BUKRS
16	/CCIS/PROFTAXP	SMATKL	T023	MATKL
17	/CCIS/PROFTAXP	USNAM	USR02	BNAME

History

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