Need help in read statment

[Former Member]

Hi,

i have a internal table with following records,

BDZEI PDATU PLNMG

1083 20071029 4

<b>1083 20071029 44</b>

1096 20071029 44

1096 20071029 100

<b>1096 20071029 62</b>

1089 20071029 32

<b>1089 20071029 40</b>

i want to fetch the plnmg values from this table it will check the each and every BDZEI values to collect the last bdzei value and its qty.for example in my internal table contains bdzei values 1083 1083 i need the second value, for 1096 in need the 3rd values, for 1089 i need 2 values.

how to do plz give some idea. point will be sure.

Mohana

[Former Member]

use

loop at itab.

at end of bdzei.

*---u'll get required values here....

write 😕 itab-plnmg

endat.

endloop.

[Former Member]

Hi Mohan,

Loop through itab1.

at end of BDZEI.

move entries to itab2.

endat.

display itab2.

<b>Reward points if it helps,</b>

Satish

[former_member223537]

data : watab  type line of itab.


sort itab by bdzei.

loop at itab.
move itab to watab.
at End of bdzei.
append watab to ifinal.
enddat.
endloop.

[Former Member]

Hello,

1. Loop the internal table.

2. Use AT New statement, so whenever your BDZEI value changes, you can fetch the last record.

Try with AT New and let us know if it works or not.

Thanks,

Suresh Ganti

[Former Member]

plz give some more clarification.

mohana

[Former Member]

Mohana,

I think your problem should get resolved.

if it resolved reward points for helpful answers and close the thread.

Satish