topic select data E071K / E070 in Application Development and Automation Discussions

select data E071K / E070

former_member810309 — Thu, 25 Aug 2022 15:35:12 GMT

Hi everyone,

plz help

i have in the selection screen :

1/ SELECT-OPTIONS: typ_ob   FOR e071k-mastertype NO INTERVALS MODIF ID z,
                   nom1_ob  FOR e071k-mastername NO INTERVALS MODIF ID z,
                   nom2_ob  FOR e071k-tabkey NO INTERVALS MODIF ID z.

2/ SELECT-OPTIONS: nam_obj FOR e071-obj_name NO INTERVALS MODIF ID zz.

what is the rights requests to get the 3 data from e071k and the data from e071 to display then in different ALV ?

thanks
regards.

Re: select data E071K / E070

Sandra_Rossi — Thu, 25 Aug 2022 16:57:32 GMT

What do you think? What exact problem do you encounter?

Re: select data E071K / E070

former_member810309 — Fri, 26 Aug 2022 07:00:32 GMT

hi Sandra,
i want to get this data (mastertype, mastername, tabkey from e071k and obj_name from e071) i don't know how write correctly the 2 requests.

Re: select data E071K / E070

ascm — Fri, 26 Aug 2022 07:21:40 GMT

There is a class to select the data.

data cts_selection type ref to cl_cts_request_selection.
cts_selection = new #( i_username = sy-uname
                       it_selection_parameters = value #( ( trkorrpattern = |{ sy-sysid }K*|
                                                            client = sy-mandt
                                                            stdrequest = space
                                                            connect_req_task_conditions = 'X'
                                                            reqfunctions = sctsc_types_projects
                                                            taskfunctions = sctsc_types_tasks
                                                            reqstatus = sctsc_states_all
                                                            taskstatus = sctsc_states_all ) ) ).

data transports type strhi_requests_wd.
cts_selection->select_requests_from_db( importing et_requests = transports
                                        exceptions internal_error = 1
                                                   others         = 2 ).

Or use Funktionmodule TR_READ_REQUEST_WITH_TASKS to get the data.

Re: select data E071K / E070

Sandra_Rossi — Fri, 26 Aug 2022 08:15:57 GMT

The syntax to read tables is SELECT column1, column2, ... FROM table1 INNER JOIN table2 ON condition INTO TABLE internal_table. Indicate the tables E071K and E071, and all the columns you want. I don't know if you need other details. Which ones?

Re: select data E071K / E070

RaymondGiuseppi — Fri, 26 Aug 2022 08:35:54 GMT

Look for SELECT and JOIN in online help,