exporting customer master in excel

[Former Member]

Dear Gurus,

can any one pls let me know how can I export a particular customer master data into excel?

Wishes,

Abhishek

[Former Member · Accepted solution]

For Export customer --Customer pricnig procdeure is differenet right........

take that as a input in Table KNVV give the input CPP and execute then you will get the all the export customer...

from here you can take to excel file this you know.

if u like points otherwise

[Former Member · Accepted solution]

Let me pls modify the question.

I have to prepare a template of Customer Master (XD03) in excel sheet.

pls let me know how to do this.

Abhishek

[Former Member · Accepted solution]

HI,

If you need for LSMW :

write Description for every field and Technical name Column wise.

Ex: Account group I S.Org I Distri I Division I Etc.....

Regards

raj.

[Lakshmipathi · Accepted solution]

Have you tried with VCUST ?? If not, you have to create a query in SQVI and table join KNA1, KNB1 & KNVV. Once the report is generated, convert into an excel file.

thanks

G. Lakshmipathi