SAP FMDERIVEFUNC List of functions available in the FM Derivation tools Table data and field list

FMDERIVEFUNC is a standard SAP Table which is used to store List of functions available in the FM Derivation tools data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMDERIVEFUNC table consists of various fields, each holding specific information or linking keys about List of functions available in the FM Derivation tools data available in SAP. These include TO_IDENTIFIER (Origin), TO_TABNAME (Table Name), TO_FIELDNAME (Field Name), FIELDCLASS (Characteristic derivation: field class)... 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. .

FMDERIVEFUNC table Technical Details:

Delivery Class: S - System table, maint. only by SAP, change = modification
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FMDERIVEFUNC table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
FUNCTION_NAME	Name of Function Module	RS38L_FNAM	CHAR	30	Assigned to domain		FUNCNAME	LIB
TO_IDENTIFIER	Origin	ABADRIDENT	CHAR	32			ABADRIDENT
TO_TABNAME	Table Name	TABNAME	CHAR	30	Assigned to domain		AS4TAB	DTB
TO_FIELDNAME	Field Name	FIELDNAME	CHAR	30	Assigned to domain		FDNAME	DFD
FIELDCLASS	Characteristic derivation: field class	ABADRFIELDCLASS	CHAR	1			ABADRFIELDCLASS
FROM_TABNAME	Table Name	TABNAME	CHAR	30	Assigned to domain		AS4TAB	DTB
FROM_FIELDNAME	Field Name	FIELDNAME	CHAR	30	Assigned to domain		FDNAME	DFD
USECONSTANT	Characteristic derivation: use constant	ABADRFLAGCONSTANT	CHAR	1			ABADRFLAG
CONSTANT	Constant	ABADRCONSTANT	CHAR	60			ABARPARAM
USEOFFSET	Characteristic derivation: use field 'Offset'	ABADRFLAGOFFSET	CHAR	1			ABADRFLAG
OFFSET_VALUE	Characteristic derivation: field 'Offset'	ABADROFFSET	NUMC	4			ABADRSEQNO
OFFSET_LENGTH	Characteristic Derivation: Field, Offset, Length	ABADRLENGTH	NUMC	4			ABADRSEQNO
IS_MANDATORY	Indicator for required field	ABADRMANDATORY	CHAR	1			ABADRFLAG
IS_PICKABLE	Indicator	ABADRFLAG	CHAR	1			ABADRFLAG
BLANK_IS_ALLOWED	Indicator	ABADRFLAG	CHAR	1			ABADRFLAG
OVERWRITE	Indicator	ABADRFLAG	CHAR	1			ABADRFLAG
NO_VALUE_TEXT	Indicator	ABADRFLAG	CHAR	1			ABADRFLAG
NO_VALUE_RANGE	Indicator	ABADRFLAG	CHAR	1			ABADRFLAG
STORE_EXT_FORMAT	Indicator	ABADRFLAG	CHAR	1			ABADRFLAG

Key field

Non-key field

< FMDERIVEENVID - Assignment Company Code to Derivation Tool Strategy FMDERIVEFUNCID - LIST OF FUNCTIONS ASSIGNED TO DERIVATION STRATEGY >

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

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

SELECT SINGLE *
FROM FMDERIVEFUNC
INTO CORRESPONDING FIELDS OF WA_FMDERIVEFUNC
WHERE...

How to access SAP table FMDERIVEFUNC

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

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