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.
As we are not using any cursors in functional module,Please help if there any alternative way to complete the loop.