SAP ABAP Reports and Programs

Share |

RFFMDLFM SAP Report - Deleting Actual Data and Commitment Data in FM

RFFMDLFM is a standard ABAP report available within your SAP system (depending on your version and release level). Below is the standard documentation available for this report and a few details of other objects it interacts with such as tables, function modules, includes etc. If you would like to see the full code listing simply enter RFFMDLFM into the relevant SAP transaction such as SE38 or SE80

Although this basic information may have limited use other that for reference, within the comments section below there is also an opportunity for anyone to add useful hints, information and links to existing content specific to this abap report. This page will therfore over time start to contain a useful amount of information that can be found quickly, simply by searching on the object name, RFFMDLFM.

SAP Documentation for program RFFMDLFM

Transaction Code(s):

Below is a list of transaction codes which are relevant to this SAP report

FM_DLFM - Deletes all FM Data (fast)

Deleting Commitment and Actual Data in Funds Management

This program deletes all commitment and actual data in Funds Management for an FM area. It deletes line items and totals records.
You should only use this program in the test phase or if you want to delete data for an FM area. If you only want to delete individual documents or data of a particular fiscal year, you can use programs RFFMDLFI and RFFMDLOI.
Note: This program also deletes the data for business trip commitments (value type 52). However, there is no SAP program available at the moment for reconstructing this data.

The program resets the following tables:
  • FMIOI (commitment documents in Funds Management)

  • FMIOICCN (locked entries marked for the commitment in Funds Management)
  • Note: This table is only relevant for the Netherlands
  • FMIFIHD (FI header table Funds Management)

  • FMIFIIT (FI line item table Funds Management)

  • FMIT (totals table for Funds Management)

  • If a BW system is connected this OLTP system, the line items for the InfoSourcen "0PU_IS_PS_31" and "0PU_IS_PS_32" are also deleted in BW.

    Includes used within report:

    No INCLUDES are used within this report code!

    Tables used within report and the associated select statement:

    FMIFIIT select mandt fmbelnr fikrs fmbuzei btart rldnr gjahr stunr from fmifiit up to g_pack_size rows into table l_t_fmifiit_key where fikrs = p_fikrs. "#EC CI_NOFIRST

    FMIFIHD select mandt fmbelnr fikrs from fmifihd up to g_pack_size rows into table l_t_fmifihd_key where fikrs = p_fikrs. "#EC CI_NOFIRST

    FMIOI select mandt refbn refbt rforg rfpos rfknt rfete rcond rftyp rfsys btart rldnr gjahr stunr from fmioi up to g_pack_size rows into table l_t_fmioi_key where fikrs = p_fikrs. "#EC CI_NOFIELD

    FMIT select rclnt rldnr rrcty rvers ryear robjnr cobjnr sobjnr rtcur rpmax from fmit up to g_pack_size rows into table l_t_fmit_key where rldnr in ('9A','9B','9D') and rrcty = '0' and rvers = '000' and fikrs = p_fikrs. "#EC CI_NOFIELD

    Function Modules used within report and the associated call statement:

    FM_AUTH_CHECK_FM_AREA call function 'FM_AUTH_CHECK_FM_AREA' exporting i_fikrs = p_fikrs i_actvt = fmau_ac_ini i_msgty = 'E'.

    FMALE_READ_CUST call function 'FMALE_READ_CUST' exceptions central_system_not_defined = 1 others = 2.

    FM_GET_EXPERT_MODE call function 'FM_GET_EXPERT_MODE' importing e_exception_active = l_fmale_show_system.

    Text pool values

    Selection Text: P_BGPC = D Optimize Performance
    Selection Text: P_FIKRS = D Financial Management Area
    Selection Text: P_TEST = Test run
    Selection Text: S_FMBEL = D FM document number
    Title: Deleting Actual Data and Commitment Data in FM
    Text Symbol: 020 = Control
    Text Symbol: 040 = FM area
    Text Symbol: 050 = Deleted
    Text Symbol: 060 = Number of document headers :
    Text Symbol: 070 = Number of line items from FI docs:
    Text Symbol: 080 = Number of line itms from OI docs:
    Text Symbol: 090 = Number of totals records :
    Text Symbol: 100 = Doc. selection

    Terms of Service     Contact Us     Privacy Policy     Useful SAP related sites