SAP ABAP Table COFIP (Single plan 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	COFIP	Table Relationship Diagram
Short Description	Single plan 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	RPMAX	☐	RPMAX	RPMAX	NUMC	3	0	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	TSLVT	☐	TSLVT9	WERTV9	CURR	17	2	Balance carried forward in transaction currency
39	TSL01	☐	CSLXX9	WERTV9	CURR	17	2	Total movements of period in controlling area currency
40	TSL02	☐	CSLXX9	WERTV9	CURR	17	2	Total movements of period in controlling area currency
41	TSL03	☐	CSLXX9	WERTV9	CURR	17	2	Total movements of period in controlling area currency
42	TSL04	☐	CSLXX9	WERTV9	CURR	17	2	Total movements of period in controlling area currency
43	TSL05	☐	CSLXX9	WERTV9	CURR	17	2	Total movements of period in controlling area currency
44	TSL06	☐	CSLXX9	WERTV9	CURR	17	2	Total movements of period in controlling area currency
45	TSL07	☐	CSLXX9	WERTV9	CURR	17	2	Total movements of period in controlling area currency
46	TSL08	☐	CSLXX9	WERTV9	CURR	17	2	Total movements of period in controlling area currency
47	TSL09	☐	CSLXX9	WERTV9	CURR	17	2	Total movements of period in controlling area currency
48	TSL10	☐	CSLXX9	WERTV9	CURR	17	2	Total movements of period in controlling area currency
49	TSL11	☐	CSLXX9	WERTV9	CURR	17	2	Total movements of period in controlling area currency
50	TSL12	☐	CSLXX9	WERTV9	CURR	17	2	Total movements of period in controlling area currency
51	TSL13	☐	CSLXX9	WERTV9	CURR	17	2	Total movements of period in controlling area currency
52	TSL14	☐	CSLXX9	WERTV9	CURR	17	2	Total movements of period in controlling area currency
53	TSL15	☐	CSLXX9	WERTV9	CURR	17	2	Total movements of period in controlling area currency
54	TSL16	☐	CSLXX9	WERTV9	CURR	17	2	Total movements of period in controlling area currency
55	HSLVT	☐	HSLVT9	WERTV9	CURR	17	2	Balance carried forward in local currency
56	HSL01	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
57	HSL02	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
58	HSL03	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
59	HSL04	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
60	HSL05	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
61	HSL06	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
62	HSL07	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
63	HSL08	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
64	HSL09	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
65	HSL10	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
66	HSL11	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
67	HSL12	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
68	HSL13	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
69	HSL14	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
70	HSL15	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
71	HSL16	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
72	KSLVT	☐	KSLVT9	WERTV9	CURR	17	2	Balance carried forward in group currency
73	KSL01	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
74	KSL02	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
75	KSL03	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
76	KSL04	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
77	KSL05	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
78	KSL06	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
79	KSL07	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
80	KSL08	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
81	KSL09	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
82	KSL10	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
83	KSL11	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
84	KSL12	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
85	KSL13	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
86	KSL14	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
87	KSL15	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
88	KSL16	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
89	MSLVT	☐	MSLVT	MENGV8	QUAN	15	3	Balance carried forward of quantity
90	MSL01	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
91	MSL02	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
92	MSL03	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
93	MSL04	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
94	MSL05	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
95	MSL06	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
96	MSL07	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
97	MSL08	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
98	MSL09	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
99	MSL10	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
100	MSL11	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
101	MSL12	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
102	MSL13	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
103	MSL14	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
104	MSL15	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
105	MSL16	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
106	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
107	AUTOM	☐	AUTOM	TEXT1	CHAR	1	0	Indicator: Automatic posting lines
108	DOCTY	☐	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	T889
109	ACTIV	☐	RCL_TRIG	RCL_TRIG	CHAR	4	0	Record type of reconciliation ledger
110	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
111	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
112	REFDOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
113	REFRYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
114	REFDOCLN	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
115	REFDOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
116	REFACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
117	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
118	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
119	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
120	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
121	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
122	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
123	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in