Read stock level from another database

Hello!

I need to read stock level from one(separate/different) SQL database and then update SAP with that data.

E.g. if I am to check the Item master data and then click on the Stock data.

Update should be done according to product number, which, of course, would be the same in both databases - external and SAP.

I was thinking to implement something like this...

SELECT T0.[U_Lok] FROM OITW T0 WHERE T0.ItemCode = RDR1.ItemCode

This was made to check the location of the product in the user field U_Lok.

Thanks,

Dejan