how to download master data of vendor to Excel

[Former Member]

Dear All,

how to download master data of vendor to Excel?

[former_member765905]

Hi Expert,

To download Vendor Master Data:

Go to T-Code: SE16 and provide LFA1 for General Data and LFB1 for Company Code Data..

and Press Enter, then provide the Vendor Range and Press Execute Button.

Select Menu -- Edit --- Download then select Spread sheet provide the path to save the download file and provide file name and press OK...

Go to the provided path, which may find your Vendor Master Data in Excel format...

Regards,

GK

SAP

[Former Member]

Thanku you very much

[srinivasa_maruvada]

Go to table LFA1 at transaction code se16 for Vendor general data

Click Execute

Select all icon

Go to menu System-List-Save-Local File

Here you select Spread sheet radio button

Do it for table LFB1 as well for vendor company code data

Srinivas

[Former Member]

HI,

if you want to download the name & address part of vendor use report S_ALR_87012087 ^ select output as SAP LIST VIEWER & download the data in excel format .

snagorij

[Former Member]

hai fico rsr

you may get from above t.code S_ALR_87012086,give company code and vendor then execute.

you select menu bar Systems-list-save -local file-Spread sheet (for exel down load ) OR RICH TEXT ( WORD FILE down load)

for exel file if you select spred sheet the give a file name and where it stored.

same for word file down load.....

clear.......give points

[Former Member]

Dear Fico

S_ALR_87012086 - Vendor List here give your Vendor No. company code seelct your requiresments under further selections.tab and Execute. Next go to List - save/ send - File. here select spread sheet.

Regards

shankar