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.