SAP ABAP Table COFIS (Actual line items for reconciliation ledger)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF (Application Component) Basic Functions
     ⤷ KKAL (Package) CO-RCL reconciliation ledger

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	COFIS	Table Relationship Diagram
Short Description	Actual line items for reconciliation 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	GL_SIRID	☑	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
3	RLDNR	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	T881
4	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
5	RVERS	☐	VERSN	COVERSI	CHAR	3	0	Version	TKA09
6	RYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
7	RTCUR	☐	RACUR	WAERS	CUKY	5	0	Currency Key for Amounts in Controlling Area Currency	TCURC
8	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
9	DRCRK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
10	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
11	DOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
12	DOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
13	DOCLN	☐	DOCLN	DOCLN	CHAR	3	0	Document line
14	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
15	RACCT	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
16	RHRKFT	☐	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	TKKH1
17	ROBART	☐	COFI_OB_CV	J_OBART_LD	CHAR	2	0	Reconciliation ledger object type (technical)
18	RSCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
19	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
20	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
21	RFUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
22	RGRANT_NBR	☐	GM_GRANT_RECEIVER	GM_GRANT_NBR	CHAR	20	0	Receiver Grant
23	RLOGSYS	☐	LOGSYSO	LOGSYS	CHAR	10	0	Logical system of object	TBDLS
24	SBUKRS	☐	PBUKRS	BUKRS	CHAR	4	0	Company code of partner	T001
25	SACCT	☐	PKSTAR	KSTAR	CHAR	10	0	Cost element of partner	CSKA
26	SHRKFT	☐	PHRKFT	HRKFT	CHAR	4	0	Origin of partner (subdivision of cost element)	TKKH1
27	SOBART	☐	COFI_PO_CV	J_OBART_LD	CHAR	2	0	Partner object type (for reconciliation ledger)
28	SSCOPE	☐	PSCOPE_CV	SCOPE_CV	CHAR	2	0	Partner object class
29	SBUSA	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	TGSB
30	SFAREA	☐	SFKBER	FKBER	CHAR	16	0	Partner Functional Area	TFKB
31	SFUND	☐	BP_P_GEBER	BP_GEBER	CHAR	10	0	Partner Fund	*
32	SGRANT_NBR	☐	GM_GRANT_SENDER	GM_GRANT_NBR	CHAR	20	0	Sender Grant
33	SLOGSYS	☐	LOGSYSP	LOGSYS	CHAR	10	0	Logical system of partner object	TBDLS
34	VRGNG	☐	CO_VORGANG	J_VORGANG	CHAR	4	0	CO Business Transaction	TJ01
35	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
36	OCLNT	☐	OCLNT	NUM3	NUMC	3	0	Original client
37	WRTTP	☐	CO_WRTTP	CO_WRTTP	CHAR	2	0	Value Type
38	TSL	☐	VCCUR9	WERTV9	CURR	17	2	Value in Controlling Area Currency
39	HSL	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
40	KSL	☐	VGCUR9	WERTV9	CURR	17	2	Value in group currency
41	MSL	☐	QUAN1	MENG8	QUAN	15	3	Quantity
42	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
43	AUTOM	☐	AUTOM	TEXT1	CHAR	1	0	Indicator: Automatic posting lines
44	DOCTY	☐	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	T889
45	ACTIV	☐	RCL_TRIG	RCL_TRIG	CHAR	4	0	Record type of reconciliation ledger
46	BVORG	☐	BVORG	BVORG	CHAR	16	0	Number of Cross-Company Code Posting Transaction
47	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
48	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
49	REFDOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
50	REFRYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
51	REFDOCLN	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
52	REFDOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
53	REFACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
54	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
55	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
56	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
57	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
58	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
59	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
60	STOKZ	☐	CO_STOKZ	FLAG	CHAR	1	0	Indicator: Document Has Been Reversed
61	STFLG	☐	CO_STFLG	FLAG	CHAR	1	0	Identifier for reversal document
62	ACCOUNT	☐	RACCT_RCL	SAKNR	CHAR	10	0	Reconciliation Account for Reconciliation Posting	SKB1
63	VAL_REFDOCLN	☐	VAL_REFDOCLN	DOCLN	CHAR	3	0	Posting Row in Operative Version

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	COFIS	ACCOUNT	SKB1	SAKNR		1	CN
2	COFIS	AWTYP	TTYP	AWTYP
3	COFIS	DOCTY	T889	DOCTY	REF	C	CN
4	COFIS	KOKRS	TKA01	KOKRS		C	CN
5	COFIS	LOGSYS	TBDLS	LOGSYS
6	COFIS	RACCT	CSKA	KSTAR
7	COFIS	RBUKRS	T001	BUKRS	REF	C	CN
8	COFIS	RBUSA	TGSB	GSBER	REF	C	CN
9	COFIS	RCLNT	T000	MANDT	KEY	1	CN
10	COFIS	RFAREA	TFKB	FKBER	REF	C	CN
11	COFIS	RHRKFT	TKKH1	HRKFT
12	COFIS	RLDNR	T881	RLDNR	KEY	1	CN
13	COFIS	RLOGSYS	TBDLS	LOGSYS	REF	C	CN
14	COFIS	RTCUR	TCURC	WAERS	KEY	1	CN
15	COFIS	RUNIT	T006	MSEHI	KEY	1	CN
16	COFIS	RVERS	TKA09	VERSN	KEY	1	CN
17	COFIS	SACCT	CSKA	KSTAR
18	COFIS	SBUKRS	T001	BUKRS	REF	C	CN
19	COFIS	SBUSA	TGSB	GSBER	REF	C	CN
20	COFIS	SFAREA	TFKB	FKBER		C	CN
21	COFIS	SHRKFT	TKKH1	HRKFT
22	COFIS	SLOGSYS	TBDLS	LOGSYS		C	CN
23	COFIS	VRGNG	TJ01	VRGNG		C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in