Skip to Content
author's profile photo Former Member
Former Member

Vendor Address (LFA1 and ADRC tables)

He experts!!

When creating a new vendor in transaction XK01 it is generated one entry in table LFA1 and 2 entries in table ADRC.

The two entries of table ADRC have two different Address numbers (ADRC-ADDRNUMBER) but all other fields are equal between the two entries.

1 LFA1 line --> 2 ADRC lines

How can I do for setting up the system so that only one ADRC line is created per LFA1 entry.

Many thanks,

Ezequiel

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 20, 2009 at 12:47 PM

    Hi

    if there are 2 different ADRC-ADDRNUMBER this means that 2 separate and different address are getting created !!

    To point at one of the above replies you got, the international address version (IAV) does not change the address number. The differences is in field ADRC-NATIO which is part of the key.

    For both address you should look to which object it is related.

    In order words, who is the owner of the address.

    This is stored in table ADRV.

    In case the vendor is the owner of the address, field ADRV-APPL_TABLE will be LFA1 and the vendor number will be in ADRV-APPLKEY in the following form (MANDT+LIFNR)

    eg: for mandant 002 and vendor HUGO, this will be 002HUGO

    Now, you should be able to determine which object is the owner of the second address.

    Nota: ERP 2005 has introduced the so called, master data synchronisation. It might be that the vendor you have created has been synchronised with an ERP Business Partner. In other words, the second address might be owned by the corresponding Business partner

    BR

    Alain

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 13, 2009 at 06:52 PM

    Are you sure two entries are created in ADRC, checked in our system, I am finding only one per vendor. May the address has been modified which would have resulted in two addresses, but normally only one address is created in ADRC per one entry in LFA1

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.