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

[Klaus01]

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

[former_member477174]

Hi Klaus?

Wish you well?

Could you kindly share the final solution on this issue?

Sincerely,

Jiang

[mynynachau]

One of the answers were alerted for not sharing correct information and therefore being confusing. I marked mugesh.piruthiviraj as accepted. s-klaus , In case you found a different solution that was more helpful in your case please share it with the community here. Thanks.

Mynyna (SAP Community moderator)

[Mugesh · Accepted solution]

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

[HarshalVakil]

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

[former_member562518]

Hi Harshal Vakil,

Thanks very much for your kindly support,

Your solution is very detailed and useful.

Sincerely,

Jiang

[former_member562518]

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

[Klaus01]

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

[former_member477174]

Hello Harshal Vakil,

Wish you well,

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

Please noted and thanks very much.

Sincerely,

Jiang

[Klaus01]

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

[HarshalVakil]

Hello Klaus,

We had the same issue with our last project. and we followed the approach mentioned in my first comment. So it is working for sure. However, I don't have the smallest detail of each step taken. So Let me involve amitpathare who has actually executed the migration in the system. So he might be able to point you in correct direction.

However the approach 1 (Enhance record) is the one which we used. I had also checked with Amit on the phone and he mentioned similar approach.

Let say, Migrate the supplier first, then use the same ID to Enhance customer via migration. or migrate the customer first and then use the same ID, in Supplier migration template to enhance.

If you could share the sample files for (Customer as well as migration), that should help. 🙂

Or drop me a mail and I will try to check the file and align with Amit. 🙂

Cheers,

Harshal

[jesseonuoha]

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

[HarshalVakil]

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