topic read table with condition types in Application Development and Automation Discussions

read table with condition types

pashasapcha — Fri, 24 Nov 2023 12:35:39 GMT

Hi, gurus,

I have requirement where I have multiple KSCHL (condition types) in bset table.

I have written the select query with the required condition types as below.

You can see in the above image that multiple kschl we have used in select query.

You can see in the below we are using multiple read tables as below.

Now i have to READ it with each KSCHL which is taken alot of space. I want to get all the

values of ktosl in single read table.

I am expecting something like this.

READ TABLE lt_bset INTO ls_bset WITH KEY bukrs = ls_bseg-bukrs

belnr = ls_bseg-belnr

gjahr = ls_bseg-gjahr

kschl = 'JICR' and kschl = 'JISR 'and kschl = 'JICN'

txgrp = ls_bseg-txgrp.

is it possible ?

or let me know if there is any way so that I can use only one read table.

The following is the select query of bset table.

Re: read table with condition types

Sandra_Rossi — Fri, 24 Nov 2023 13:26:19 GMT

In programming theory, your request would lead to nothing found:

kschl = 'JICR' and kschl = 'JIsR' and kschl = 'JIcn'

You should ask:

kschl = 'JICR' or kschl = 'JIsR' or kschl = 'JIcn'

Re: read table with condition types

Sandra_Rossi — Fri, 24 Nov 2023 13:28:30 GMT

If your question is about performance (if I understand well "taken alot of space"), you should better say it and not asking how to do something that you think would solve the issue. See XY problem - Wikipedia.

Re: read table with condition types

thilakan_t — Mon, 27 Nov 2023 04:11:31 GMT

Add all the condition types in a range table and use it in SELECT WHERE clause(KSCHL in lr_kschl).

Note: The range itab can not be used in READ but you can LOOP the itab and use it in WHERE clause.

LOOP it_bset into ls_bset WHERE ..."othet conditions
                                KSCHL in lr_kschl.
....calculations
ENDLOOP.

Re: read table with condition types

ThorstenHoefer — Mon, 27 Nov 2023 15:25:23 GMT

You can create a nested table.

First take all key fields and add an additional column as table of KSCHL.

t_kschl type table of ....

select ...
into table  @data(lt_data)

loop at lt_data into wa_data.
  read table lth_nested assigning field-symbol(<wa_nested>) 
  from corresponding #(wa_data).
  if sy-subrc is not initial.
    insert corresponding #(wa_data) into table lth_nested assigning <wa_nested>. 
  endif.
  insert wa_data-kschl into table  <wa_nested>-t_kschl.
endloop.

read table lth_nested assigning <wa_nested> with table key ...
check sy-subrc is initial.
loop at <wa_nested>-t_kschl into ....
endloop.