Saving of Financial Data to a Database
You can export financial data entered in a data matrix into a backend system.
Prerequisites
You have entered financial data in a matrix, possibly after preparing your matrix for data entry.
For information, see Preparation for Data Entry.
Features
Consistency Checks
When you save data to the database, the system checks the characteristic values in your matrix definition for consistency.
A warning message appears if characteristic values in a matrix are inconsistent with those in the database, for example, if they are invalid or have an incorrect breakdown. You can correct any errors and restart the database update.
Data in rows or columns without a definition is not saved to the database.
The value 0 (zero) is saved for empty cells.
Error Log
Errors that are detected during the export are written in an error log in a text editor window. You can delete errors in the text editor once you have corrected them in the matrix, and you can copy the log to other applications for printing or archiving purposes.
Test Run
You can save data in test mode. The system checks characteristics, validates data if specified, and generate a log of any errors, without updating the database. The test run enables you to remove any errors before saving in update mode.
Activities
To save data to the backend system, you click 
Data Matrix
Update Data
. You specify whether you want to run the update in test mode and whether the system should validate the data.
You can save data from all matrices in a worksheet or all matrices in a workbook to the database.
Note
If status management is switched on in the settings of the consolidation area, the status of that data collection task in the SAP backend system, to which you have assigned a data collection method with the Active Excel
data collection procedure is updated by the exported data.