Link for Business Partner number and Address number.

[Former Member]

Hi,

I have few Address Numbers below for which I need the corresponding Business Partner numbers. These Address numbers which are below aer from Table CDPOS in objectid field.

BP 0000025867

BP 0000049717

BP 0000049718

BP 0000049719

BP 0000049720

BP 0000049721

BP 0000049722

BP 0000049729

BP 0000049730

I have put 25867 in BUT000-PARTNER, there is a entry and hence 25867 is the BP for Address no 25867.

I have put 49718 in BUT020-ADDRNUMBER,there is an entry in BUT020-PARTNER ie., 0007000059 is BP for Address no 49718.

Can you provide any link for Address No BP 0000049717 where i can get the Corresponding BP no for this Address no 49717.

Regards,

Deepthi.

[former_member555112]

HI,

The relationship between address number and business partner is in BUT020 table.

Put your adress number in the ADDRNUMBER field.

Regards,

Ankur Parab

[Former Member]

Hi,

I have put the Address no 49717 in BUT020-ADDRNUMBER but thereis NO entry in the table. Can you provide any other table.

Regards,

Deepthi.

[former_member555112]

Hi,

Check if the address number exists in ADRC table and also in BUT021.

Regards,

Ankur Parab

[Former Member]

Hi,

There Exists an entry in Table ADRC for Address No ie., 49717 exists in ADRC-ADDRNUMBER.

Regards,

Deepthi.

[Former Member]

Hi,

49717 entry does not Exists in BUT021-ADDRNUMBER.

Cheers,

Deepthi.

[former_member555112]

Hi,

There are different possibilities then.

Check in LFA1 or KNA1 by putting the adress number incase it is a vendor or customer.

Regards,

Ankur Parab

[Former Member]

Hi,

49717 is there in LFA1 table whose vendor is V3710......

cheers,

Deepthi.

[SuhaSaha]

Hello Deepthi,

May be the address is not maintained for the BP: 49717?

I am not sure if that is possible, just a guess.

BR,

Suhas

[Former Member]

it is solved now

[Former Member]

This could also be because of TREX would have been enabled for BUT000 in SA17 transaction. I did uncheck the active checkbox and did not get the error anymore and I was able to load the data seamlessly.