topic Re: Issue in select query in Application Development and Automation Discussions

Issue in select query

Former Member — Tue, 05 Jan 2010 16:56:17 GMT

Hi ,

The below select query retreives only 6 records for a particular plant from MSEG table but we have 14 records in the table for that plant, this query works fine for all the other materials except for one material , can anyone let me know what may be the reason for this.

IF I_TAB[] IS NOT INITIAL.

SELECT MBLNR

BWART

MATNR

WERKS

DMBTR

LBKUM

SALK3

SHKZG

SMBLN FROM MSEG INTO TABLE IT_MSEG

FOR ALL ENTRIES IN

I_TAB WHERE MATNR EQ I_TAB-MATNR AND

WERKS IN S_WERKS.

ENDIF.

Thanks.

Re: Issue in select query

Former Member — Tue, 05 Jan 2010 16:59:27 GMT

Blank

Edited by: Harsh Bhalla on Jan 5, 2010 10:33 PM

Re: Issue in select query

Former Member — Tue, 05 Jan 2010 17:00:18 GMT

Since you are using for all entries in itab, this query will give all unique records. Missing records must be duplicates.

regards,

Re: Issue in select query

BH2408 — Tue, 05 Jan 2010 18:08:24 GMT

Hi ,

In the Select you are using the For all entries , What it will do . It will look at the I_TAB table entries i.e material number with plant in the selection screen.I is fetching what ever material presented in the I_TAB based on the plant.

Regards,

Bharani.

Re: Issue in select query

Former Member — Tue, 05 Jan 2010 18:58:42 GMT

Bring in all the three key fields (MBLNR, MJAHR, and ZEILE) in SELECT statement and you will get all the records.

Re: Issue in select query

Former Member — Tue, 05 Jan 2010 19:36:20 GMT

Hi select all the key fiedls while using for all entries this will fetch all the records

add MJAHR , ZEILE fields in the select query. please correct the code below



IF I_TAB[] IS NOT INITIAL.

SELECT MBLNR 
             MJAHR
             ZEILE
             BWART
             MATNR
             WERKS 
             DMBTR
             LBKUM 
            SALK3 
            SHKZG 
            SMBLN FROM MSEG INTO TABLE IT_MSEG
            FOR ALL ENTRIES IN
           I_TAB WHERE MATNR EQ I_TAB-MATNR AND
           WERKS IN S_WERKS.

ENDIF.

If you need further info let me know

Regards

Satish Boguda

Re: Issue in select query

Former Member — Tue, 05 Jan 2010 22:05:06 GMT

Hi Mohana,

The 14 records you are expecting from table MSEG, make sure that each of the materials out of these 14 records are present in your i_tab[].

Re: Issue in select query

Clemenss — Tue, 05 Jan 2010 23:12:47 GMT

using for all entries you must select all key fields, otherwise duplicates are eliminated. Then use INTO CORRESPONDING FIELDS and you will not need all key fields in the target area. INTO CORRESPONDING FIELDS is always the better alternative because the DB interface makes sure you have no performance loss.

Regards,

Clemens

Re: Issue in select query

Former Member — Wed, 06 Jan 2010 05:04:03 GMT

Hi,

Ur query is for material and plant in where condition. mey the table has 14 records which has same plant and different materials

go to Mseg table and select the data with material and plant n chk the records

Please try this is Debugging mode

Regards

Azeez