Table for plant address

[Former Member]

Hi,

I am looking for the table from where we can get the address number of a location (plant). When we get the details of a shopping cart through FM> BBP_PD_SC_GETDETAIL, in the the table I_PARTNER, there is a field ADDR_NO. I could able to get this address number for the other partner functions 12, 20, 27 but not for 75. Can you please help me to find out the table in which the plant address is store?

Thanks,

Arun

[former_member183819 · Accepted solution]

crmd_partner will have partner function for location and it linked with GUID of sc. check in bbp_pd

you will understand under partner details.

Muthu

[Former Member · Accepted solution]

Hi All,

Thanks for your reply. Let me clarify question.

I am creating a BDC program to create shopping cart through FM: BBP_PD_SC_CREATE. For that, I need to pass the address number of plant (location) into the internal table when partner_fct = 0000075. We can get the business partner for the plant from table BBP_LOCMAP. But I need to get the address number of that plant or BP. Can you please tell me, from which table I can get the address number of a plant?

Thanks,

Arun

[former_member183819 · Accepted solution]

Did you try in BUT000 table

pass BP number in BUt00 table and you must get Plant address

Muthu

[Former Member · Accepted solution]

Hi Arun,

Just pass the PARTNER NO (from table BBP_LOCMAP for the Plant) to the table "BUT020".You will get the Address no in the field "ADDRNUMBER".

Hope this solves your issue.

BR,

Deepti.

[Former Member · Accepted solution]

Thank you Deepti. I got it from BUT020.

[ravindra_mantri2]

Hi Arun,

BBP_LOCMAP holds the business partner to plant relationship.

BUT000 then holds the business partner details.

-rgds,

Ravi

[Former Member]

Hi,

You can try ADRC table.

Regards,

Vikas

[Former Member]

Hi,

In BBP, following tables are found ...

BBP_LOCATION_FAV

BBP_LOCMAP

BBP_LOCMAP_ADM

Hope this helps.

Regards,

Vikas