Skip to Content
avatar image
Former Member

Database table/FM to find relation between plant and company code in SRM

Hi,

I have a requirement where I need to determine the relation between the plant and company code in SRM.

The plant and company code both belong to R/3. We are replicating the plant by using the report BBP_LOCATIONS_GET_ALL.

This plant is now available as a BP in SRM. But from which SRM table or using which SRM FM can I get the relation between this and the company code?

Thanks,

Srivatsan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Mar 14, 2007 at 11:17 AM

    Hi,

    Plants and Company codes are stored in table BBP_ATTR_VALUE_T.

    I search for any FM to get a relations.

    Regards,

    Marcin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 14, 2007 at 12:40 PM

    ok,

    You can use FM BBP_LOCMAP_BUFFER. This FM uses table BBP_LOCMAP for Business Partner --> System --> Location.

    Try it.

    Regards,

    Marcin Gajewski

    Reward points for helpful answers.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 14, 2007 at 02:17 PM

    Hi

    <b>Check table BBP_LOCMAP. (Plants) - Manage Table Business Partner > System > Location

    BBP_COMPCODE_FAV User-Specific Favorites for Permitted Company code.</b>

    Hope this will help.

    Please reward suitable points, incase it suits your requirements.

    Regards

    - Atul

    Add comment
    10|10000 characters needed characters exceeded