Skip to Content
0
May 17, 2010 at 06:44 PM

select query-ignoring a few records

60 Views


if not int_ekko_list[] is initial.
SELECT ebeln vgabe shkzg dmbtr INTO TABLE int_ekbe_data1
FROM ekbe FOR ALL ENTRIES IN int_ekko_list
WHERE ebeln = int_ekko_list-ebeln AND   " PO number
      vgabe IN r_vgabe.
endif.
SORT int_ekbe_data1 BY ebeln vgabe shkzg.

Here it is fetching only 8 entries ie 3 entries were missing.When the subsequent records is 
having the same amount it is ignoring a few records. 

if not int_ekko_list[] is initial.
SELECT ebeln vgabe shkzg belnr dmbtr INTO TABLE int_ekbe_data1
FROM ekbe FOR ALL ENTRIES IN int_ekko_list
WHERE ebeln = int_ekko_list-ebeln AND   " PO number
      vgabe IN r_vgabe.
endif.
SORT int_ekbe_data1 BY ebeln vgabe shkzg.


EBELN        VGABE BELNR      DMBTR            SHKZG

0002000059   1     5402073016          100.00  S
0002000059   1     5402073033          500.00  S
0002000059   1     5402073041        2,500.00  S
0002000059   1     5402073045          500.00  S        
0002000059   1     5402073046          500.00  S
0002000059   1     5402073301          500.00  H
0002000059   9     0001386428          100.00  S
0002000059   9     0001386429        2,500.00  S
0002000059   9     0001386430            0.00  S
0002000059   9     0001386431          500.00  S
0002000059   9     0001386432          500.00  S

But when I add belnr also in the query it is fetching all the 11 entries.With this change the purpose is served but I am curious to know the reason behind it.Any idea ....?

Thanks,

Kiran.