09-08-2009 2:41 PM
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.
09-08-2009 3:05 PM
HI,
The relationship between address number and business partner is in BUT020 table.
Put your adress number in the ADDRNUMBER field.
Regards,
Ankur Parab
09-08-2009 3:07 PM
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.
09-08-2009 3:10 PM
Hi,
Check if the address number exists in ADRC table and also in BUT021.
Regards,
Ankur Parab
09-08-2009 3:19 PM
Hi,
There Exists an entry in Table ADRC for Address No ie., 49717 exists in ADRC-ADDRNUMBER.
Regards,
Deepthi.
09-08-2009 3:20 PM
Hi,
49717 entry does not Exists in BUT021-ADDRNUMBER.
Cheers,
Deepthi.
09-08-2009 3:29 PM
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
09-08-2009 3:35 PM
Hi,
49717 is there in LFA1 table whose vendor is V3710......
cheers,
Deepthi.
09-08-2009 3:45 PM
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
05-04-2010 4:33 PM
04-15-2013 5:54 PM
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.