Skip to Content

Migration of Business Partners with two roles (suppier&account)

Hi,

we are facing the issue, that a customer has some thousand of customers, that are as well suppliers. As this cannot be managed manually: Is there any way to do migration? Sure, we can do this using different accountID/supplierID - but than some of ByD's service will not work.

Any ideas?

Kind Regards,

Klaus

Add comment
10|10000 characters needed characters exceeded

6 Answers

  • Best Answer
    Posted on Nov 29, 2019 at 07:55 AM

    Dear Klaus Hoffmann,

    It is not possible to migration two roles for any Business Partner. In the case described above, the only option is to migration the Accounts through the Migration tool and then create Suppliers manually from the Business Partner work center using 'Create As'.

    Please share your feedback in Customer influence forum - https://influence.sap.com/sap/ino/#/campaign/886

    Regards,

    Mugesh P

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 18, 2019 at 07:30 AM

    Dear Harshal,

    I will drop you and Amit a mail with the respective data, as the files are not accepted in SCN.

    Kind Regards and thanks for your input.

    Klaus

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 28, 2019 at 10:21 AM

    Hello,

    For all those who are facing similar issue and looking for solution :

    Tthere are multiple Approaches to this problem.

    1) Migration Approach :

    This approach will only work when you have created business partners only (Without any roles). If you migrate business partners as customers via migration activity : Migration of customers and then later try to enhance the same Business partner as Supplier, this approach does not work.

    - Create the business partners first via migration tool. -> This can be done via the Business configuration activity : Migration of Business partners

    - These business partners can then be enhanced using the Migration for the customer / Supplier. -> This can be done via the Migration of Customer or Migration of Supplier activity. However you will need to use the same business partner ID that you use in the migration file for the Business partner.

    2) Web service Approach : - For Any Business partner Where Customer or Supplier role is already assigned, you can use the related web service.

    For example : in the managecustomerin web service, there is an indicator to create the customer from the existing business partner. the same tag is also available in the managesupplierin Web service.

    Tag that you will need to set as true.: <CreateFromBusinessPartnerIndicator>?</CreateFromBusinessPartnerIndicator>

    Once you pass all the other relevant information which is required in order to create the Supplier from Customer or Customer from Supplier or Customer from Employee. system should be able to handle the request and assign the related role to existing Business partner.

    There are tools that are available in the below mentioned blog from Knut Heusermann . However, when I tried using them the last time about a month ago. It did not work. So what I had done was to build a similar update request but for multiple business partners (Basically hard-coding some of the values with the Use of Visual Basic and excel macros).

    https://blogs.sap.com/2015/05/15/mass-changes-of-byd-data-using-excel-and-byd-web-services/

    So the blog above is also a good source of the information which you are looking for.Let me know if there are any further questions.Regards,Harshal
    Add comment
    10|10000 characters needed characters exceeded

    • Hi Harshal Vakil,

      After my test, I found that the data cannot be displayed in BP list via business partner migration tool.

      If I migration the customer / Supplier via the customer/ supplier migration tool directly, the data upload successfully.

      Could you kindly help to explain the reason of the phenomenon ?

      Sincerely,

      Jiang

  • Posted on Apr 16, 2019 at 12:56 PM

    Hello Claus,

    On the business partner view, you can multi-select and click on create as and assign the roles.

    Yes, when you have high number of business partner, this maintenance would become a challenge.

    Other Option is to migrate them as customer and Suppliers via migration or importing the files and in both the files use the same ID.
    If you import the business partner file first then only option to assign role is manually. Instead of Migrating the business partner, Migrate Either customer or supplier (Let say customer) which in turn will create the Business partner and assign the role. For the other role (Supplier), Use the same ID that you have as account ID and migrate them with Supplier details.

    During the migration system checks for the existing Business partner IDs and should be able to assign the role instead of creating a new Business partner altogether.

    Please try this one in test system first and check the result.

    I hope this will help you.


    Regards,

    Harshal

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 18, 2019 at 06:14 AM

    Dear Harshal,

    I tried this already with two properties. Took an existing supplier and tried to migrate it as a customer.

    1) Enhance existing records: The migration tool tells me: Update not possible; specified data for CUSTOMER with key INTERNAL_ID = `0001000618` does not exist

    2) Add new records: Business partner (customer, supplier,...) '1000618' has been migrated already

    And no migration is done.

    So this doesn't work.

    And further tips?

    Kind Regards,

    Klaus

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Klaus/Harshal/Amit,

      We have the same issue. we need to migrate about 20000 accounts that are also suppliers maintaining the same ID. The migration tool tells me: Update not possible; specified data for CUSTOMER with key INTERNAL_ID = `0001000618` does not exist.

      Any tips or ideas?

      Kindly assist.

      Chinedu

  • Posted on Dec 02, 2019 at 02:20 AM

    Hello Harshal Vakil,

    Wish you well,

    After my confirmation,the Web service Approach is well done.

    Please noted and thanks very much.

    Sincerely,

    Jiang

    Add comment
    10|10000 characters needed characters exceeded