Skip to Content
0
Former Member
Dec 12, 2013 at 02:35 AM

Query table using select-option

680 Views

Dear ABAP lover,

Please help, i want query database table using where the data in select-option. The situasion like this:

s_matnr for mara-matnr

s_mtart for mara-mtar

s_werks for marc-werks.

I want select from table MARA and MARC using inner join with where condition:

select........

where a~matnr in s_matnr

b~werks in s_werks.

but s_werks is only the three last digit. For example i input : 3701, 4100 in plant select-option. So, just take 701 and 100 for value in s_werks.

Please any one give me tricks to do this.