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.
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.
| User | Count |
|---|---|
| 6 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |