select statement

[Former Member]

Hi,

I have some records in itab.

select field3 from knkk for all entries in itab

where kunnr = itab-kunnr.

Here I have to modify table itab with field3 to particular record?

How can i do this in as efficient way?

Regards,

Subbu

[Former Member]

loop at itab.

if itab-field = specific value

itab-field3 = field3 value.

modify itab.

endif.

endloop.

Awrd POints if useful

Bhupal

[Former Member]

Hi,

check dis

ACEPS_OPEN_PERIOD_DETERMINE

[Former Member]

Hi subba reddy,

Try the below logic.It will helpful to u ok..

itab-number = 3.

itab-name = 'REDDy'. "previous name is reddi

modify itab.

Award points if helpful.

Kiran Kumar.G

Have a Nice Day..

[Former Member]

hi,

sort internal table and then use read in bineary search mode. do the code given by bhupal. that will more effective as per my knowledge.

WISH YOU HAPPY NEW YEAR

pavan

[Former Member]

Hi Pavan,

Thanks and wish you the same

Please find my query once again.

Itab:fields f1 f2 f3 f4

values 1 ab zz

2 ac zc

etc....,

Now I have to select f3 from knkk where f1 = itab-f1

and f2 = itab-f2 .

Then I have to update itab-f3 with that value.

What will be the efficient way to do that?

Thanks for the response.

Subbu

[Former Member]

hi

select f3 from xxx for all entries of table itab

where f1 = itab-f1 and f2= itab-f2.

modify table itab-f3 transporting f3.

regards,

pavan

[Former Member]

Hi,

Will you please more clear about question.

Thanks,

Sakthi C

[Former Member]

Hai,

Try the following code:

Read Table itab index i.

itab-field3 = newValue.

append itab.

where i is the index of the record which you want to modify.

Regards

[Former Member]

>

> Hi,

>

> I have some records in itab.

DATA : idx LIKE sy-tabix.

LOOP AT itab.

idx = sy-tabix.

select <fieldname> into itab-fld3 from knkk where kunnr = itab-kunnr.

if sy-subrc eq 0.

MODIFY itab INDEX idx.

endif.

ENDLOOP.

> Here I have to modify table itab with field3 to particular record?

>

> How can i do this in as efficient way?

>

> Regards,

> Subbu

[former_member653029]

Hi.,

Try this following code for your solution.

loop at itab.

select single field3 from KNKK into KNKK-field3 where kunnr = itab-kunnr.

if sy-subrc = 0.

itab-field3 = KNKK-field3

modify itab transporting field3

else.

delete itab index sy-tabix.

endif.

endloop.

Regards,

Raj.