topic Re: read table... in Application Development and Automation Discussions

read table...

Former Member — Tue, 10 Jul 2007 11:11:00 GMT

Hi all,

I have a select statement in which i am retrieving values in a internal table.

how to use the values of that table in the next if statements...

for ex:

SELECT rfarea docct rbukrs ryear docnr

ksl racct sgtxt cpudt usnam

FROM glpca client specified INTO TABLE gt_tpca

WHERE docnr EQ gw_idoc-belnr

AND rclnt EQ sy-mandt.

Now i want to check if the field racct of table gt_tpca is the value in select options.

Based on that i want to write a perfrom statement.

So how to get that value.

thanks

Jareer

Re: read table...

Former Member — Tue, 10 Jul 2007 11:13:12 GMT

Write as

loop at gt_tpca where racct in s_racct.

..perform...

endloop.

Reward points for useful Answers

Regards

Anji

Re: read table...

Former Member — Tue, 10 Jul 2007 11:13:41 GMT

SELECT rfarea docct rbukrs ryear docnr

ksl racct sgtxt cpudt usnam

FROM glpca client specified INTO TABLE gt_tpca

WHERE docnr EQ gw_idoc-belnr

AND rclnt EQ sy-mandt.

LOOP AT GT_TPCA.

IF GT_TPCA-<field> BT <select-option>.

perform <required task>.

ENDIF.

ENDLOOP.

Regards,

Pavan P.

Re: read table...

Former Member — Tue, 10 Jul 2007 11:14:01 GMT

Hi,


SELECT rfarea docct rbukrs ryear docnr
ksl racct sgtxt cpudt usnam
FROM glpca client specified INTO TABLE gt_tpca
WHERE docnr EQ gw_idoc-belnr
AND rclnt EQ sy-mandt and
        racct  in s_racct .  " This will check the racct from Select Options

Regards

Sudheer

Re: read table...

rodrigo_paisante3 — Tue, 10 Jul 2007 11:14:22 GMT

Hi,

SELECT rfarea docct rbukrs ryear docnr

ksl racct sgtxt cpudt usnam

FROM glpca client specified INTO TABLE gt_tpca

WHERE docnr EQ gw_idoc-belnr

AND rclnt EQ sy-mandt.

loop at gt_tpca.

if gt_tpca-racct in s_value.

perform x.

endif.

endloop.

regards

Re: read table...

Former Member — Tue, 10 Jul 2007 11:16:01 GMT

Hi jareer,

After ur select statemnt, Loop at the internal in which u got the data from the select statement.

Ex : Loop at gt_itab.

read table gt_itab .....( Press F1 on READ, to get the syntax )

if sy-subrc = 0.

check ur condition.

endif.

endloop.

Re: read table...

former_member491305 — Tue, 10 Jul 2007 11:19:23 GMT

Hi,

You can directly give that in where condition of select query using in operator..If you still need the remaining value or for some other purpose...

you can do like this.

SELECT rfarea docct rbukrs ryear docnr

ksl racct sgtxt cpudt usnam

FROM glpca client specified INTO TABLE gt_tpca

WHERE docnr EQ gw_idoc-belnr

AND rclnt EQ sy-mandt.

LOOP AT gt_tpca into x_m WHERE racct IN s_racct.

exit.

ENDLOOP.

if sy-subrc = 0.

perform <forma name>.

endif.

Re: read table...

Former Member — Tue, 10 Jul 2007 11:27:15 GMT

Here is the code for yours ...

select-options  :   s_racct    for glpca -racct .

SELECT rfarea docct rbukrs ryear docnr
ksl racct sgtxt cpudt usnam
FROM glpca client specified INTO TABLE gt_tpca
WHERE docnr EQ gw_idoc-belnr
AND rclnt EQ sy-mandt and
        racct  in s_racct .

the values are filterred while selecting from the database table glpca with in the

select-ooption range as low & high

reward points if it is usefull .....

Girish

Re: read table...

Former Member — Tue, 10 Jul 2007 11:46:40 GMT

Hey Khan,

First of all I wanna suggest u that if u want a perform in which u want any logic based on condition that 'racct of table gt_tpca is the value in select options'

use that condition in Select statement itself rather than writing a condition later after the Select statement.

