Standard totals table

It's sure that you have used those tables in whichever moment of your SAP life. They are very useful, functionally or technically speaking. SAP provides Totals Table in Financial area and Funds Management area containing several available fields (Profit center, segment, functional area, etc). The tables allow distinction between leading ledger and non.leading ledger.

Also, it is important to know that the tables allow field enhancements to adapt them to our needs.

FI Area: FAGLFLEXT

FM Area: FMGLFLEXT

In customizing the tables are specified following the path:

How to check Consumed in a Period

The report specified in this post is very important in FM Module. If you work with Funds Management, you will use it in many cases. Some days ago, I used it for a specific case, in particular to know the consumed in a specific period. The standard report we are talking about is FMRP_RW_BUDCON.

How do we access to the specific data for a period? Follow next steps:

Enter the selection criteria.

Select the report for Comsumptions in the left area of the screen.

In the column Consumed, double-click in the total.

Chose Actuals line items.

Enter the proper period and criteria to generate the report, that's all!

Download FMDERIVE data

It's the moment for a key transaction in Funds Management, FMDERIVE. Sometimes we need to download data stored in FMDERIVE transaction in order to perform some local checks. For example, if we have done a massive change in FMDERIVE and we want to perform some checks , it is easier to perform them in local, for example in a spreadsheet.

The way to download data of FMDERIVE is known the SAP table where the data is stored.

And how we know the SAP Table? Easy.

Go to FMDERIVE, select the line where you want to download data (line with data to download is identified with the icon “Table” in the first column called “Maintain Entries”).

Click in the button Chosse (F2), it is the icon “magnifying glass”.

In the next screen click in button overview (Shift+F6), it is the icon “landscape”.

You will see the name of table where the entries are stored. “The rule entries are stored in table xxxxxx”.

The last step is go to SE16 transaction, enter the name of the table, display the entries and download using the standard SAP tool in following menu: System->List->Save->Local File

SAP Functional - FM

Download FMDERIVE data
How to check Consumed in a Period
Standard totals table