How to achieve loop in AMDP

[former_member473759]

HI Team ,

Is there a way we can achieve loop at internal table in AMDP procedure .

I have a requirement like

I will have a req table and stock table .

For a material i have 3 req and stock is in 1 line with sufficient quantity.

I have to prepare a 3rd table which will assign this stock to every requirement .

Is this achievable in AMDP procedure .

Thanks & Regards,

Saurabh

[Former Member]

Hi Saurabh,

I guess this may be possible by using the concept of Cursors in SQL Script.

Because at database level we can read records in this manner:

DECLARE CURSOR c_cursor1 (v_isbn VARCHAR(20)) FOR

SELECT isbn, title, price, crcy FROM books

WHERE isbn = :v_isbn ORDER BY isbn;