SAP ABAP Table CF050 (Balance sheet/P&L (FI/FILC))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ KC (Package) Cost Accounting Controlling EIS

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CF050	Table Relationship Diagram
Short Description	Balance sheet/P&L (FI/FILC)

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VERSIO	☑	CFVERSION	CFVERSION	CHAR	3	0	Version	TKCVS
3	PLACTI	☑	CFPLACT	CFPLACT	CHAR	1	0	Plan/Act. indicator (EC-EIS/EC-BP)
4	YEARB	☑	CFYEARB	GJAHR	NUMC	4	0	Fiscal Year
5	PERDE	☑	CFPERDE	POPER	NUMC	3	0	Period
6	VERSO	☑	CFVERSO	VERSO	NUMC	2	0	Data area (previously version)	T242V
7	CLSCAT	☑	FSCAT	FSCAT	CHAR	1	0	Consolidation frequency	T852N
8	SUBGRP	☑	RSUBD	RSUBD	CHAR	3	0	Subgroup	T852
9	COMPNY	☑	RCOMP_D	RCOMP	CHAR	6	0	Company	T880
10	COMCOD	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
11	BUSARE	☑	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
12	BSVERS	☑	VERSN_011	VERSN_011	CHAR	4	0	Financial Statement Version	T011
13	SUITEM	☑	SUMITEM	RITEM	CHAR	10	0	Totals item	T854
14	LCITEM	☑	RITEM	RITEM	CHAR	10	0	Consolidation item	T854
15	GLACCT	☑	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
16	RECNR	☑	CFRECNR	NUM8	NUMC	8	0	CO-BPC record number
17	AEDTM	☐	CFAEDTM	CFDATUM	DATS	8	0	Changed On
18	UNAME	☐	CFUNAME	CHAR12	CHAR	12	0	User name
19	VALTY	☐	CFVALTY	VALTY	CHAR	1	0	Value type	T242W
20	MVCTGP	☐	RWGRP_D	RWGRP	CHAR	3	0	Transaction type group	T856X
21	LCVERS	☐	RVERS_LC	RVERS_GC	CHAR	3	0	Consolidation version	T858
22	COUNTR	☐	LAND	LAND1	CHAR	3	0	Country of company	T005
23	CHACCT	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	T004
24	FSTAKY	☐	ERGSL	ERGSL	CHAR	10	0	Financial Statement Item
25	COMCOD_WAERS	☐	RKCG_CUKY	WAERS	CUKY	5	0	Currency	TCURC
26	COMPNY_CURR	☐	RKCG_CUKY	WAERS	CUKY	5	0	Currency	TCURC
27	T852V_RCURR	☐	RKCG_CUKY	WAERS	CUKY	5	0	Currency	TCURC
28	VERSO_WAERS	☐	RKCG_CUKY	WAERS	CUKY	5	0	Currency	TCURC
29	HB1_FI	☐	FI_HB1LC	VALUE8	CURR	15	2	Local valuation value in local currency (FI-GL)
30	HB1_LC	☐	LC_HB1LC	WERTV9	CURR	17	2	Local value in local currency (FI-LC)
31	HB1_GC	☐	LC_HB1GC	WERTV9	CURR	17	2	Local value in group currency (FI-LC)
32	HB2_LC	☐	LC_HB2LC	WERTV9	CURR	17	2	Corporate value in local currency (FI-LC)
33	HB2_GC	☐	LC_HB2GC	WERTV9	CURR	17	2	Corporate value in group currency (FI-LC)
34	HB3_GC	☐	LC_HB3GC	WERTV9	CURR	17	2	Consolidated value (FI-LC)
35	QUANTY	☐	RKCSQUANTY	RKCG_QUAN	QUAN	15	3	Quantity
36	QUANTY_UNI	☐	RKCG_UNIT	MEINS	UNIT	3	0	Unit	T006
37	FHB1GC	☐	FI_HB1GC	VALUE8	CURR	15	2	HB-I_Value in group currency (FI-GL)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CF050	BSVERS	T011	VERSN	KEY	1	CN
2	CF050	BUSARE	TGSB	GSBER	KEY	1	CN
3	CF050	CHACCT	T004	KTOPL	REF	C	CN
4	CF050	CLSCAT	T852N	FSCAT	KEY	1	CN
5	CF050	COMCOD	T001	BUKRS	KEY	1	CN
6	CF050	COMCOD_WAERS	TCURC	WAERS	REF	C	CN
7	CF050	COMPNY	T880	RCOMP	KEY	1	CN
8	CF050	COMPNY_CURR	TCURC	WAERS	REF	C	CN
9	CF050	COUNTR	T005	LAND1	REF	C	CN
10	CF050	GLACCT	SKA1	SAKNR	KEY	1	CN
11	CF050	LCITEM	T854	ITEM	KEY	1	CN
12	CF050	LCVERS	T858	RVERS	REF	C	CN
13	CF050	MANDT	T000	MANDT	KEY	1	CN
14	CF050	MVCTGP	T856X	RWGRP	REF	C	CN
15	CF050	QUANTY_UNI	T006	MSEHI	REF	C	CN
16	CF050	SUBGRP	T852	RSUBD	KEY	1	CN
17	CF050	SUITEM	T854	ITEM	KEY	1	CN
18	CF050	T852V_RCURR	TCURC	WAERS	REF	C	CN
19	CF050	VALTY	T242W	VALTY	REF	C	CN
20	CF050	VERSIO	TKCVS	VERSIO	KEY	1	CN
21	CF050	VERSO	T242V	VERSO	KEY	1	CN
22	CF050	VERSO_WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in