Solution : https://service.sap.com/sap/support/notes/195157 (SAP Service marketplace login required)
Summary :
SAP Note addresses the issue of excessive entries in application log tables such as BALHDR, BALHDRP, BALM, BALMP, BALC, BALDAT, and BAL_INDX across various SAP releases. It outlines that logs are collected by applications for user information and are stored in databases without automatic deletion. Logs have a pre-defined expiration date, post which they can be deleted using designated transactions such as SLG2 for Releases >= 4.6A and reports like RSSLG200 or RSSLGK90 for older versions. To manage log data effectively, users can use the mentioned transactions to delete expired or permissible logs and must consider client-dependency during deletion.
Key words :
abap/4 runtime error dbif_rsql_sql_error sql error 1555 occurred accessing table, 'external identification' field specifies, 'application log' tool sets, application automatically log serves, database error text, field 'external number', avoid large quantities, del_before= space means, del_before='x' means, balhdr table determines
Related Notes :
| 1009281 | LAW: Runtime error CONNE_IMPORT_WRONG_COMP_TYPE |
| 856006 | Mass processing saves unnecessary logs |
| 737696 | Add. info on upgrade to SAP R/3 Enterprise 4.70 Ext. 2 SR1 |
| 706478 | Preventing Basis tables from increasing considerably |
| 637683 | Add info about upgrade to SAP R/3 Enterprise Core 4.70 Ext 2 |
| 587896 | Add. info on upgrade to SAP R/3 Enterprise Core 4.70 SR1 |
| 540019 | Report RJBTPRLO does not work correctly |
| 400687 | Delete application log: DBIF_RSQL_INVALID_CURSOR |
| 390062 | Additional information about upgrading to 4.6C SR2 |
| 370601 | Composite SAP note: APO 3.0 and 3.1 performance |
| 365602 | M/AM: Sales agent determination log - perf. |
| 327285 | Additions to upgrade to 4.6C SR1 |
| 183960 | ALE: Deactivating application logs for data transfers |
| 141244 | Deactivating the application log during data transfer |
| 138715 | RSSLGK90: Too many lock entries in the database |
| 118314 | Installing the interface to a separate EH&S |
| 91519 | Deleting logs of the application log |