topic Re: read lines from internal table in Application Development and Automation Discussions

read lines from internal table

Former Member — Mon, 12 Mar 2007 15:22:46 GMT

I have an internal table with three columns say.

emp_id emp_name emp_position

1 abc supervisor

2 xya manager

3 kok executive

i have a selection screen

parameter: emp_id,

emp_name,

emp_position.

now i enter the required fields in the parameter. say

emp_id = 3

emp_name = kok

emp_position = senior executive

then the internal table field should look as follows

emp_id emp_name emp_position

1 abc supervisor

2 xya manager

3 kok senior executive <- see the last column of

last row.

how do we to this.

pls help me

Re: read lines from internal table

Former Member — Mon, 12 Mar 2007 15:25:15 GMT

read table itab

with key emp_id = emp_id.

if sy-subrc eq 0.

itab-emp_position = emp_position.

modify itab.

endif.

Re: read lines from internal table

Former Member — Mon, 12 Mar 2007 15:32:24 GMT

sort itab by  emp_id emp_name emp_position.

read table itab with key emp_id = emp_id
                                   emp_name = emp_name
                                   emp_position = emp_position BINARY SEARCH.

if sy-subrc eq 0.
 write : /  itab-emp_id itab-emp_name itab-emp_position.
endif.

Re: read lines from internal table

Former Member — Mon, 12 Mar 2007 15:33:43 GMT

hi,

if your int. table has header line,do like the below.

move emp_position to itab-emp_position.

loop at itab.

modify itab transporting emp_position where emp_id = itab-emp_id

and emp_name = itab-emp_name.

endloop.

if it doesn't have header line,decalre work area explicitly and do as below,

loop at temp into wa_itab.

wa_itab-price = '5000'.

modify itab from wa_itab transporting price where connid = temp-conn.

skip.

endloop.

Regards,

award points for al helpful answers

Message was edited by:

sowjanya s

Re: read lines from internal table

Former Member — Mon, 12 Mar 2007 15:35:23 GMT

Hello John,

DO like this:

Sort Itab by emp_id emp_name emp_position.

Read table itab with key emp_id = emp_id
                                   emp_name = emp_name
                                     emp_position = emp_postion.

if sy-subrc eq 0.
process...
endif.

Regards,

Vasanth

Re: read lines from internal table

Former Member — Mon, 12 Mar 2007 15:40:13 GMT

try this out. It will work

LOOP AT itab WHERE emp_id EQ emp_id.(This is the parameter)

itab-emp_name = emp_name.

itab-emp_position = emp_position.

MODIFY itab.

ENDLOOP.

Award points if found helpful.

Re: read lines from internal table

Former Member — Mon, 12 Mar 2007 15:40:45 GMT

Hi,

Check this code:

FIELD-SYMBOLS: <FS> LIKE LINE OF ITAB.

SORT ITAB BY EMP_ID.

READ TABLE ITAB ASIGNING <FS>

WITH KEY EMP_ID = EMP_ID

BINARY SEARCH.

IF SY-SUBRC EQ 0.

<FS>-EMP_NAME = EMP_NAME.

<FS>-EMP_POSITION = EMP_POSITION.

ENDIF.

Re: read lines from internal table

Former Member — Mon, 12 Mar 2007 15:47:30 GMT

hi,

my fault. in the paramter id

parameter: emp_id,

emp_column, *its not emp_name

emp_value. *its not emp_position

so its the column name which i have to enter in the second paramter.

say if enter 'emp_postion' as the value in emp_column in the paramter field.

then value of emp_postion has to change with the emp_value.

this is my issue......

i am sorry for misleading you guys.

thank you