list of vendors by purchasing group

[Former Member]

Hi,

Could u plz suggest how to get list of vendors by purchasing group or vendor master with purchasing group data.

[Former Member]

This message was moderated.

[Former Member]

answered

[Former Member]

hey

List of the vendors-MKVZ

by the menu path

sapmenu->logistics->material management->Purchasing->masterdata->vendor->list of displays->mkvz

[sapimg]

cannot find the field about purchasing group via MKVZ

[Former Member]

Hi,

If you are reffering purchase organization,then you will get list of vendors by purchase organiztion in T-code MKVZ.

Regards,

Raviraj

[xukkgg]

cannot find the field about purchasing group via MKVZ

[Former Member]

Hi Ram,

I thing there is no direct T.Code to fetch the Vendors with respect to purchasing group.

But the approach is :

1) Goto SE16

2) Table Name : LFM1

3) goto settings --> Fields for selection

4) Choose Purchasing Group (EKGRP) field.

5) By executing this, we can fetch VMR w.r.t. Pgrp.

[Former Member]

Hi

Pur Grp is defined in Matl Master then PR n then PO.

So u can get list of matl with respect to Pur Grp.

I feel thr is no such list by Pur grp.

List of Vendor - MKVZ

Regards

Ram

[former_member192897]

Normally Purchasing Group is Assigned to MMR.

Yes, You can Retrieve VMR Purchase Group data. If you have Maintained Purchasing Groups in Vendor Master Purchasing Data also.

Go to SE16 give Table LFM1 VMR Purchasing Data then Execute. It will show all the Vendors list further Set Filter or by Changing layout you can fulfil your requirement.

Regards,

Ashok

[kunal_ingale]

hi

go to SE16 give table LFM1

then go to settings> field selection here select the field EKGRP(pur grp) then u will get field for pur grp ,give the input

and execute u will get the list

regards

kunal

award if helpful

[Former Member]

sorry for my early pst.if ur vendor master does have the purchase group field filled,then u can download it through se11/se16 with table-field LFM1--EKGRP

regards,

indranil

[JL23]

vendor master has a purchasing group field, but I have never seen this in use. In general the purchasing groups are assigned to materials.

If you have vendors assigned to purchasing groups, then you can create a simple list in SE16 on table LFM1.

Or in SQVI by joining LFM1 and LFA1 to get as well vendor names.

[Former Member]

pls refere to my next post.inconvinience caused is highly regretted

regards,

indranil

Edited by: INDRANIL BHATTACHARYYA on Aug 26, 2008 1:47 PM

[Former Member]

hi,

if you have vendors assigned to purchasing groups, then you can Go to TCode SE16 and enter table name LFM1 Press Enter,then on next screen ,enter purchasing group and click on execute button.You will get all vendor maintained in purchasing group mentioned by you.

OR

In SQVI by joining TABLES LFM1 and LFA1,You can get all vendor assigned to respective Purchasing groups.

regards

Manish Joshi