‎2022 Jun 02 2:18 PM
I am trying to produce a table for multiple selections of users at once.
My code works for one user but the client wants to be able to use the multiple selection to enter a group of 5 users at once to view a table for each. Is there a way to loop through all the selections in the multiple selection and write out a table for each?
SELECT-OPTIONS: P_USER FOR AGR_USERS-UNAME NO INTERVALS.
SELECT *
INTO CORRESPONDING FIELDS OF TABLE ITAB_USER_ROLES
WHERE UNAME EQ P_USER-LOW.
‎2022 Jun 02 2:36 PM
Hi Owen,
P_USER is a Range structure. You can simply use it as follows:
SELECT *
INTO CORRESPONDING FIELDS OF TABLE ITAB_USER_ROLES
WHERE UNAME IN P_USER.
‎2022 Jun 02 2:36 PM
Hi Owen,
P_USER is a Range structure. You can simply use it as follows:
SELECT *
INTO CORRESPONDING FIELDS OF TABLE ITAB_USER_ROLES
WHERE UNAME IN P_USER.