topic Re: Data transfer between 2 it_tables in Application Development and Automation Discussions

Data transfer between 2 it_tables

Former Member — Thu, 12 Mar 2009 07:36:56 GMT

Hi all,

i have got some data related to sales into an it_table pertaining to G/L account for a date range.

however i want to shift this data to another internal table by putting further restriction by using where condition.

But, i want to do this without looping on my previous internal table.

please help me out with a solution.

Regards,

Kaustubh

Re: Data transfer between 2 it_tables

Former Member — Thu, 12 Mar 2009 07:38:34 GMT

my second internal table is of the same type as of the first.

Re: Data transfer between 2 it_tables

Former Member — Thu, 12 Mar 2009 07:38:48 GMT

if the structure of both the internal tables are same , use Append line of statement . you can sue where condition in the same.

Re: Data transfer between 2 it_tables

Former Member — Thu, 12 Mar 2009 07:40:55 GMT

Hi,

If the table structures are same and the where conditions are not dependent of the first table.

You can write.

ITAB2[] = ITAB1[].

DELETE ITAB WHERE <condition>.

With Best Regards,

Navneet Chaubey

Re: Data transfer between 2 it_tables

sreeramkumar_madisetty — Thu, 12 Mar 2009 07:41:33 GMT

ITAB2[] = ITAB1[].

That's it for your case.

Regards,

Sreeram Kumar.Madisetty

Re: Data transfer between 2 it_tables

Former Member — Thu, 12 Mar 2009 07:43:32 GMT

Can you tell me why you dont want to use LOOP...ENDLOOP.

Re: Data transfer between 2 it_tables

Former Member — Thu, 12 Mar 2009 07:43:57 GMT

Hi,

If structure of both the internal tables are same then simple

internaltable2[] = intrenaltable1[] should work that actually copies the data from first to sec adn then

either loop at intrenaltable2 and delete the records or simply delete intrenaltable2 where condition should work.

Pooja

Re: Data transfer between 2 it_tables

Former Member — Thu, 12 Mar 2009 07:45:56 GMT

If both internal tables are having the same structure you can use this statement,

it_tab1 = it_tab2.

Regards,

Joan

Re: Data transfer between 2 it_tables

Former Member — Thu, 12 Mar 2009 07:46:12 GMT

Hi Santosh,

i tried your suggestion. the following is the syntax i have written:

append lines of it_revenue to it_rev where budat = p_bukrs.

following is the error i got when i executed:

".", "ASSIGNING <fs>" or "REFERENCE INTO data-reference" expected after "IT_REV". -

please help.

Re: Data transfer between 2 it_tables

Former Member — Thu, 12 Mar 2009 07:47:53 GMT

the reason being to avoid looping on a large amount of data in a practical scenario

Regards,

kaustubh

Re: Data transfer between 2 it_tables

Former Member — Thu, 12 Mar 2009 07:49:47 GMT

Hi Kaustubh,

You can try it this way:

Data:
  w_lines  type i,
  w_index type i value 1.
Describe table itab_1 lines w_lines.

While w_index le w_lines.
  Read table itab_1 into wa index w_index.
  If wa_field eq 'XYZ'. " check youe condition here
    Append wa to itab_2.
  Endif.
  w_index = w_index + 1.
Endwhile.

With luck,

Pritam.

Re: Data transfer between 2 it_tables

Former Member — Thu, 12 Mar 2009 07:57:02 GMT

hi,

thank you for your suggestion but this would the same as looping on the first table as the data in the second table now is the same as it was in the first. looping on this would mean the same thing.

please correct me if im wrong.

Re: Data transfer between 2 it_tables

Former Member — Thu, 12 Mar 2009 07:59:10 GMT

Hi,

can you please check

To read the contents of internal tables for further processing, you can use either the LOOP or the READ statement.

Reading Internal Tables Line by Line

You use the the LOOP statement to read internal tables line by line.

LOOP AT <itab> [INTO <wa>] [WHERE <condition>].

ENDLOOP.

Reading Single Lines Using the Index

You can select a single line by the READ statement:

READ TABLE <itab> [INTO <wa>] INDEX <idx>.

Thanks and regrds

Durga.K

Re: Data transfer between 2 it_tables

Former Member — Thu, 12 Mar 2009 08:17:25 GMT

The best way to avoid the loop would be to first append all the lines of the source itab to target itab, then delete the unwanted entries from the target tab.


append lines of itab to itab_1.
delete itab_1 where ( logical_expresion ) . " delete the entries you dont want.

regards,

Advait

Re: Data transfer between 2 it_tables

Former Member — Thu, 12 Mar 2009 08:36:40 GMT

@ advait

thanks a lot. it worked. exactly what i was looking out for.

thanks everyone else for your valuable feedbacks.

regards,

kaustubh