Data Storage in SAP Invoice and Goods Receipt Reconciliation
All data of SAP HANA Live solutions is stored in the database. There is no storage of data on the file system.
Note the following:
If a processor is entered, the data is saved when choosing OK. The current user is automatically entered as the person who last changed the data.
If a comment is entered, the data is saved when choosing Save Comment. The current user is automatically entered as the processor and as the person who last changed the data.
If the status is changed on the UI, the data is saved directly without clicking a button. The current user is automatically entered as the processor and as the person who last changed the data.
These changes are stored in the SAP HANA database table sap.hba.apps.grircm.db::GRIRCMSTATUS in schema SAP_HBA. The definition of this table is delivered in the file sap.hba.apps.grircm.db.GRIRCMSTATUS.hdbtable. By activating this file, the corresponding table will be created.
If you entered comments prior to SP03, note the following:
As of SAP Invoice and Goods Receipt Reconciliation 1.0, SP03, the field NOTE (datatype Char512) in table GRIRCMSTATUS has been replaced by the field GRIR_NOTE. This is where your comments are now saved. Previous comments are no longer displayed. If you want previous comments to be displayed, you must transfer them to the new field using an equivalent SQL statement. You must adapt sample code as needed:
update "SAP_HBA"."sap.hba.apps.grircm.db::GRIRCMSTATUS" set "GRIR_NOTE" = "NOTE" where "NOTE" != '' and length("GRIR_NOTE") = 0;
The local storage of the browser (if supported) is used to store configuration/personalization data permanently. This data contains no confidential data, but only default values (such as client) or metadata for OData service requests to the SAP HANA database.
The stored data can be deleted using the standard features of the browser.