Skip to Content
0
Former Member
Apr 25, 2007 at 08:38 AM

Functional Module:Infinite loop

31 Views

We have written a functional module by joining the following four tables.

mslb, mslbh, mbew, mbewh.

Because of joining four tables we didn't use cursors.Using select and loop statements we are getting the correct data to BW.

But the problem is our functional module getting into the infinite loop.All the SDN and other functional module examples are based on the cursors and using the following statement to raise no_more_data.

IF SY-SUBRC <> 0.

CLOSE CURSOR S_CURSOR.

RAISE NO_MORE_DATA.

ENDIF.

As we are not using any cursors in functional module,Please help if there any alternative way to complete the loop.

Thanks

Soujanya