CF050

Balance sheet/P&L (FI/FILC) | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
VERSIO FK Version
PLACTI Plan/Act. indicator (EC-EIS/EC-BP) Show values
YEARB Fiscal Year
PERDE Period
VERSO FK Data area (previously version)
CLSCAT FK Consolidation frequency
SUBGRP FK Subgroup
COMPNY FK Company
COMCOD FK Company Code
BUSARE FK Business Area
BSVERS FK Financial Statement Version
SUITEM FK Totals item
LCITEM FK Consolidation item
GLACCT FK G/L Account Number
RECNR CO-BPC record number
Column Name Description
💲 Currency Key (T001.WAERS):
HB1_FI Local valuation value in local currency (FI-GL)
FHB1GC HB-I_Value in group currency (FI-GL)
💲 Local Currency (T880.CURR):
HB1_LC Local value in local currency (FI-LC)
HB2_LC Corporate value in local currency (FI-LC)
💲 Currency key for the group currency (T852V.RCURR):
HB1_GC Local value in group currency (FI-LC)
HB2_GC Corporate value in group currency (FI-LC)
HB3_GC Consolidated value (FI-LC)
Column Name Description
📏 Unit (QUANTY_UNI):
QUANTY Quantity
Column Name Description
AEDTM Changed On
Column Name Description
PLACTI Plan/Act. indicator (EC-EIS/EC-BP) Show values
Column Name Description Domain name
UNAME User name CHAR12
FSTAKY Financial Statement Item ERGSL
Master Data Relations Join Conditions
Fin.stmt vers.
  • Financial Statement Version
  • Client
  • CF050.BSVERS == T011.VERSN
  • CF050.MANDT == T011.MANDT
Business area
  • CF050.MANDT == TGSB.MANDT
  • CF050.BUSARE == TGSB.GSBER
Chart of accounts
  • Chart of Accounts
  • Client
  • CF050.CHACCT == T004.KTOPL
  • CF050.MANDT == T004.MANDT
Consolidation frequency
  • CF050.MANDT == T852N.MANDT
  • CF050.CLSCAT == T852N.FSCAT
Company code
  • CF050.MANDT == T001.MANDT
  • CF050.COMCOD == T001.BUKRS
Currency
  • CF050.MANDT == TCURC.MANDT
  • CF050.COMCOD_WAERS == TCURC.WAERS
Company
  • CF050.MANDT == T880.MANDT
  • CF050.COMPNY == T880.RCOMP
Currency
  • CF050.MANDT == TCURC.MANDT
  • CF050.COMPNY_CURR == TCURC.WAERS
Country
  • Company Country/Region
  • Client
  • CF050.COUNTR == T005.LAND1
  • CF050.MANDT == T005.MANDT
G/L account
  • Chart of Accounts
  • Client
  • G/L Account Number
  • CF050.CHACCT == SKA1.KTOPL
  • CF050.MANDT == SKA1.MANDT
  • CF050.GLACCT == SKA1.SAKNR
Item
  • CF050.MANDT == T854.MANDT
  • CF050.LCITEM == T854.ITEM
Cons. version
  • CF050.MANDT == T858.MANDT
  • CF050.LCVERS == T858.RVERS
Client CF050.MANDT == T000.MANDT
Trans.type grp
  • CF050.MANDT == T856X.MANDT
  • CF050.MVCTGP == T856X.RWGRP
Unit
  • CF050.MANDT == T006.MANDT
  • CF050.QUANTY_UNI == T006.MSEHI
Totals item
  • CF050.MANDT == T854.MANDT
  • CF050.SUITEM == T854.ITEM
Currency
  • CF050.MANDT == TCURC.MANDT
  • CF050.T852V_RCURR == TCURC.WAERS
Value type
  • CF050.MANDT == T242W.MANDT
  • CF050.VALTY == T242W.VALTY
Version
  • CF050.MANDT == TKCVS.MANDT
  • CF050.VERSIO == TKCVS.VERSIO
Data area
  • Data area (previously version)
  • Client
  • CF050.VERSO == T242V.VERSO
  • CF050.MANDT == T242V.MANDT
Currency
  • CF050.MANDT == TCURC.MANDT
  • CF050.VERSO_WAERS == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Subgroup
  • Subgroup
  • Client
  • CF050.SUBGRP == T852.RSUBD
  • CF050.MANDT == T852.MANDT