External Business Partners to be loaded

[Former Member]

Hi,

We are working on CRM 4.0. We want to upload some external business partners into CRM. These business partners would be used in MSA.

For uploading the business partners we want to do an ABAP development instead of using ELM or LSMW.

Our Assumptions are as follows

1> When we create a business partner(Sales customer,Ship to party,Sold to party) or a business partner of type contact person through transaction "bp" the entry for the same is made in but000 table on CRM.

2>When we define relationship between the contact person and the business partner by editing the contact person in transaction "bp" an entry for the same is made in table but050.

3> While creating the business partner (Except type contact person) we mention the R/3 account group under tab "Classification". However we found that this entry is not made in either table but000 or but050 on CRM side.

4> On investigation we found that an entry for the account group is made in CRM table "crmm_but_frg0041" when a business partner is saved.

5>Since we have activated the mobile bridge the entry for the business partner/contact person is replicated in the CDB table smokna1.This table contains a field for account group.

We are going for an ABAP development wherein the entries of business partners from the csv file in the required format

would update tables but000,but050 and crmm_but_frg0041 of CRM. Once these tables are updated by our program the mobile bidge would update these entries in the CDB table smokna1 so that the business partners/contact person are available in MSA when the contrans is run.

This activity of loading Extrenal business partner is a one time activity.

We would like to know if there any other tables that need to be updated to make this functionality work.

Thanks,

Milind

[Former Member]

Hi Yatin,

All your so called assumptions are correct. But, I should say that whoever gave you the idea of directly populating the tables doesnt know anything about what he is doing.

In case you are interested in FM - you can use - CRMXIF_PARTNER_SAVE & CRMXIF_PARTNER_REL_SAVE .

-Liju

[Former Member]

HI

Is there any other bapi or fm which is used to check the "is_prospect" field in the table CRMM_BUT_FRG0041.

[Former Member]

Hi Yatin,

Use the BAPI - BAPI_BUPR_RELATIONSHIP_CREATE for creating the relationships,

Use the BAPI - BAPI_BUPA_FRG0040_CREATE for adding the account group to the Business Partner.

Since you have already activated the Mobile bridge, the entries should flow to the respective tables of MSA.

Please reward points if solution is helpful.

Regards,

Prabhas.

[Former Member]

Hi Yatin,

I do not recommend to updated directly the BP master tables. Why do not use BAPI and FM to create the external BP?

Find below an example to create an organization:

DATA:
  v_category              TYPE bu_type VALUE '2',
  v_partner               TYPE bu_partner,
  s_centraldata     TYPE bapibus1006_central,
  s_org_centraldata TYPE bapibus1006_central_organ,
  t_return          TYPE TABLE OF bapiret2.

s_centraldata-searchterm1 = 'Find'.
s_centraldata-searchterm2 = 'me!'.
s_org_centraldata-name1 = 'Test BP Creation'.


CALL FUNCTION 'BAPI_BUPA_CREATE_FROM_DATA'
  EXPORTING
    partnercategory         = v_category
    centraldata             = s_centraldata
    centraldataorganization = s_org_centraldata
    accept_error            = 'X'
  IMPORTING
    businesspartner         = v_partner
  TABLES
    return                  = t_return.


CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'.