SELECT rfarea docct rbukrs ryear docnr

ksl racct sgtxt cpudt usnam

FROM glpca client specified INTO TABLE gt_tpca

WHERE racct in S_RACCT

docnr EQ gw_idoc-belnr AND

rclnt EQ sy-mandt.

Reward points if usefull...

Re: read table...

Former Member — Tue, 10 Jul 2007 11:48:06 GMT

Dear Jareer,

You have 2 options

1) Filter the condition in "Select statement" before passing into the internal table gt_tpca

2) Once it is passed into the internal table you can use " loop..endloop" for your requirement of checking for a specific "racct"

Option 1 is better in terms of not using loop/endloop because it slows down your performance to the extent of data contained in the table glpca and filtering is done in an initial stage

For this use ranges like

if P_racct is your field in select options

then

SELECT rfarea docct rbukrs ryear docnr

ksl racct sgtxt cpudt usnam

FROM glpca client specified INTO TABLE gt_tpca

WHERE docnr EQ gw_idoc-belnr

AND rclnt EQ sy-mandt

AND racct in P_racct.

Option2 is to be used if you need not filter at an initial stage for racct

That can be done as follows

You need to use the values for a another specific "racct" operation

loop at gt_tpca where racct = 'XXXX" "for a single racct value

Perform your operation...

endloop.

For multiple select options you can use case/if..endif inside loops '

or try " loop at gt_tpca where racct in P_racct " which i have not tried yet

Hope it clarifies your doubt

Regards

Byju

Re: read table...

Former Member — Tue, 10 Jul 2007 11:55:15 GMT

SELECT rfarea docct rbukrs ryear docnr

ksl racct sgtxt cpudt usnam

FROM glpca INTO TABLE gt_tpca

WHERE docnr EQ gw_idoc-belnr

AND rclnt EQ sy-mandt.

loop at gt_tpca.

if gt_tpca-racct in s_value.

perform x.

endif.

endloop

reward if useful.

Re: read table...

Former Member — Tue, 10 Jul 2007 12:02:24 GMT

Hi jareer,

1. Now i want to check if the field racct of table gt_tpca is the value in select options.

LOOP AT GT_TPCA.

IF GT_TPCA-RACCT IN MYSELECTOPTION.

*---- CODE

ENDIF.

regards,

amit m.

Re: read table...

Former Member — Wed, 11 Jul 2007 08:45:53 GMT

Hi All,

The problem here is there are some select statements nested in that perform statement, so theres a problem of performance here arising.so how can i aviod this.

Thanks

Jareer.

Re: read table...

rodrigo_paisante3 — Wed, 11 Jul 2007 18:17:08 GMT

Hi again,

Use the transactions se30 and st05 to test performance of your routines and program.

There you will see some examples and tips to rewrite your code.

Some tips:

Change SELECT... ENDSELECT to SELECT...INTO TABLE

use SELECT ... FOR ALL ENTRIES when possible

use READ TABLE... BINARY SEARCH.

use the command SORT before read or loop a table.

If useful, please reward points.

Regards

Re: read table...

kesavadas_thekkillath — Thu, 12 Jul 2007 03:24:42 GMT

if u want only the value gt_tpca then include it in select statement.

or try this

*****************************************

loop at itab where <col> = 'gt_tpca'.

flg = 1.

exit.

endloop.

if flg = 1.

perform <name>

flg = 0.

endif.

Re: read table...

kesavadas_thekkillath — Thu, 12 Jul 2007 04:04:37 GMT

sorry its like this

if u want only the value gt_tpca then include it in select statement.

or try this

*****************************************

loop at itab where <col> = <sel option value>

flg = 1.

exit.

endloop.

if flg = 1.

perform <name>

flg = 0.

endif.

Re: read table...

Former Member — Thu, 12 Jul 2007 04:18:46 GMT

SELECT rfarea docct rbukrs ryear docnr

ksl racct sgtxt cpudt usnam

FROM glpca client specified INTO TABLE gt_tpca

WHERE docnr EQ gw_idoc-belnr

AND rclnt EQ sy-mandt.

READ TABLE gt_tpca INDEX i.

PERFORM get_data USING gt_tpca-racct.