topic Re: Internal table updation in Application Development and Automation Discussions

Internal table updation

Former Member — Tue, 18 Jul 2006 06:20:51 GMT

Hi,

Internal table declaration

data: begin of test occurs 0,

salesorg type vkorg,

palnt type werks,

end of test.

Internal table Data

Sales org Plant

XXX PPP

YYY OOO

ZZZ III

Now the plant of all records should be changed to 'PPP' without looping the test table.

Need syntax for changing plant in all records to PPP without using loop statement.

Regards,

Sreedevi P

Re: Internal table updation

Former Member — Tue, 18 Jul 2006 06:27:55 GMT

WA_TEST-PLANT = 'PPP'.

MODIFY TABLE TEST FROM WA_TEST TRANSPORTING PLANT.

Regards,

Ravi

Note : Please mark all the helpful answers

Re: Internal table updation

oliver — Tue, 18 Jul 2006 06:30:51 GMT

Hi Sreedevi,

You can do something like

data: lv_cnt type i value 0.

do.
  read table lt_itab index i.
  if sy-subrc eq 0.
*   do work here
  else.
    break.
  endif.

  i = i + 1.
enddo.

regards,

Re: Internal table updation

Former Member — Tue, 18 Jul 2006 06:32:14 GMT

HI,

wa-PLANT = 'PPP'.

MODIFY TABLE itab FROM wa TRANSPORTING plant.

Re: Internal table updation

Former Member — Tue, 18 Jul 2006 06:33:53 GMT

Hi Sreedevi,

I don't think you can do that modification of the only one field without looping the internal table.

Looping the internal table is the best alternative.

Loop at test.

test-plant = 'PPP'.

Modify test transporting plant.

Endloop.

Reward if helpful.

Regards,

Tushar

Message was edited by: Tushar Marshall Dass

Re: Internal table updation

Former Member — Tue, 18 Jul 2006 06:39:24 GMT

Hi,

you can do this way...

x_final-palnt = 'PPP'.
modify table it_final from x_final transporting plant.

this will work.

Regards

vijay

Re: Internal table updation

Former Member — Tue, 18 Jul 2006 07:51:23 GMT

Ravi,

Data declaration is

ORDER_ITEMS_IN type STRUCTURE BAPIITEMIN,

wa_order_items_in LIKE order_items_in.

Population is

wa_order_items_in-plant = 'R81N'.

MODIFY TABLE order_items_in FROM wa_order_items_in

TRANSPORTING plant.

After modify statement sy-subrc = 4 it's not modifying table order_items_in.

What is the problem?

Sreedevi

Re: Internal table updation

Former Member — Tue, 18 Jul 2006 08:13:17 GMT

Try doing it this way..

DATA: BEGIN OF TAB OCCURS 500,

FLAG TYPE C,

COMP(20) TYPE C,

END OF TAB.

CLEAR TAB-FLAG.

MODIFY TAB TRANSPORTING FLAG WHERE FLAG = 'X'.

Re: Internal table updation

Former Member — Tue, 18 Jul 2006 08:18:57 GMT

Sorry for the above code..it doesnt fit your scenario

Re: Internal table updation

Former Member — Tue, 18 Jul 2006 10:16:03 GMT

hi sridevi

wth s u r mail id

Message was edited by: Muthu kumar

Re: Internal table updation

Former Member — Tue, 18 Jul 2006 10:26:21 GMT

Sridevi,

I dont think that u will be able to modify all the records with a single statement.

Either u will have to loop at the itab or read each row of the itab using index and modify it.

loop at itab is the better option.