topic problem in query in Application Development and Automation Discussions

problem in query

laxman_sankhla3 — Tue, 10 Apr 2007 06:27:31 GMT

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

* EKPO_{MATNR = S_MATNR AND 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 — Tue, 10 Apr 2007 06:29:22 GMT

hi,

In where condition specify as

EKPO_{MATNR in S_MATNR AND EKPO}WERKS in S_WERKS.

thanks,

Navneeth.K

Former Member — Tue, 10 Apr 2007 06:32:50 GMT

if s_matnr[] is not initial.

SELECT * FROM EKPO

INTO CORRESPONDING FIELDS OF TABLE

INT_EKPO

WHERE

EKPO~MATNR IN S_MATNR

AND EKPO~WERKS in S_WERKS.

endif.

Regards

Prabhu

laxman_sankhla3 — Tue, 10 Apr 2007 06:33:33 GMT

THANKS MAN