topic SELECT QUERY PROBLEM in Application Development and Automation Discussions

SELECT QUERY PROBLEM

Former Member — Thu, 20 May 2010 11:12:49 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_EKKO

WHERE EBELN = IT_EKKO-EBELN

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

ENDIF.

Best Regards

margani

Re: SELECT QUERY PROBLEM

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

Dear All,

Is there any logic for this select query other than this. or any modification is need for this select query..

plz help me

Regards

margani

Re: SELECT QUERY PROBLEM

Mohamed_Mukhtar — Thu, 20 May 2010 11:27:10 GMT

Hi,

Select all key fields of the table MSEG

IF IT_EKKO IS NOT INITIAL.
SELECT MBLNR
"add these two flds to ur query
MJAHR
ZEILE
"add 
BWART
MATNR
WERKS
LGORT
CHARG
SHKZG
MENGE
ERFME
FROM MSEG
INTO TABLE IT_MSEG
FOR ALL ENTRIES IN IT_EKKO
WHERE EBELN = IT_EKKO-EBELN
AND BWART IN ('105', '106', '124', '125').
ENDIF

Thanks

- Always Learner

Re: SELECT QUERY PROBLEM

Former Member — Thu, 20 May 2010 14:26:08 GMT

Hi,

I dont see a reason for the data to be selcted for all other values except for one, just that either there is no data for it in DB table, or is it that latter there is some delete statements.

Have you debug your select query?

Regards,

Sana.

Re: SELECT QUERY PROBLEM

Former Member — Thu, 20 May 2010 14:34:25 GMT

Hi dear,

IN my dev server MSEG table has data. i saw both in data base table and in my debug mode.

Re: SELECT QUERY PROBLEM

Former Member — Thu, 20 May 2010 14:49:23 GMT

This is a duplicate post - you have your answer in the other one.

Rob