Processing financial data for external reporting tool

After you have defined financial statements, you must process the information to the FST reporting tables so that an external report writer can use the tables to create financial reports. For performance reasons, the export process is split up into two parts:

  1. The financial GLD and FBS values are exported to an interim table, and all required balances are calculated, such as balance sheet, income state amount, year-to-date value, and budget values.
  2. Each financial statement is processed so that interim values are merged with the financial statement structures.
Step 1. Set the Actual Value Code parameter

In the Financial Statement Parameters (tffst0500m000) session, set the Actual Value Code parameter.

Step 2. Export financial statement values

Run the Export Financial Values (tffst1204m000) session to fill the financial values table (tffst305) with the financial values from the GLD and FBS tables. Calculated values, such as periodical balance sheets and year-to-date figures, are also exported to the financial values table.

Step 3. Merge financial values with financial statements

Run the Process Financial Statement Values (tffst1205m000) session to merge the exported financial values with the financial statements.

If you select the Export Financial Statement Account Structure check box in the Process Financial Statement Values (tffst1205m000) session, you can skip step 4.

If the Export Financial Statement Account Structure check box is cleared, continue with step 4.

If you select the Export Ledger Account Hierarchy check box or the Export Dimension Hierarchy check box, you can skip step 5.

Step 4. Export financial statement account structure (optional)

If you did not already use the Export Financial Statement Account Structure option in the Process Financial Statement Values (tffst1205m000) session (step 3), you can now use the Export Financial Statement Account Structure (tffst1220m000) session to export the account structure to the FST reporting tables. If the parent-child structure of a specific financial statement has changed without changing the financial values, you can also use this session to export the account structure. In that case, you do not need to export and process the values again as described in steps 2 and 3.

Note: The statement account structure must be set up correctly to successfully export the structure to the FST tables. For more information, refer to Statement account structure for external reporting tool.

Step 5. Export ledger account hierarchies and dimension hierarchies (optional)

If you defined financial statements based on ledger accounts or dimensions, you can use the following sessions:

  • Export Ledger Account Hierarchy (tffst1230m000)
    In addition to exporting the statement accounts and their parent-child relations, you can run this session to export the ledger account hierarchy to the ledger account hierarchy (tffst320) table.
  • Export Dimension Hierarchy (tffst1240m000)
    In addition to exporting the statement accounts and their parent-child relations, you can run this session to export one or more dimension hierarchies to the dimension hierarchy tables (tffst331-tffst335).

Related topics