Problem in Checking and Incrementing while Looping

Former Member — Tue, 15 Jul 2008 07:22:52 GMT

See I have this problem I have table A and Table B

Let's say for example,Table A has field customer of,

And table b has field customer of,

I am suppose to compare A with B if A has a customer number equal to one of the values in B. It has to increment until it reaches a number not available in B. so in table A 1 is ok. 2 as well. but 3 has to be incremented to 7. 4 is next from table A next available is 7, but im suppose to make the customer field unique so next increment is 8. How do I go about doing this. Having a hard time checking while looping

Re: Problem in Checking and Incrementing while Looping

Former Member — Tue, 15 Jul 2008 07:30:47 GMT

Hi,

In the loop you can have the value in a seprate variable which you are updating.

e.g.

Sort A by customer number descending.

v_custno = a-custno. ( This will have value as 6 )

v_custno = v_custno + 1.

Loop at A.

read table b with key custno = A-custno.

if sy-subrc is initial.

A-custno = v_custno.

v_custno = v_custno + 1.

endif.

endloop.

Hope this logic shud meet your requirement.

Regards,

Lalit

topic Problem in Checking and Incrementing while Looping in Application Development and Automation Discussions

Problem in Checking and Incrementing while Looping

Re: Problem in Checking and Incrementing while Looping