Link between Business Partner & ADRC table

[rajesh_rajendran2]

Hi Experts,

I am in SRM 5 EBP 4 ( ECS scenario ). I would like to know the relation between the BP of an organization and the ADRC table entry maintained for the delivery address of the organization.

When we tried to change the ADRC table entry i.e the delivery address - by changing the street it returned to its old value after saving. But when I tried to change the street address through the transaction BP giving the Organization unit BP number as the input, the value got changed in BP and the same reflected in the ADRC table entry for the delivery address for the organization.

There has to be a definet link b/w ADRC table entry and BP.

Can anyone clarify me regarding the same ?

Awaiting your expert comments !

With Regards,

Rajesh Rajendran

[Former Member · Accepted solution]

Hi

<u>Yes ......... there exists a relation.</u>

<b>Use transaction SE11 and in the table BUT000, there you will Find ADDRCOMM field

ADDRCOMM uses the domain AD_ADDRNUM which is coming from ADRC table.

For table ADRC, ADCR-ADRNR (Primary Key field)</b>

<b>Also refer to a database view -> M_BUPAA_VERSC (in SRM)</b>

<u>Note- > Instead of maintaining Business partners via BP transaction, use the SRM transactions like BBPMAINTINT, BBPGETVD, etc.. depending on the scenario.</u>

Hope this will help.

Please reward suitable points.

Regards

- Atul

[rajesh_rajendran2 · Accepted solution]

Hi Atul,

Thanks for your info !! I have awarded suitable points .. still I need some clarifications..

How does the entry in ADRC table get updated when I change the adress in the BP of the root organization ?

Note : The delivery address attribute is maintained in Organization attribute in PPOSA_BBP.

I hope I get a clear picture of this..

Also , I found out something strange.. After updating the address through BP of the root organization, when I tried to create a new organization directly under the root organization - the address value is again changed to the old value.

Why is it so ??

One hint : The Old address - is taken from the one maintained in the Address tab of the PPOSA_BBP of the root organization.

How can I check the dependencies of the interrelated addresses??

Kindly guide!!!

With Regards,

Rajesh Rajendran

[Former Member]

Hi,

You can use database view bbp_pdview_bup and adrc table joining on fields:

adrc-addrnumber
bbp_pdview_bup-addr_nr

Regards,

Marcin Gajewski

[rajesh_rajendran2]

Hi Marcin,

Thanks for the info !! But can you explain the logic in detail.. any documention regarding the same??? This would be helpful..

I hope I get a clear picture from your detailed explantion.

Awaiting your response in this regard.

With Regards,

Rajesh

[Former Member]

Hi,

Database view bbp_pdview_bup contains two main tables: CRMD_LINK and CRMD_PARTNER.

In your program you can write following query:

data: begin of wa_addr,
        part_no type CRMT_PARTNER_NO,
        part_fct type CRMT_PARTNER_FCT,
        name type AD_NAME1,
        street type AD_CITY1,
        city type AD_CITY1,
      end of wa_addr.

select  bup~partner_no
        bup~partner_fct
        arc~name2
        arc~street
        arc~city1
into    (wa_addr-part_no,
         wa_addr-part_fct,
         wa_addr-name,
         wa_addr-street,
         wa_addr-city )
from bbp_pdview_bup as bup
  inner join adrc as arc
    on bup~addr_nr = arc~addrnumber.
endselect.

This should be enough to get the BP addressess.

Regards,

Marcin Gajewski