cancel
Showing results for 
Search instead for 
Did you mean: 

Customer Master in Excel format

Former Member
0 Kudos

Hi,

Appreciate if someone could mail me Customer master available in Excel format with a list of all the fields and tabs.

I have one for the Material master, feel free to ask.

yash@ipextechnology.com

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi , i forwarded , please check u r mail, i forwarded , customer, vendor, material

please rewards

rajesh_chavan
Active Participant
0 Kudos

Hi,

Please check your mails...I have forwarded u a execl file

thanks,

Dear SIva,

Can u please forward me your file to Rajesh_Chavan@Satyam.com

cheers,

Thanks

Answers (2)

Answers (2)

former_member358181
Active Participant
0 Kudos

Hi Yash,

Use T-Code - S_ALR_87012180 - (Customer Address List & S_ALR_87012179 (Customer List )

Regards,

Devendra

Former Member
0 Kudos

Dear Friend,

Just go to Table records veiws Screen and

TC: SE16,

then give the table name as following:

:

KNA1 General Data

KNB1 Customer Master – Co. Code Data (payment method, reconciliation acct)

KNB4 Customer Payment History

KNB5 Customer Master – Dunning info

KNBK Customer Master Bank Data

KNKA Customer Master Credit Mgmt.

KNKK Customer Master Credit Control Area Data (credit limits)

KNVV Sales Area Data (terms, order probability)

KNVI Customer Master Tax Indicator

KNVP Partner Function key

KNVD Output type

KNVS Customer Master Ship Data

KLPA Customer/Vendor Link

With each table you enter ...you will be displayed with the total customer master records....

In the same Menu bar you wull find a tabular Icon in square square table icon....Click that.

you will get the same in Excel format..

reward,

If useful...

regards,

Amlan Sarkar