SQL Query in SE11

[premal_mistry2]

Hi All,

This idea just occured to me while I was fetching data from a table through SE11.

I was wondering is there any way of specifying an SQL Query in the selection creiteria for data selection in SE11.

For example say in S031 table I want to get stocks of only depots and not the tables so for that I should be able to specify an SQL query in select-options of WERKS like

SELECT * FROM J_1IWRKCUS WHERE J_1IDEPOT EQ 'X'.

Awaiting your valuable suggestions .....

[premal_mistry2]

!!!

[Former Member]

Hi,

Maybe you should use se16 rather than se11, because se11 is not for data selection.

In se16 you can specify different values to show for any column of a table.

Or maybe I didn't understand what you requested.

Regards,

Antoine