I'm facing a problem when i'm going to create report from selection screen.
purpose of the report is ti show customer information.
so im getting data from
knvp(to get the data of sales employee - partner function)
----- particular customer must be available on kna1,knb1 and knvv but he may not available on knvp.-----
In the selection screen below fields are available.
customer number,customer name,sales employee
so in my programming logic i have used inner join to join kna1,knb1 and knvv.. Then based on that using for all entries logic im getting sales employee data..
then using read table a append sales employee data to customer..
But my problem is...
if in the selection screen we have mention only one rep(0001) no any other data..
even there is only a one customer for that sales employee..im getting all the customer in to programme run-time memory so how to avoid this?