Solution : https://service.sap.com/sap/support/notes/330416 (SAP Service marketplace login required)
Summary :
When using the MASS transaction in SAP for mass maintenance, a termination may occur with an ABAP runtime error SAPSQL_WHERE_CANT_SCAN if the data transmitted to the database interface exceeds specific byte limits (8 kbytes in releases up to 4.5 and 28 kbytes in releases up to 4.6). This error typically arises during excessive selection conditions in the WHERE clause, leading to truncation. To resolve this, selection conditions should be adjusted to remain within the interface’s byte limit, using an estimation formula for the maximum selectable hits based on the SAP release version.
Key words :
mass maintenance transaction mass terminates, abap runtime error sapsql_where_cant_scan, additional key words sapsql_where_cant_scan, screen 'restrict data records, function key 'multiple selection', mass maintenance terminates, function 'multiple selection', select table marc, field 'material' exceeds, selection conditions exceed
Related Notes :
| 1526530 | Save Variant -> SAPSQL_ARRAY_INSERT_DUPREC (II) |
| 873596 | CX_SY_OPEN_SQL_DB due to too many single values at selection |
| 709077 | MASSD: Saving of a variant terminates with runtime error |
| 557702 | FAQ for mass maintenance |
| 517296 | Variant save -> SAPSQL_ARRAY_INSERT_DUPREC |
| 13607 | Termination of an ABAP with DBIF_RSQL_INVALID_RSQL |