Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

TF140 SAP (Selected FS Items) Table details

Dictionary Type: Table
Description: Selected FS Items

ABAP Code to SELECT data from TF140
Related tables to TF140
Access table TF140

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

Table field list including key, data, relationships and ABAP select examples

TF140 is a standard SAP Table which is used to store Selected FS Items data and is available within R/3 SAP systems depending on the version and release level.

The TF140 table consists of various fields, each holding specific information or linking keys about Selected FS Items data available in SAP. These include RVERS (Version: Selected FS items), ITCLG (Consolidation chart of accounts), ITBG (Item for retained earnings on the balance sheet), SITYP_BG (Subitem category).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP TF140 table fields - Full list of fields found in SAP data dictionary

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
RVERS	Version: Selected FS items	FC_FIXVS	CHAR	3	TF212	ALPHA	FC_FIXVS		FC_FIXVS
ITCLG	Consolidation chart of accounts	FC_ITCLG	CHAR	2	TF120		FC_ITCLG	ITC	FC_ITCLG
ITBG	Item for retained earnings on the balance sheet	FC_ITBG	CHAR	10	TF100	BFIMC	FC_ITEM
SITYP_BG	Subitem category	FC_SITYP	CHAR	3	TF110		FC_SITYP	STP	FC_SITYP
SITEM_BG	Subitem	FC_SITEM	CHAR	10	TF115		FC_SITEM	STM
ITERG	Item for retained earnings on the income statement	FC_ITERG	CHAR	10	TF100	BFIMC	FC_ITEM
SITYP_ERG	Subitem category	FC_SITYP	CHAR	3	TF110		FC_SITYP	STP	FC_SITYP
SITEM_ERG	Subitem	FC_SITEM	CHAR	10	TF115		FC_SITEM	STM
ITLABD	Balance sheet item for deferred income taxes (debit)	FC_ITLABD	CHAR	10	TF100	BFIMC	FC_ITEM
SITYP_LABD	Subitem category	FC_SITYP	CHAR	3	TF110		FC_SITYP	STP	FC_SITYP
SITEM_LABD	Subitem	FC_SITEM	CHAR	10	TF115		FC_SITEM	STM
ITLABC	B/S item for provisions for deferred income taxes (credit)	FC_ITLABC	CHAR	10	TF100	BFIMC	FC_ITEM
SITYP_LABC	Subitem category	FC_SITYP	CHAR	3	TF110		FC_SITYP	STP	FC_SITYP
SITEM_LABC	Subitem	FC_SITEM	CHAR	10	TF115		FC_SITEM	STM
ITLAGD	Income statement item: Deferred taxes (debit)	FC_ITLAGD	CHAR	10	TF100	BFIMC	FC_ITEM
SITYP_LAGD	Subitem category	FC_SITYP	CHAR	3	TF110		FC_SITYP	STP	FC_SITYP
SITEM_LAGD	Subitem	FC_SITEM	CHAR	10	TF115		FC_SITEM	STM
ITLAGC	Income statement item: deferred income taxes (credit)	FC_ITLAGC	CHAR	10	TF100	BFIMC	FC_ITEM
SITYP_LAGC	Subitem category	FC_SITYP	CHAR	3	TF110		FC_SITYP	STP	FC_SITYP
SITEM_LAGC	Subitem	FC_SITEM	CHAR	10	TF115		FC_SITEM	STM
CFWDIT	Unappr.retained earnings carryforward item (debit)	FC_CFWDIT	CHAR	10	TF100	BFIMC	FC_ITEM
CFWDST	Subitem category	FC_CFWDST	CHAR	3	TF110		FC_SITYP
CFWDSI	Subitem - debit	FC_CFWDSI	CHAR	10	TF115		FC_SITEM
CFWCIT	Unappr.retained earnings carryforward item(credit)	FC_CFWCIT	CHAR	10	TF100	BFIMC	FC_ITEM
CFWCST	Subitem category	FC_CFWCST	CHAR	3	TF110		FC_SITYP
CFWCSI	Subitem - credit	FC_CFWCSI	CHAR	10	TF115		FC_SITEM
NISTAT	Annual net income - statistical item	FC_NISTAT	CHAR	10	TF100	BFIMC	FC_ITEM
NICONT	Annual net income - offsetting item	FC_NICONT	CHAR	10	TF100	BFIMC	FC_ITEM
MISTAT	Minority interest in ANI - statistical item	FC_MISTAT	CHAR	10	TF100	BFIMC	FC_ITEM
MICONT	Minority interest in ANI - offsetting item	FC_MICONT	CHAR	10	TF100	BFIMC	FC_ITEM
NISADJ	Statistical item for adjusted annual net income	FC_NISADJ	CHAR	10	TF100	BFIMC	FC_ITEM
MISADJ	Statistical item for minority interest in adjusted ANI	FC_MISADJ	CHAR	10	TF100	BFIMC	FC_ITEM
NISADJGW	Adjusted Annual Net Income, Statistical (Goodwill)	FC_NISADJGW	CHAR	10	TF100	BFIMC	FC_ITEM
MISADJGW	Minority Int. in Annual Net Income, Statistical (Goodwill)	FC_MISADJGW	CHAR	10	TF100	BFIMC	FC_ITEM
NISADJEQ	Adjusted Annual Net Income, Statistical (Equity Method)	FC_NISADJEQ	CHAR	10	TF100	BFIMC	FC_ITEM
MISADJEQ	Minority Int. in Annual Net Income, Statistical (Equity M.)	FC_MISADJEQ	CHAR	10	TF100	BFIMC	FC_ITEM
NIAPUA	Annual Net Income from Push-down Method, Statistical Item	FC_NIAPUA	CHAR	10	TF100	BFIMC	FC_ITEM
MIAPUA	Minority Interest in ANI, Push-down Method, Statistical Item	FC_MIAPUA	CHAR	10	TF100	BFIMC	FC_ITEM
GECONT	Overall statistical offsetting item	FC_GECONT	CHAR	10	TF100	BFIMC	FC_ITEM
TOTANI	Totals item for appropriation of retained earnings	FC_TOTANI	CHAR	10	TF100	BFIMC	FC_ITEM
NIPRFC	'Annual net income prior to first consolidation' item	FC_NIPRFC	CHAR	10	TF100	BFIMC	FC_ITEM
NIPRCP	FS item: Annual net income prior to proportion change	FC_NIPRCP	CHAR	10	TF100	BFIMC	FC_ITEM
NIPU	Annual Net Income Item for Push-down Method	FC_NIPU	CHAR	10	TF100	BFIMC	FC_ITEM
NIOC	Annual Net Income Item, Organizational Change	FC_NIOC	CHAR	10	TF100	BFIMC	FC_ITEM
NIMC	Annual Net Income Item for Method Change	FC_NIMC	CHAR	10	TF100	BFIMC	FC_ITEM
NIMERG	Net Income Item for Merger	FC_NIMERG	CHAR	10	TF100	BFIMC	FC_ITEM
NIDEMG	Net Income Item for Demerger	FC_NIDEMG	CHAR	10	TF100	BFIMC	FC_ITEM
NIDIVP	Net Income Item for Partial Divestitures	FC_NIDIVP	CHAR	10	TF100	BFIMC	FC_ITEM
APPRMDI	Item: Transfers to Minority Interest	FC_APPRMDI	CHAR	10	TF100	BFIMC	FC_ITEM
APPRMDT	Subitem Category: Transfers to Minority Interest	FC_APPRMDT	CHAR	3	TF110		FC_SITYP
APPRMDS	Subitem: Transfers to Minority Interest, Debit	FC_APPRMDS	CHAR	10	TF115		FC_SITEM
APPRMCT	Subitem Category: Transfers to Minority Interest	FC_APPRMCT	CHAR	3	TF110		FC_SITYP
APPRMCS	Subitems Transfers to Minority Interest Credit	FC_APPRMCS	CHAR	10	TF115		FC_SITEM
TRANMD	Item for transfers to minority interest in ret.earnings	FC_TRANMD	CHAR	10	TF100	BFIMC	FC_ITEM
TRANMC	Item: Deductions from min.int. in ret. earnings	FC_TRANMC	CHAR	10	TF100	BFIMC	FC_ITEM
ELICOI	Item: clearing of consolidation of investments	FC_ELICOI	CHAR	10	TF100	BFIMC	FC_ITEM
ELICOT	Subitem category: Clearing of consolidation of investments	FC_ELICOT	CHAR	3	TF110		FC_SITYP
ELICDS	Subitem: Clearing of consolidation of investments - debit	FC_ELICDS	CHAR	10	TF115		FC_SITEM
ELICCS	Subitem: Clearing of consolidation of investments - credit	FC_ELICCS	CHAR	10	TF115		FC_SITEM
HRMINIT	Item for minority interest in hidden reserves	FC_HRMINIT	CHAR	10	TF100	BFIMC	FC_ITEM
DIVSTDI	FS item: Losses from divestitures	FC_DIVSTDI	CHAR	10	TF100	BFIMC	FC_ITEM
DIVSTDT	Subitem category: Losses from divestitures	FC_DIVSTDT	CHAR	3	TF110		FC_SITYP
DIVSTDS	Subitem: Losses from divestitures	FC_DIVSTDS	CHAR	10	TF115		FC_SITEM
DIVSTCI	FS item: Gains from divestitures	FC_DIVSTCI	CHAR	10	TF100	BFIMC	FC_ITEM
DIVSTCT	Subitem category: Gains from divestitures	FC_DIVSTCT	CHAR	3	TF110		FC_SITYP
DIVSTCS	Subitem: Gains from divestitures	FC_DIVSTCS	CHAR	10	TF115		FC_SITEM
DIVEQDI	FS item for divestiture expense from equity method	FC_DIVEQDI	CHAR	10	TF100	BFIMC	FC_ITEM
DIVEQDT	Subitem category for divestiture expense from equity method	FC_DIVEQDT	CHAR	3	TF110		FC_SITYP
DIVEQDS	Subitem for divestiture expense from equity method	FC_DIVEQDS	CHAR	10	TF115		FC_SITEM
DIVEQCI	FS item for divestiture revenue from equity method	FC_DIVEQCI	CHAR	10	TF100	BFIMC	FC_ITEM
DIVEQCT	Subitem category for divestiture revenue from equity method	FC_DIVEQCT	CHAR	3	TF110		FC_SITYP
DIVEQCS	Subitem for divestiture revenue from equity method	FC_DIVEQCS	CHAR	10	TF115		FC_SITEM
DIVMIDI	Item: Expense for divestitures, minority share	FC_DIVMIDI	CHAR	10	TF100	BFIMC	FC_ITEM
DIVMIDT	Subitem category: Minority share of losses from divestitures	FC_DIVMIDT	CHAR	3	TF110		FC_SITYP
DIVMIDS	Subitem: Minority share of losses from divestitures	FC_DIVMIDS	CHAR	10	TF115		FC_SITEM
DIVMICI	Item: Revenue from divestitures, minority share	FC_DIVMICI	CHAR	10	TF100	BFIMC	FC_ITEM
DIVMICT	Subitem category: Minority share of gains from divestitures	FC_DIVMICT	CHAR	3	TF110		FC_SITYP
DIVMICS	Subitem: Minority share of gains from divestitures	FC_DIVMICS	CHAR	10	TF115		FC_SITEM
DIVITEM	Clearing item for transaction currency difference split	FC_DIVITEM	CHAR	10	TF100	BFIMC	FC_ITEM
GPCNT1	FS item for group share	FC_GPCNT1I	CHAR	10	TF100	BFIMC	FC_ITEM
GPCNT2	FS item for group share in voting stock	FC_GPCNT2I	CHAR	10	TF100	BFIMC	FC_ITEM
GPCNT3	Item for group share in non-voting stock	FC_GPCNT3I	CHAR	10	TF100	BFIMC	FC_ITEM
GPCNT4	Item for group share in annual net income	FC_GPCNT4I	CHAR	10	TF100	BFIMC	FC_ITEM
GPCNT5	Item for group share - direct investment	FC_GPCNT5I	CHAR	10	TF100	BFIMC	FC_ITEM
INVEXT	Third-party Investment	FC_INVEXT	CHAR	10	TF100	BFIMC	FC_ITEM
FGWBEG	Full Goodwill at Beginning of Period	FC_FGWBEG	CHAR	10	TF100	BFIMC	FC_ITEM
FGWEND	Full Goodwill at End of Period	FC_FGWEND	CHAR	10	TF100	BFIMC	FC_ITEM
GWRESI	Item: Appropriations for Goodwill	FC_GWRESI	CHAR	10	TF100	BFIMC	FC_ITEM
GWREST	Subitem Category: Appropriations for Goodwill	FC_GWREST	CHAR	3	TF110		FC_SITYP
GWRESS	Subitem: Appropriations for Goodwill	FC_GWRESS	CHAR	10	TF115		FC_SITEM
GWTADI	Item: Currency Translation for Goodwill	FC_GWTADI	CHAR	10	TF100	BFIMC	FC_ITEM
GWTADT	Subitem Category: Currency Translation for Goodwill	FC_GWTADT	CHAR	3	TF110		FC_SITYP
GWTADS	Subitem: Currency Translation for Goodwill	FC_GWTADS	CHAR	10	TF115		FC_SITEM
NIGWAQI	Item for goodwill accum.amortization item/neg. inv. BV	FC_NIGWAQI	CHAR	10	TF100	BFIMC	FC_ITEM
NIGWAQT	Subitem cat. goodwill accum.amortization/neg. investment BV	FC_NIGWAQT	CHAR	3	TF110		FC_SITYP
NIGWAQS	Subitem goodwill accum.amortization/negative investment BV	FC_NIGWAQS	CHAR	10	TF115		FC_SITEM
NIGWAMI	Goodwill amortization item / negative investment book value	FC_NIGWAMI	CHAR	10	TF100	BFIMC	FC_ITEM
NIGWAMT	SI cat. for goodwill amortization/neg. investment book value	FC_NIGWAMT	CHAR	3	TF110		FC_SITYP
NIGWAMS	Subitem for Goodwill amortization/neg. investement bookvalue	FC_NIGWAMS	CHAR	10	TF115		FC_SITEM
ITBAG	Balancing adjustment item for bus. area/profit center cons	FC_ITBAG	CHAR	10	TF100	BFIMC	FC_ITEM
PIWDI	Item for Investment Amortization	FC_PIWDI	CHAR	10	TF100	BFIMC	FC_ITEM
PIWDT	Subitem Category for Investment Amortization	FC_PIWDT	CHAR	3	TF110		FC_SITYP
PIWDS	Subitem for Investment Amortization	FC_PIWDS	CHAR	10	TF115		FC_SITEM
PIWUI	Item for Investment Writeup	FC_PIWUI	CHAR	10	TF100	BFIMC	FC_ITEM
PIWUT	Subitem Category for Investment Writeup	FC_PIWUT	CHAR	3	TF110		FC_SITYP
PIWUS	Subitem for Investment Writeup	FC_PIWUS	CHAR	10	TF115		FC_SITEM
LDTEQI	Equity Item for Legacy Data Transfer	FC_LDTEQI	CHAR	10	TF100	BFIMC	FC_ITEM
LDTEQT	Subitem Category for Legacy Data Transfer	FC_LDTEQT	CHAR	3	TF110		FC_SITYP
LDTEQS	Subitem for Legacy Data Transfer	FC_LDTEQS	CHAR	10	TF115		FC_SITEM

Key field

Non-key field

How do I retrieve data from SAP table TF140 using ABAP code

The following ABAP code Example will allow you to do a basic selection on TF140 to SELECT all data from the table
DATA: WA_TF140 TYPE TF140.

SELECT SINGLE *
FROM TF140
INTO CORRESPONDING FIELDS OF WA_TF140
WHERE...

How to access SAP table TF140

Within an ECC or HANA version of SAP you can also view further information about TF140 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Search for further information about these or an SAP related objects

Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!