topic Re: SELECT QUERY PROBLEM in Application Development and Automation Discussions

SELECT QUERY PROBLEM

Former Member — Thu, 20 May 2010 10:59:16 GMT

Dear all,

I need to fetch data from MSEG table by passing eblen and where movement type is 105, 106, 124, 125.

i use the select query like.

but here i am not geting all the data which is matched with 105 movement type. In the sence one record is missing.

please help me on this.........

IF IT_EKKO IS NOT INITIAL.

SELECT MBLNR

BWART

MATNR

WERKS

LGORT

CHARG

SHKZG

MENGE

ERFME

FROM MSEG

INTO TABLE IT_MSEG

FOR ALL ENTRIES IN IT_MSEG1

WHERE EBELN = IT_EKKO-EBELN

AND BWART IN ('105', '106', '124', '125').

ENDIF.

Best Regards

margani

PedroGuarita — Thu, 20 May 2010 11:01:14 GMT

FOR ALL ENTRIES IN IT_MSEG1

Change this instruction to

FOR ALL ENTRIES IN IT_EKKO

Former Member — Thu, 20 May 2010 11:02:55 GMT

Hi,

Change for all entries statement as

FOR ALL ENTRIES IN IT_EKKO

Regards

Vinod

Former Member — Thu, 20 May 2010 14:14:11 GMT

Moderator message - duplicate post locked Rob