SAP ABAP Table /CCIS/PROFTAXA (Actual 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/PROFTAXA	Table Relationship Diagram
Short Description	Actual 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	.INCLUDE	☐				0	0	General ledger: Transaction attributes
10	ACTIV	☐	ACTI1	ACTIVITY	CHAR	4	0	FI-SL Business Transaction	T022
11	RMVCT	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	T856
12	.INCLUDE	☐				0	0	RTCUR + RUNIT
13	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	*
14	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
15	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
16	.INCLUDE	☐				0	0	General ledger: Technical fields
17	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
18	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	*
19	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
20	.INCLUDE	☐				0	0	General ledger: Main account assignment
21	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	SKB1
22	COST_ELEM	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKB
23	.INCLUDE	☐				0	0	General ledger: SAP additional account assignment
24	RTAXOBJ	☐	J_3RF_TAX_OBJECT	J_3RF_TAX_OBJECT	CHAR	21	0	Tax Object	*
25	REXPTYPE	☐	J_3RF_TAX_EXPTYPE	J_3RF_TAX_EXPTYPE	CHAR	1	0	Type of Expenses
26	RACTIVTYP	☐	J_3RF_TAX_ACTTYPE	J_3RF_TAX_ACTTYPE	CHAR	10	0	Activity Type
27	RMATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
28	RMATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
29	RPRODUCT	☐	J_3RF_TAX_PRODUCT	MATNR	CHAR	18	0	Product type	*
30	RANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
31	RANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
32	RTAXREG	☐	J_3RF_TAX_REGCOD	J_3RF_TAX_REGCOD	CHAR	10	0	Tax Register Code
33	RTAXROW	☐	J_3RF_TAX_DECROW	J_3RF_TAX_DECROW	CHAR	17	0	Tax Return Row Number	J_3RFTAX_DECROW
34	RCONTRACT	☐	J_3RF_TAX_CONTRACT	J_3RF_TAX_CONTRACT	CHAR	18	0	Contract Number
35	RKTRLAGT	☐	J_3RF_TAX_KTRLAGT	KUNNR	CHAR	10	0	Customer number	*
36	RDIVISION	☐	J_3RF_TAX_DIVISION	J_3RF_TAX_DIVISION	CHAR	5	0	Division Number
37	.INCLUDE	☐				0	0
38	.INCLUDE	☐				0	0
39	.INCLUDE	☐				0	0	General ledger: Sender SAP additional account assignment
40	SBUKRS	☐	PBUKRS	BUKRS	CHAR	4	0	Company code of partner	T001
41	STAXOBJ	☐	J_3RF_TAX_SOBJECT	J_3RF_TAX_OBJECT	CHAR	21	0	Sending Tax Object	*
42	SEXPTYPE	☐	J_3RF_TAX_SEXPTYPE	J_3RF_TAX_EXPTYPE	CHAR	1	0	Sending Expenses Type
43	SACTIVTYP	☐	J_3RF_TAX_SACTTYPE	J_3RF_TAX_ACTTYPE	CHAR	10	0	Sending Activity Type
44	SACCT	☐	J_3RF_TAX_SACCT	SAKNR	CHAR	10	0	Account number	*
45	SMATKL	☐	J_3RF_TAX_SMATKL	MATKL	CHAR	9	0	Material group	T023
46	SPRODUCT	☐	J_3RF_TAX_SPRODUCT	MATNR	CHAR	18	0	Sender product type	*
47	SCONTRACT	☐	J_3RF_TAX_SCONTRACT	J_3RF_TAX_CONTRACT	CHAR	18	0	Sending Contract Number
48	SKTRLAGT	☐	J_3RF_TAX_SKTRLAGT	KUNNR	CHAR	10	0	Sending Customer number	*
49	SDIVISION	☐	J_3RF_TAX_SDIVISION	J_3RF_TAX_DIVISION	CHAR	5	0	Sending Division Number
50	.INCLUDE	☐				0	0	Value Fields of GL Line Items Table
51	TSL	☐	VTCUR12	WERTV12	CURR	23	2	Value in Transaction Currency
52	HSL	☐	VLCUR12	WERTV12	CURR	23	2	Value in Local Currency
53	KSL	☐	VGCUR12	WERTV12	CURR	23	2	Value in Group Currency
54	OSL	☐	VOCUR12	WERTV12	CURR	23	2	Value in Another Currency
55	MSL	☐	QUAN1_12	MENGV12	QUAN	23	3	Quantity
56	WSL	☐	VWCUR12	WERTV12	CURR	23	2	Value in Original Transaction Currency (Document Currency)
57	.INCLUDE	☐				0	0	Mandatory Fields of a GL Actual Line Item Table
58	DRCRK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
59	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
60	RWCUR	☐	RWCUR	WAERS	CUKY	5	0	Currency key of the original transaction currency	TCURC
61	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
62	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
63	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
64	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
65	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
66	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
67	LINETYPE	☐	LINETYPE	LINETYPE	CHAR	5	0	Item category	T8G02
68	XSPLITMOD	☐	XSPLITMOD	XFELD	CHAR	1	0	Item changed by document splitting
69	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	USR02
70	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
71	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/CCIS/PROFTAXA	ACTIV	T022	ACTIVITY
2	/CCIS/PROFTAXA	AWTYP	TTYP	AWTYP
3	/CCIS/PROFTAXA	BSCHL	TBSL	BSCHL
4	/CCIS/PROFTAXA	COST_ELEM	CSKB	KSTAR
5	/CCIS/PROFTAXA	LINETYPE	T8G02	LINETYPE
6	/CCIS/PROFTAXA	LOGSYS	TBDLS	LOGSYS
7	/CCIS/PROFTAXA	RACCT	SKB1	SAKNR
8	/CCIS/PROFTAXA	RANLN1	ANLH	ANLN1
9	/CCIS/PROFTAXA	RANLN2	ANLA	ANLN2
10	/CCIS/PROFTAXA	RBUKRS	T001	BUKRS
11	/CCIS/PROFTAXA	RCLNT	T000	MANDT	KEY	1	CN
12	/CCIS/PROFTAXA	RLDNR	V_FAGL_T881_DBAL	RLDNR
13	/CCIS/PROFTAXA	RMATKL	T023	MATKL
14	/CCIS/PROFTAXA	RMATNR	MARA	MATNR
15	/CCIS/PROFTAXA	RMVCT	T856	TRTYP
16	/CCIS/PROFTAXA	RTAXROW	J_3RFTAX_DECROW	DECROW
17	/CCIS/PROFTAXA	RWCUR	TCURC	WAERS
18	/CCIS/PROFTAXA	SBUKRS	T001	BUKRS
19	/CCIS/PROFTAXA	SMATKL	T023	MATKL
20	/CCIS/PROFTAXA	USNAM	USR02	BNAME

History

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