Skip to Content
avatar image
Former Member

In CRM, how to get Sales organisations from user id and business partners from sales organisation.?

Hello,

I would like to know, how to get the data based on below relationship.

user_id->Sales Organisation->Business Partners.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 20, 2017 at 09:04 PM

    Tto get the users organisational assignment you can use the FM RH_STRUC_GET

          CALL FUNCTION 'RH_STRUC_GET'
            EXPORTING
              act_otype    = 'US'
              act_objid    = 'THEUSER'
              act_wegid    = 'US-BP-OO'
              act_plvar    = '01'
              act_endda    = '99991231'
            TABLES...
    

    You can find the relations in table HRP1001 ( FM RH_STRUC_GET have a huge impact on performance in mass data handling!).

    The Business Partner can be found in these tables (depending on the scenario and used data)

    CRMM_BUT_LNK0010

    CRMM_BUT_LNK0011

    CRMM_BUT_LNK0020

    CRMM_BUT_LNK0021

    CRMM_BUT_LNK0030

    CRMM_BUT_LNK0031

    CRMM_BUT_LNK0140

    CRMM_BUT_LNK0141

    To get the Salesorg of single Business Partner you can use FM CRM_BUPA_SELECT_BP_SALES_AREAS

    Add comment
    10|10000 characters needed characters exceeded