select data E071K / E070

[former_member810309]

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.

[Sandra_Rossi]

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

[former_member810309]

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.

[ascm]

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.

[Sandra_Rossi]

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?

[raymond_giuseppi]

Look for SELECT and JOIN in online help,