on 02-09-2012 12:14 PM
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.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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???
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please go with the one time vendor creation then no need of maintain the vender master for vendor.
Thanking you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.