topic Re: Duplicate Vendor creation in Application Development and Automation Discussions

Duplicate Vendor creation

Former Member — Mon, 27 Sep 2010 18:23:47 GMT

Hi ,

We are Creating Vendors through LSMW using Standard/Direct input Method.but a problem is that some vendors are created twice for a single previous account number(ALTKN) FROM database for some records.

Can anyone Tell me the reason why this happened and what needs to be done to rectify it?

also,any pointers to avoid it from next time will be highly appreciated.How can we avoid it?

Regards,

Rahul

Re: Duplicate Vendor creation

JL23 — Mon, 27 Sep 2010 21:20:44 GMT

General data of a vendor master is stored in table LFA1

LFA1 table does not have the field ALTKN

ALTKN is available in company code data table LFB1.

Here you get a record for each vendor per company code.

so if the vendor is created for 2 companies, then you will find 2 records in LFB1, but only 1 record in LFA1.

Please check again if you really created the vendor twice.

Re: Duplicate Vendor creation

Former Member — Tue, 28 Sep 2010 05:54:41 GMT

Hi Jurgen,

I agree with you on this front and i am aware of this fact that ALTKN is there in LFB1.

The point is that for one ALTKN there are two SAP vendors Created for Same company code.

But,Second one is not needed.

What i have done right now is that i have marked the duplicate SAP vendors for Deletion so that it is not Used for Further procurement.

Is there a better way?

Edited by: Rahul Kumar Sinha on Sep 28, 2010 7:55 AM

Re: Duplicate Vendor creation

JL23 — Tue, 28 Sep 2010 09:39:21 GMT

there is not other way than setting a deletion flag and subsequently archive them.

didn't you check your program with test loads in Q-system?

you have to debug your program to see what caused this double creation, if you want reuse this program again.

Re: Duplicate Vendor creation

Former Member — Tue, 28 Sep 2010 17:46:42 GMT

Hi jurgen,

Thanks for the solution.

We will definitely put a check in our program.