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

History

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