on 12-10-2012 7:53 AM
Dear all
I have a small problame, My client wants to get all the email id of customers which belongs to a particular sales ornization. I am fetching the data through the tables but not able to fetch complitely.
my steps are
step 1 fetching custome no from KNVV table for a paritcular sales org
step 2 with refrence to KNVV's customer no I am getting the Address no of the customer.
step 3 by taking all the customer address no I am fetching the email id from the ADR6 table
But I am not getting all the email ids.
Means If i am getting 10 customer----10 address no. but if i will put 10 address no in my adr6 table obly 5 records are fetching
Please help me out its urgent because last day of the year we have to intimate the customer.
Your kind advice is highly apperciable.
Hi,
Since the Customer mail-id will be maintained in the General data you need to take the Adress number from the KNA1 table for the corresponding Customer codes.
With this Address numbers you need to Extract the E-Mail id's from ADR6.
you will get the Email id's if they are maintained in the General Data.
Siavavsireddy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
11 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.