Select or formated search from other company.

[gonzalogomez]

Hello everybody

In version 9.3 we have formatted searches that bring data from other companies. Also queries that bring data from various companies. In version 10.0 these options I see that they are overridden or disabled. How can I enable these queries?

[SonTran · Accepted solution]

Hi,

It is behavior change in Version 10. You can refer the SAP Note 2907995

https://forum.sapb1.vn/community/sapnote/2907995-cannot-query-data-from-other-databases-using-sap-bu...

Hope this helps,

Son Tran

[hdolenec]

Hi,

FMS is not disabled. The problem is that in version 9.3, all companies in B1 connected to DB with same admin user that had privileges for all those companies. In version 10.0 each company is assigned a specific user for connecting to DB, and by default this user is only authorized for that single company. In order for your FMS to work, you must determine the DB user for your company, and then grant this user select privileges for other B1 companies.

[gonzalogomez]

Thanks son7346_2385_83 with the workaround of this note, Solved.

[gonzalogomez]

ok, thank you.

I´m reading the SAP Note: 2907995

i´ll come back to tell you about the workaround proposed