1. Home
  2. Resources
  3. SAP Tables
  4. CF050 - Balance sheet/P&L (FI/FILC)

SAP Table CF050

Balance sheet/P&L (FI/FILC)

CF050 (Balance sheet/P&L (FI/FILC)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CF050 to other SAP tables.

CF050 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VERSIO Version CFVERSION TKCVS CHAR 3 0
PLACTI Plan/Act. indicator (EC-EIS/EC-BP) CFPLACT CHAR 1 0
0 Actual data
1 Plan data
YEARB Fiscal Year CFYEARB NUMC 4 0
PERDE Period CFPERDE NUMC 3 0
VERSO Data area (previously version) CFVERSO T242V NUMC 2 0
CLSCAT Consolidation frequency FSCAT T852N CHAR 1 0
SUBGRP Subgroup RSUBD T852 CHAR 3 0
COMPNY Company RCOMP_D T880 CHAR 6 0
COMCOD Company Code BUKRS T001 CHAR 4 0
BUSARE Business Area GSBER TGSB CHAR 4 0
BSVERS Financial Statement Version VERSN_011 T011 CHAR 4 0
SUITEM Totals item SUMITEM T854 CHAR 10 0
LCITEM Consolidation item RITEM T854 CHAR 10 0
GLACCT G/L Account Number SAKNR SKA1 CHAR 10 0
RECNR CO-BPC record number CFRECNR NUMC 8 0
AEDTM Changed On CFAEDTM DATS 8 0
UNAME User name CFUNAME CHAR 12 0
VALTY Value type CFVALTY T242W CHAR 1 0
MVCTGP Transaction type group RWGRP_D T856X CHAR 3 0
LCVERS Consolidation version RVERS_LC T858 CHAR 3 0
COUNTR Country of company LAND T005 CHAR 3 0
CHACCT Chart of Accounts KTOPL T004 CHAR 4 0
FSTAKY Financial Statement Item ERGSL CHAR 10 0
COMCOD_WAERS Currency RKCG_CUKY TCURC CUKY 5 0
COMPNY_CURR Currency RKCG_CUKY TCURC CUKY 5 0
T852V_RCURR Currency RKCG_CUKY TCURC CUKY 5 0
VERSO_WAERS Currency RKCG_CUKY TCURC CUKY 5 0
HB1_FI Local valuation value in local currency (FI-GL) FI_HB1LC CURR 15 2
HB1_LC Local value in local currency (FI-LC) LC_HB1LC CURR 17 2
HB1_GC Local value in group currency (FI-LC) LC_HB1GC CURR 17 2
HB2_LC Corporate value in local currency (FI-LC) LC_HB2LC CURR 17 2
HB2_GC Corporate value in group currency (FI-LC) LC_HB2GC CURR 17 2
HB3_GC Consolidated value (FI-LC) LC_HB3GC CURR 17 2
QUANTY Quantity RKCSQUANTY QUAN 15 3
QUANTY_UNI Unit RKCG_UNIT T006 UNIT 3 0
FHB1GC HB-I_Value in group currency (FI-GL) FI_HB1GC CURR 15 2

CF050 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CF050 BSVERS CF050 MANDT T011 Financial Statement Versions MANDT
CF050 BSVERS CF050 BSVERS T011 Financial Statement Versions VERSN
CF050 BUSARE CF050 BUSARE TGSB Business Areas GSBER
CF050 BUSARE CF050 MANDT TGSB Business Areas MANDT
CF050 CHACCT CF050 MANDT T004 Directory of Charts of Accounts MANDT
CF050 CHACCT CF050 CHACCT T004 Directory of Charts of Accounts KTOPL
CF050 CLSCAT CF050 MANDT T852N Consolidation frequencies MANDT
CF050 CLSCAT CF050 CLSCAT T852N Consolidation frequencies FSCAT
CF050 COMCOD CF050 MANDT T001 Company Codes MANDT
CF050 COMCOD CF050 COMCOD T001 Company Codes BUKRS
CF050 COMCOD_WAERS CF050 MANDT TCURC Currency Codes MANDT
CF050 COMCOD_WAERS CF050 COMCOD_WAERS TCURC Currency Codes WAERS
CF050 COMPNY CF050 MANDT T880 Global Company Data (for KONS Ledger) MANDT
CF050 COMPNY CF050 COMPNY T880 Global Company Data (for KONS Ledger) RCOMP
CF050 COMPNY_CURR CF050 MANDT TCURC Currency Codes MANDT
CF050 COMPNY_CURR CF050 COMPNY_CURR TCURC Currency Codes WAERS
CF050 COUNTR CF050 COUNTR T005 Countries LAND1
CF050 COUNTR CF050 MANDT T005 Countries MANDT
CF050 GLACCT CF050 MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
CF050 GLACCT CF050 CHACCT SKA1 G/L Account Master (Chart of Accounts) KTOPL
CF050 GLACCT CF050 GLACCT SKA1 G/L Account Master (Chart of Accounts) SAKNR
CF050 LCITEM CF050 MANDT T854 Financial statement items for consolidation MANDT
CF050 LCITEM CF050 LCITEM T854 Financial statement items for consolidation ITEM
CF050 LCVERS CF050 MANDT T858 Consolidation versions MANDT
CF050 LCVERS CF050 LCVERS T858 Consolidation versions RVERS
CF050 MANDT CF050 MANDT T000 Clients MANDT
CF050 MVCTGP CF050 MANDT T856X Transaction type groups MANDT
CF050 MVCTGP CF050 MVCTGP T856X Transaction type groups RWGRP
CF050 QUANTY_UNI CF050 MANDT T006 Units of Measurement MANDT
CF050 QUANTY_UNI CF050 QUANTY_UNI T006 Units of Measurement MSEHI
CF050 SUBGRP CF050 MANDT T852 Subgroups MANDT
CF050 SUBGRP CF050 SUBGRP T852 Subgroups RSUBD
CF050 SUITEM CF050 SUITEM T854 Financial statement items for consolidation ITEM
CF050 SUITEM CF050 MANDT T854 Financial statement items for consolidation MANDT
CF050 T852V_RCURR CF050 MANDT TCURC Currency Codes MANDT
CF050 T852V_RCURR CF050 T852V_RCURR TCURC Currency Codes WAERS
CF050 VALTY CF050 MANDT T242W Value types MANDT
CF050 VALTY CF050 VALTY T242W Value types VALTY
CF050 VERSIO CF050 MANDT TKCVS Version table (EC-EIS) MANDT
CF050 VERSIO CF050 VERSIO TKCVS Version table (EC-EIS) VERSIO
CF050 VERSO CF050 MANDT T242V Data area (previously version) MANDT
CF050 VERSO CF050 VERSO T242V Data area (previously version) VERSO
CF050 VERSO_WAERS CF050 MANDT TCURC Currency Codes MANDT
CF050 VERSO_WAERS CF050 VERSO_WAERS TCURC Currency Codes WAERS