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.