problem in query

[laxman_sankhla3]

hi

in below query when ever i m not taking maretial No in where condition

all material no data is coming

but when i m giving in where condition matnr No from selection screen

no data is coming is ther any wrong in loop condition

or any thing else.

SELECT * FROM EKPO

INTO CORRESPONDING FIELDS OF TABLE

INT_EKPO

WHERE

<b>* EKPO_{MATNR = S_MATNR AND</b> EKPO}WERKS in S_WERKS.

sort int_ekpo by werks.

delete adjacent duplicates from INT_EKPO .

SELECT MATNR MAKTX FROM MAKT

INTO CORRESPONDING FIELDS OF TABLE

INT_MAKT

FOR ALL ENTRIES IN INT_EKPO

WHERE MAKT~MATNR = INT_EKPO-MATNR.

loop at int_ekpo.

int_OUT-MATNR = INT_EKPO-MATNR.

MODIFY INT_EKPO.

ENDLOOP.

thanks in adavanced.

[Former Member]

hi,

In where condition specify as

<b>EKPO_{MATNR in S_MATNR</b> AND EKPO}WERKS in S_WERKS.

thanks,

Navneeth.K

[laxman_sankhla3]

THANKS MAN

[Former Member]

<b>if s_matnr[] is not initial.

SELECT * FROM EKPO

INTO CORRESPONDING FIELDS OF TABLE

INT_EKPO

WHERE

EKPO~MATNR <b>IN</b> S_MATNR

AND EKPO~WERKS in S_WERKS.

endif.</b>

Regards

Prabhu