Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Select-options filter in sql search.

Hello masters,

i am giving parameters to filter my search in sql statement but i want to change it to select-options.

i have searched the web but i couldnt find anything.

here is my code:

EXEC SQL.

     OPEN C FOR

       SELECT MAGAZAKOD, STOKKOD, ADET, BRUTTUTAR,

       INDIRIM, NETTUTAR, PROMOTIP, PROMOKOD

     from [dbMAROFIS_POS].[dbo].[PromoSorgu]

WHERE MAGAZAKOD = :P_WERKS AND

     TARIH = :p_budat

     ENDEXEC.


i want to change p_budat and p_werks.


thanks in advance.

Former Member
Not what you were looking for? View more on this topic or Ask a question