Duplicate Vendor creation

[Former Member]

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

[JL23]

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.

[Former Member]

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

[JL23]

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.

[Former Member]

Hi jurgen,

Thanks for the solution.

We will definitely put a check in our program.