Skip to Content
0
Oct 28, 2012 at 02:23 PM

customer information selection not working as expected

32 Views

Hi,

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

kna1

knb1

knvv

and

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?

thank..