Analogous to IN operator of SQL in SAP

You can get similar things done in many ways. You can use an internal table usage or a range table.

Let me showcase an example with an internal table for your reference.

SELECT Id, Name, DOB
FROM sEmployee
INTO CORRESPONDING FIELDS OF TABLE result_tab
FOR ALL ENTRIES IN internal_tab // internal_tab is an internal table defined with columns
WHERE Id = internal_tab -Id
AND Name = internal_tab –Name