Skip to content

Instantly share code, notes, and snippets.

@akshayrajkumar
Created June 6, 2018 05:44
Show Gist options
  • Save akshayrajkumar/6d01202f166902fda963bf8cf07da8e8 to your computer and use it in GitHub Desktop.
Save akshayrajkumar/6d01202f166902fda963bf8cf07da8e8 to your computer and use it in GitHub Desktop.
Select parameters which match the value from a column in a table
TABLES SCARR.
SELECT * FROM SCARR.
SELECTION-SCREEN BEGIN OF BLOCK A WITH FRAME TITLE TEXT-002.
PARAMETERS: V_CARR LIKE SCARR-CARRID.
SELECTION-SCREEN END OF BLOCK A.
SELECT SINGLE * FROM SCARR
WHERE CARRID EQ V_CARR.
WRITE: / SCARR-CURRCODE,SCARR-CARRNAME, SCARR-URL HOTSPOT.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment