Skip to Content
avatar image
Former Member

ADRC table Duplicates

Hi,

I am seeing two different address numbers for the same BP and the Name1, Name2 etc details are getting displayed for one of the address numbers and the other address number is coming as blank.

Can anyone please tell me the reason for this and how to delete the duplicates?

Thanks!

Regards,

Ketan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 10, 2010 at 07:14 AM

    I looked at the Address entries in the ADRV table

    - One entry with APPL_FIELD as ADDRCOMM is related to table BUT000, hence ADDRNUMBER corresponding to this would be of less significance and it gets created for every partner.

    - Another entry with APPL_FIELD as PARTNER is related to table BUT020 (This is actual Business Partner Address), the ADDRNUMBER in this case contains the original address of the BP.

    Could anyone please tell me the use of having 2 address entries in these tables and is there any way of deleting the duplicate entry?

    Regards,

    Ketan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 10, 2010 at 08:58 AM

    Thanks for your reply Laurent.

    In my issue actually I am seeing two enteries for same BP in the table ADRC. One is coming as blank and another is coming up with the address details.

    Could you please let me know the reason for this?

    I have already posted my findings in the same thread.

    Regards,

    Ketan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 10, 2010 at 03:13 PM

    Resolved it myself.Hence closing this thread.

    Add comment
    10|10000 characters needed characters exceeded