1. SAP Tutorial
  2. SAP PSM

FMDERIVEFUNC SAP table for – List of functions available in the FM Derivation tools

Here we would like to draw your attention to FMDERIVEFUNC table in SAP. As we know it is being mainly used with the SAP PSM-FM (Funds Management in PSM) component which is coming under PSM module (Public Sector Management). FMDERIVEFUNC is a SAP standard transp table used for storing List of functions available in the FM Derivation tools related data in SAP. It comes under the package FMFS_E.

SAP FMDERIVEFUNC table

Table FMDERIVEFUNC technical data

TableFMDERIVEFUNC
Data storingList of functions available in the FM Derivation tools
ModulePSM
Sub ModulePSM-FM
SAP PackageFMFS_E
Delivery ClassS – System table, data changes have the status of program changes
ComponentEA-PS
Table CategoryTRANSP

SAP FMDERIVEFUNC Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FMDERIVEFUNC table.

  • FUNCTION_NAME : Name of Function Module
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • TO_IDENTIFIER : Origin
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • TO_TABNAME : Table Name
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • TO_FIELDNAME : Field Name
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • FIELDCLASS : Characteristic derivation: field class
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • FROM_TABNAME : Table Name
    Its data type is CHAR (Character String) with field length 30
  • FROM_FIELDNAME : Field Name
    Its data type is CHAR (Character String) with field length 30
  • USECONSTANT : Characteristic derivation: use constant
    Its data type is CHAR (Character String) with field length 1
  • CONSTANT : Constant
    Its data type is CHAR (Character String) with field length 60
  • USEOFFSET : Characteristic derivation: use field “Offset”
    Its data type is CHAR (Character String) with field length 1
  • OFFSET_VALUE : Characteristic derivation: field “Offset”
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • OFFSET_LENGTH : Characteristic Derivation: Field, Offset, Length
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • IS_MANDATORY : Indicator for required field
    Its data type is CHAR (Character String) with field length 1
  • IS_PICKABLE : Indicator
    Its data type is CHAR (Character String) with field length 1
  • BLANK_IS_ALLOWED : Indicator
    Its data type is CHAR (Character String) with field length 1
  • OVERWRITE : Indicator
    Its data type is CHAR (Character String) with field length 1
  • NO_VALUE_TEXT : Indicator
    Its data type is CHAR (Character String) with field length 1
  • NO_VALUE_RANGE : Indicator
    Its data type is CHAR (Character String) with field length 1
  • STORE_EXT_FORMAT : Indicator
    Its data type is CHAR (Character String) with field length 1

    • FMDERIVEFUNC related tables

    • FMKAFF_CTRL : FM-CO: Check Mode in FM for CO planning.
    • FM2BLACTC : FM2BL – Activation of Commitment/Actual Value Types
    • FMDERIVE004 : Derivation rule:Order/CE to Commitment Item/Funds Ctr/Fund/F
    • FM2BLACT1 : FM2BL – Activate of FM area and FM Budget Category
    • FMFG_HEAD_INV : Header Data for Improper Invoices
    • FMDERIVE001 : Derivation rule:Cost Element to Commitment Item
    • FMDERIVEFUNCID : LIST OF FUNCTIONS ASSIGNED TO DERIVATION STRATEGY
    • FMDERIVE002 : Derivation rule:Cost Center/CE to Commitment Item/Funds Ctr/
    • FMDERIVEENVID : Assignment Company Code to Derivation Tool Strategy
    • FMBLPSTNG : FM BL posting customizing for GL line-items collection
    • FM2BLTR1 : FM2BL – Define on FM area level
    • FMAC2 : FM to FI – GL Account Assignment
    • FMDERIVE003 : Derivation rule:Cost Center to Commitment Item/Funds Ctr/Fun
    • T023Y : Material Group for Fast Pay
    • FMDERIVE008 : Profit Ctr/CE to Commit Item/Funds Center/Fund/Function
    • FMDERIVE005 : Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func
    • FMTABADR : Characteristic Derivation: Strategies
    • FMSPLITO : Object table 1
    • FMDT_CHANGEDOC : Empty table for change document on DRULE derivation tables
    • FMSPLITT : Summary table

    FMDERIVEFUNC related transaction codes under SAP package FMFS_E

    • FMN3N : Reconstruction of Purch. Requisition
    • FM2BL_DERIVE1 : Derive FM totals transfer to FI
    • FMRULES : FM Objects: Predefined Rules
    • FMTR : FM budgetary ledger trace
    • FM2BL_DERIVE : Derive FM totals transfer to BL
    • OFMTOAC2 : Define Debit/Credit GL in FM to AC
    • FMDERIVE : FM Object Assignment – Customizing
    • FMCOMPARESTRATEGY : Compare Derivation Strategy
    • OFDH : Funds Management: Delete CO Actuals
    • FMRC21 : Reconciliation of Earmarked Funds
    • FMN5N : Reconstruction of Earmarked Funds
    • OFFT : Create FM fund types
    • FMNSDN : Reconstruction of Sales Orders
    • FMPOPDERIVE : Principle of Prudence – Customizing
    • FMDERIVER : FM Object Assignment – Maintenance
    • FMTB : Transfer Commitment/Actuals to FI-BL
    • FMN4N : Reconstruction of Purchase Orders
    • OF39 : Customized update profile
    • FMPOPDERIVER : Principle of Prudence – Maintenance
    • FMOD : Override FM Update Date

    Related References

    Related Tutorials

    FMDERIVEFUNCID SAP table for – LIST OF FUNCTIONS ASSIGNED TO DERIVATION STRATEGY

    FMDERIVEFUNCID table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of LIST OF...

    FMDERIVE005 SAP table for – Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func

    FMDERIVE005 table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Derivation rule:Order...

    FMDERIVE001 SAP table for – Derivation rule:Cost Element to Commitment Item

    FMDERIVE001 table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Derivation rule:Cost...

    FMDERIVE006 SAP table for – Derivation rule:WBS Element/CE to Commitment Item/Funds Ctr/

    FMDERIVE006 table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Derivation rule:WBS...

    FMCOMPARESTRATEGY SAP tcode for – Compare Derivation Strategy

    FMCOMPARESTRATEGY tcode in SAP PSM (Funds Management in PSM) module. This transaction code is used for Compare Derivation Strategy. See...

    FMDERIVE003 SAP table for – Derivation rule:Cost Center to Commitment Item/Funds Ctr/Fun

    FMDERIVE003 table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Derivation rule:Cost...

    FMTABADR SAP table for – Characteristic Derivation: Strategies

    FMTABADR table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Characteristic Derivation:...

    «
    »