Consolidate 2 different databases

[vasileiosfasolis]

Hello to all!

i am interested to get reports, run MRP etc in two different databases which are placed in the same Server.

is it possible such a thing?

if yes the requirements and what else can i do

thank you very much for your time

the version of sap is 8.82

[kothandaraman_nagarajan · Accepted solution]

Hi,

Yes possible to get. Please follow the same query to retrieve data from two different database.

SELECT 'Corporate-'+ '' +T3.[WhsName] AS
'Loc/Whse',
T2.[ItmsGrpNam] AS 'Item Group',
T0.[ItemCode] AS
'Item',
T1.[ItemName] AS 'Item Description',
T0.[OnHand] AS 'On
Hand',
T0.[OnOrder] AS 'On Order'
FROM SBODemoUS.dbo.OITW T0

INNER JOIN SBODemoUS.dbo.OITM T1 ON T0.ItemCode =
T1.ItemCode
INNER JOIN SBODemoUS.dbo.OITB T2 ON T1.ItmsGrpCod =
T2.ItmsGrpCod
INNER JOIN SBODemoUS.dbo.OWHS T3 ON T0.WhsCode =
T3.WhsCode
WHERE T0.[ItemCode] = [%0] AND T0.[OnHand] > 0
UNION
ALL
SELECT 'Dallas-'+ '' +T3.[WhsName] AS
'Loc/Whse',
T2.[ItmsGrpNam] AS 'Item Group',
T0.[ItemCode] AS
'Item',
T1.[ItemName] AS 'Item Description',
T0.[OnHand] AS 'On
Hand',
T0.[OnOrder] AS 'On Order'
FROM SBODemo_Dallas.dbo.OITW
T0
INNER JOIN SBODemo_Dallas.dbo.OITM T1 ON T0.ItemCode = T1.ItemCode
INNER JOIN SBODemo_Dallas.dbo.OITB T2 ON T1.ItmsGrpCod
= T2.ItmsGrpCod
INNER JOIN SBODemo_Dallas.dbo.OWHS T3 ON
T0.WhsCode = T3.WhsCode
WHERE T0.[ItemCode] = [%0] AND T0.[OnHand]
> 0

Note : Replace with your database for high lighted.

Thanks & Regards,

Nagarajan

[vasileiosfasolis · Accepted solution]

Hi Naga

the above query is a simple query that i can manage by using linked servers as i know

is there any way to do it through SBO and get results not only for reports but for MRP as well?

[Johan_H · Accepted solution]

Hi Vasileios,

In the B1 client there are only a few financial reports that you can run against separate databases.

Any which way you throw it, if you want to run B1 system reports on two different company databases, you have to first combine the data from both into a single company database.

For your purposes you can use the Intercompany Integration Solution for SAP Business One like Balaji Sampath suggested (contact your SAP Partner) or you have to build all the reports you need yourself, using sql queries and possibly the SDK, if you need MRP functionality.

Regards,

Johan

[vasileiosfasolis · Accepted solution]

Hi Johan

thank you very much for your instant comment.

is there any way to check the functionality of Intercompany Addon because i do not have access to market place to read the manuals?

I actually am interested on running MRP in 2 different databases

[Johan_H · Accepted solution]

Ok, I found this documentation on the SAP Service Marketplace, I hope it helps.

Remember, this will only consolidate data between company databases, it has nothing to do with MRP per say. That you may have to figure out separately.

[Former Member]

Hi,

Consolidate may only apply to financial transactions. To the MRP level, there may not have option in B1 even through any reporting tools.

Thanks,

Gordon

[former_member205766]

Hi

Check this thread it may helps you

With Regards

Balaji

[vasileiosfasolis]

Hi

unfortunatelly i do not have access to market place in order to check the addon