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

vanithasree

Updated on: 13-Feb-2020

66 Views

Kickstart Your Career

Get certified by completing the course

Get Started