cancel
Showing results for 
Search instead for 
Did you mean: 

Vendor for which no po created.

Former Member
0 Kudos

There are some vendors for which we never create po but they are still our vendors .

How i can found such vendors.

I think atleast we are doing miro for such vendors.

I want to found such vendors for around 10 company codes.

Plaease advice me the easiest way.

Accepted Solutions (1)

Accepted Solutions (1)

former_member197616
Active Contributor
0 Kudos

hI,

yOU can use the table EKKO to find the POs filtered with vendor for a specific company code for a speciic period.You can make an excel compariosin for the vendors with the LFB1 vendors for that comapny code so that you can find the vendors which are not with POs.

However irrespective of the POs FI can post the finance invoice with out PO and an account document gets generated for the same.

through FB60 04 F-43 an FI invoice acn be entered .

S_ALR_87012103 - List of Vendor Line Items ,S_ALR_87012085 - Vendor Payment History with OI Sorted List ,S_ALR_87012105 - List of Down Payments Open On Key Date - Vendors ,S_ALR_87012077 - Vendor Information System etc transaction codes will be useful to find out such vendors and documents .

tables like RSEG, RBKP etc will be useful.

Regards,

Answers (8)

Answers (8)

former_member184631
Contributor
0 Kudos

Hi ,

As suggested by Tej , try SAP Report S_ALR_87012093 with a tick on accounts with no purchases.

I gues its the easiest way rather than refining data from Tables.

Honey

kailas_ugale
Active Contributor
0 Kudos

Hi,

try Report

ME80FN and give vendor number.

MK01 can be used for maintaining the vendor details at the purchasing org level & for general data

FK01 can be used for maintaining the vendor details at the company code level & for general data.

.

XK01 can be used for maintaining the vendor details at the company code , purchasing org level and general data

and If you create vendor fir FI perpose only and If you have differnt number range for that then you get list from table also for that account gruop for t-code FK01

but it depend on how you mainatin you at your end

Regards

Kailas Ugale

Edited by: kailasugale on Feb 11, 2012 12:48 PM

Former Member
0 Kudos

Hi Kian,

you can find the 1 st requirement in table EKKO put the vendor number and time interval you will get the you will get the data of all vendor for which PO

But i doubt how come you are not create a PO and geeting invoice from Vendor are u mean this all are famework order???

Former Member
0 Kudos

Hi,

First take the list of vendors in your company by using LFA1 table after go to EKKO table take the list of purchased vendors

then you can compare easily you will get list of vendors to whom we never given purchase order.

Regards

Sridhar Gadela

Former Member
0 Kudos

You can also check in MCE7 or MCE3, MCE5 & MCE7

- Enter purchase organization and enter the date if you want to restrict or leave it blank.

- system will list all the vendors with PO value.

- You can sort PO value from ascending so system shows all the dormant vendors with zero value i.e no purchase

tejyadav
Active Contributor
0 Kudos

Hi, Check in T-code: S_ALR_87012093 , Select checkbox for Accounts with no purchases & execute, also try to make use of the Dynamic selection (Shift +F4).

Former Member
0 Kudos

Hi,

Please go with the one time vendor creation then no need of maintain the vender master for vendor.

Thanking you

Former Member
0 Kudos

Hi Kiran,

Try to check in the table MSEG or RSEG with PO no as Blank and if you have some specific mvt types for which you are doing the GR like 501 mvt type.

Regards,

Yawar Khan

Former Member
0 Kudos

You can mention Vendor code ,Company code in EKKO(Pur. Header Table ) to get all PO rasied in specfic company Code.Mentioning Vendor Code in Standard Report ME2L can list you out all PO,s raised against him.