Know about Vendor Code already deleted from system

[Former Member]

Hi,

User has created a Vendor for PO, but that was due to wrong Account Group. After that User delete the vendor and used another vendor during PO creation in mid process. Now Condition are coming wrongly from that.

I checked in PO header history, there Address Number is showing related of wrongly created Vendor...but Vendor code is not showing in LFA1 table against address number.

Now i have Address Number of Vendor but cann't find the vendor code.

I want to know the Vendor Code already deleted from system (because not showing in Vendor Master table LFA1).

Please guide..

[kailas_ugale]

Hi

User has created a Vendor for PO, but that was due to wrong Account Group. After that User delete the vendor and used another vendor during PO creation in mid process. Now Condition are coming wrongly from that.

If I am not wrong you want assign assign vendor schema group in vendor master record so you condition will come properly in PO

Open your vendor master record and select purchasing tab in XK02 and then assign suitable schema group there like for domestic purchasing or import purchasing

your condition will flow in PO

Regards

Kailas ugale

[Former Member]

Thanks,

Vendor Schema is correct in Vendor Master...

I want to know one thing only that if Address Number is showing in Table ADRC, then Vendor Code must show in Table LFA1 against related Address Number...

Please guide..

[kailas_ugale]

HI

try following

relate the LFA1 and ADRC table using address number.

use ADRNR field in LFA1 and ADDRNUMBER field in ADRC to relate these two tables and try to get vendor number

Regards

kailas Ugale

[Former Member]

Table ADRC has the Address Number - 35648, but it is not in Table LFA1...

What should be reason???

[Former Member]

Hi,

ADRC is table for address details

whenever we maintain address it makes a entry in ADRC

Like for Plant,Storage location, customer master

SO entry in ADRC never guaranty that entry in LFA1 must be there

And how your vendor was deleted ? or is it archived ?

[Former Member]

As per your comment "whenever we maintain address it makes a entry in ADRC Like for Plant,Storage location, customer master"...How to maintain the Address...which impact only table ADRC, not in LFA1.

We still not found the reason that Vendor Code was deleted or it was just maintained (as your commented)...

please guide...

[Former Member]

HI,

For example when we maintain plant address in OX10

It creates a entry in ADRC ( but it does not mean you will get plant in LFA1 )

to get the plant address details go to T001W ->get ADRNR with this go to ADRC get the plant address details

Same as customer master ADRC does ensures LFA1 entry

Now can you specifically give the details where you get that ADRNR for which you are getting ADRC and not LFA1

[Former Member]

I got that Address Number in PO Change History...after that i check vendor code against that address in LFA1 Table but not found... I again check in Table ADRC, i got the details against that address...

That's why was asking if a address number created, then should be create vendor code too..

You explain me about plant earlier, Now Can you please explain Vendor code example... from address number generated without vendor code generation...

[Former Member]

Hi,

This can happen if user changes the delivery address in PO item:

In Purchase Order item details Delivery Address tab user have changed the delivery address which by default comes from

Plant address( from OX10) or from storage location address ( from OX09 ) if you have maintained storage location in PO

So when user changes this value manually like Name ,Street/House number or even if you add a . (dot) in the proposed address, this change creates a entry in ADRC table which you are seeing in PO change history and also update table EKPO-ADRNR ( no LFA1can be found for this ADRNR as no vendor is created)

So by comparing these two address from OX10( or OX09 ) Plant address to your PO delivery address you will identify the change and because of this difference system creates a entry in ADRC table (which you are not finding in LFA1)

And I hope this should help you to identify the root cause of your issue

Edited by: redriver on Dec 10, 2011 5:00 PM

Edited by: redriver on Dec 10, 2011 5:30 PM

[JL23]

what ADDR GROUP has your record in ADRC table?

OSS note 164653 has an analysis program to check and correct inconsistencies.

[Former Member]

In table ADRC, field value of ADDRESS GROUP is ME03 - One-time vendor addresses...

[JL23]

looks like a pretty important information, I mean that you are working with one time vendors in your special case.

This means that you will find this correspondend address number in table EKKO instead of LFA1.

And from table EKKO you can then get the vendor number that was used.

A one-time vendor is a very special account group, the "vendor master " is just a Dummy, and the user is forced to enter a valid address when such one-time vendor is used in a PO. the entered address is then stored among all other addresses in ADRC table and is only valid for this specific purchase order.

[Former Member]

Thanks dear.. I understand...

But in EKKO table, Address Number field is BLANK...

Also new Vendor Code showing in this table with PO...(This vendor code data updated in LFA1 table with another Address Number)..

[JL23]

you can check as well EKPO for this number, even I think that you would not have a match there either.

It is probably an inconsistency that was created because your user changed the vendor somehow while creating this PO.

But I don't think that this has anything to do with the issue that an incorrect condition is copied over.

[Former Member]

HI,

First of all how the vendor was deleted ?

If it is through XK06 then it should always show in LFA1 with deletion flag

Is archiving also done with that deleted vendor ?

[Former Member]

hi

activate Message no. F2128 - Vendor xxxx is marked for deletion.

will show you while changing data.

[Former Member]

Hi,

in xk06 flag for deletion vendor , lfa1 table has updated but it won't show in the data.

if it is not updated go for debuging by the help of abaper

Regads

Raj.

[Former Member]

Thanks..

Is there any way to find out Vendor Code from Address Number???