Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Need help in read statment

Former Member
0 Likes
799

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
768

Hi Mohan,

Loop through itab1.

at end of BDZEI.

move entries to itab2.

endat.

display itab2.

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

Satish

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

6 REPLIES 6
Read only

Former Member
0 Likes
768

use

loop at itab.

at end of bdzei.

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

write 😕 itab-plnmg

endat.

endloop.

Read only

Former Member
0 Likes
769

Hi Mohan,

Loop through itab1.

at end of BDZEI.

move entries to itab2.

endat.

display itab2.

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

Satish

Read only

Former Member
0 Likes
768
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.
Read only

Former Member
0 Likes
768

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

Read only

0 Likes
768

plz give some more clarification.

mohana

Read only

0 Likes
768

Mohana,

I think your problem should get resolved.

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

Satish