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

SAP table CF050 has 16 primary key fields being MANDT,VERSIO,PLACTI,YEARB,PERDE,VERSO,CLSCAT,SUBGRP,COMPNY,COMCOD,BUSARE,BSVERS,SUITEM,LCITEM,GLACCT,RECNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

CF050 foreign key relationships

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