Vendor List in Company Code

[Former Member]

Hi All,

How do I get Vendors maintained ONLY in a certain Company Code? MKVZ only shows vendors listed in Purchasing Orgs.

Is there another std report users can run to see a list of vendors in CoCd?

Thanks in advance.

[former_member581212 · Accepted solution]

hi,

Table LFB1 show the vendor for the company code..

LFA1 shows for the general section

LFM1 its for porg data..

Hope it helps..

Regards

Priyanka.P

[Former Member]

Check following Reports;

S_ALR_87012086 - Vendor List

S_ALR_87012087 - Address List

[Former Member]

Thanks ALL for your responses.

Is there a way to change layout in this transaction "Vendor List" and export to Excel file?

[Former Member]

ask ur abaper to copy the existing S_ALR_87012086 into new one and modify the status(set-pf status = standard_fullscreen).

then u will be getting all provision that u need.

[Former Member]

Hi,

S_ALR_87012086 , select the required one in further selection segment and execute.

In Menu select list>Save/send>File. choose spread sheet. give file name and location and generate.

Regards,

Chandra

[Former Member]

Hi,

S_ALR_87012086 list of vendors in company code

Regards,

Chandra

[Former Member]

THERE IS NO STANDARD REPORT,U HAVE TO USE TABLE LFB1

REGARDS,

INDRANIL

[kunal_ingale]

hi

the std report for this is not available u have to make z developement or use the table LFB1

go to se16 give table LFB1 then in field BUKRS (co ocde) give co code and execute

regards

kunal

[Former Member]

Hi,

I can not see any standard report.

But in MKVZ when press F4 to select Vendor,you can search by company code.A list will show.

Or you can create a query from table LFB1.

Jason

[former_member192897]

Use Table LFB1 Vendor Master Company code Data and Retrieve Vendor list at Company code.