database hints in select statement

[Former Member]

Hi all,

i need to apply the databaser hints for my select statement where i am using for all entries clause .But the issue is that i am getting the dump when i am tring with the same .

If i use the hint without all entries clause ,it runs fine.

The query where i need to apply the hint is :

SELECT * FROM bsim "n443935

INTO CORRESPONDING FIELDS OF TABLE g_t_bsim_lean "n443935

FOR ALL ENTRIES IN t_bwkey WHERE bwkey = t_bwkey-bwkey

AND matnr IN matnr

AND bwtar IN bwtar

AND budat >= datum-low.

and the DB hint is:

Addition of database hints for DB6 as per OSS message 649621

• %_HINTS

• DB6 'USE_OPTLEVEL 7' " Insert CR-1000000473 Tr-D11K934315

• DB6 '&SUBSTITUTE VALUES&'.

Let me know whats the issue for the dump in for all entries in clause.

[former_member182670]

Did you check if [https://service.sap.com/sap/support/notes/1520152|https://service.sap.com/sap/support/notes/1520152] applies?