SAP FMDERIVEFUNCID LIST OF FUNCTIONS ASSIGNED TO DERIVATION STRATEGY Table data and field list

FMDERIVEFUNCID is a standard SAP Table which is used to store LIST OF FUNCTIONS ASSIGNED TO DERIVATION STRATEGY data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMDERIVEFUNCID table consists of various fields, each holding specific information or linking keys about LIST OF FUNCTIONS ASSIGNED TO DERIVATION STRATEGY data available in SAP. These include SUBCLASS (Subgroup by Application Class), STRATEGY_ID (Strategy ID), SIGN_RANGE (Type of SIGN component in row type of a Ranges type), OPTION_RANGE (Type of OPTION component in row type of a Ranges type)... 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. .

FMDERIVEFUNCID 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 FMDERIVEFUNCID 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 FMDERIVEFUNCID 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
APPLApplication class for DD objects (not used) APPLCLASSCHAR4Assigned to domainAPPLCLASSAPP
SUBCLASSSubgroup by Application Class ABADRSUBCLASSCHAR2ABADRSUBCLAS
STRATEGY_IDStrategy ID ABADRSTRATIDCHAR4ABADRSTRATID
SIGN_RANGEType of SIGN component in row type of a Ranges type DDSIGNCHAR1DDSIGN
OPTION_RANGEType of OPTION component in row type of a Ranges type DDOPTIONCHAR2DDOPTION
FUNCTION_LOWName of Function Module RS38L_FNAMCHAR30Assigned to domainFUNCNAMELIB
FUNCTION_HIGHName of Function Module RS38L_FNAMCHAR30Assigned to domainFUNCNAMELIB

Key field Non-key field



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

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

SELECT SINGLE *
FROM FMDERIVEFUNCID
INTO CORRESPONDING FIELDS OF WA_FMDERIVEFUNCID
WHERE...

How to access SAP table FMDERIVEFUNCID

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

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