Customer master data

[Former Member]

Hi

I require following customer master data only one time. Please let me know how can i get it as there are many customer master records so downloading in excel throgh the table and rearranging it will be difficult,

Cust. Nr.

Cust. Name

Street/Housenumber

Postal code/City

Country

VAT Nr.

Bankdetails:

Cntry

Bank Key

Bank Account

Acct. Holder

Control Key

Iban

Thanks

[Lakshmipathi]

Explore VCUST if you are in ECC6

thanks

G. Lakshmipathi

[Former Member]

Hi

Either you can go to the tables or Z report

even you can try for SAp Query

Thanks

Kameshwar Rao

[Former Member]

Hi Gaurav,

You can download data from Customer master data tables "KNA1, KNB1".

Go to SE16 -- enter table name, choose field section as per your required data.

Download to excell

Rds,

Anil

[Former Member]

There is huge data and i dont want to do it excel..

That why i put it in the portal.

[Former Member]

Hi Gaurav,

Try this Report. S_ALR_87012180

Rds,

Anil

[Former Member]

Hi Gaurav,

use the Report S_ALR_870212180 and select the layout as per your requirement.

[Former Member]

This transcation does not exists.