Usage of BAPI as a lookup (pass value and return the result)

[amit.jaiswal_ATL]

Hello All,

I have a requirement where I want to pass a parameter value and a column value from the source and fetch the result from SAP table. If it returns the value then I have to use one logic using the return result and if it does not return any value back then I will have to implement another business logic. Below is the example:

Source with Service Agent ID as one column ==> BAPI (Pass Service Agent ID from the source and Business Unit ID from the parameter using TABLE_ENTRIES_GET_VIA_RFC BAPI. Use the return value for the business logic) ==> Target

Can someone please let me know the best way to implement this? Please let me know if you need more details.

Thanks,
-Amit