Report with Customer Addresses

[Former Member]

Is there a standard Report or a utility that would get

a list of Customer and their addresses and

a list of Contact Persons and their addresses

Appreciate any input ..

[Lakshmipathi · Accepted solution]

Hi

It seems that you have forget to award points for my feedback though you state "Thanks for the information .. it is quite useful".

Please do reward points.

Regards

G. Lakshmipathi

[Lakshmipathi]

Hi

I have already sent screen shots to "learnsaphr@yahoo.com".

Check and confirm receipt. Also dont forget to reward points.

Regards

G. Lakshmipathi

[Former Member]

Laksmipathy,

Thanks for the information .. it is quite useful.

Can someone help me with the Table-Filed information about the email of a Contact Person.

Thanks

[Former Member]

hi

chk tcode s_alr_87012179

[Lakshmipathi]

My official mail id is lakshmipathi@autolec.com. Please send a test message so that I can explain clearly.

Regards

G. Lakshmipathi

[Former Member]

Hey Friend..

Try this standard Transaction: VCUST

This will give you the details of the customer along with Address and Sales Area.

I hope this is useful to you..

Don't forget to reward the points if u find it useful.

D H A

[Lakshmipathi]

Send a test message so that I will send a screen shot of how to extract list of customers with address through query.

Reward if that helps you.

Regards

G. Lakshmipathi

[Former Member]

Hi Lakshmipathi,

I do not see your mail id on your business card.

Please enable mail id on your profile so I can send you a test mail ..

I am also keen on Contact Persons and their addresses

Thanks

[Former Member]

Hi Lakshmipathi,

Here is my mail id .. please email me the details as you have suggested.

<REMOVED>

Thanks

[Former Member]

I believe there are no standard reports, you need to build a query to extract this data.

[Former Member]

any further inputs on tables etc ?

[Former Member]

You will be able to extract information from the following tables:

1. KNA1 - Main table which stores most of the Customer Information.

2. ADRC - Address details.

You can join KNA1.Address number with ADRC.Address number.

Let me know if you need more information.

Please reward points if this resolves your issue or helps.

Thanks.

Ramehs