Hello HariKrishna-7067,
Welcome to the Microsoft Q&A forum.
ADF SAP Open Hub connector cannot directly work with BW4HANA as the BW4HANA lacks the related RFC we need.
Workaround:
By using Open Hub to directly load data to external HANA DB-> using ADF SAP HANA connector to pick up data from there.
Please refer to the #2 here: https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/1.0.10/en-US/9e2441bee89e4c7ebb445db6f8d0db96.html
I hope this helps. Please let me know if you have any further questions.