topic Move Data Between Completely Different Tables in Application Development and Automation Discussions

Move Data Between Completely Different Tables

Former Member — Fri, 04 Jan 2013 04:53:27 GMT

Hi All,

I have a small requirement. I have declared an internal table dynamically. Now I have to move data between two tables with not even a single common field. I just want the data should move from Column1 to Column1 and so on. I do not know the no of columns of the second table as it will vary between 1 and 128. The former table from which I have to move the data has 128 columns.

Thanks & Regards,

Chandni Sharma.

Re: Move Data Between Completely Different Tables

vinoth_aruldass — Fri, 04 Jan 2013 05:04:41 GMT

loop the first internal table

validate the column of the second internal table and put the table value.

append second internal table

hope it helps,

Vinoth.

Re: Move Data Between Completely Different Tables

Former Member — Fri, 04 Jan 2013 05:08:41 GMT

Hi Vinoth, my question is I do not have the names of the columns known. How should I validate the columns and there is no single common column between the two. How should move between the two. It Gives me a Dump saying the Two are incompatible and not convertible.

Thanks,

Chandni Sharma.

Re: Move Data Between Completely Different Tables

kakshat — Fri, 04 Jan 2013 05:11:50 GMT

Since you have to map the nth column of the first internal table to the nth column of the second internal table, you can use the ASSIGN COMPONENT <comp> OF STRUCTURE statement. In <comp> you can use a counter which would represent the column number.

Re: Move Data Between Completely Different Tables

Former Member — Fri, 04 Jan 2013 05:39:38 GMT

Assign Component will pick the Nth column of first table but how to assign it to the Nth column of the second table.

Thanks,

Chandni Sharma.

Re: Move Data Between Completely Different Tables

Former Member — Fri, 04 Jan 2013 05:42:33 GMT

I have concatenated the content of first table into a string separated by comma but how to split the string at ',' into columns of the table.

for eg:

if string is 1,2,3,4,5,6.

Table or work area should contain wa-col1 = 1. wa-col2 = 2. wa-col3 = 3. wa-col4 = 4. and so on.

Thanks,

Chandni Sharma.

Re: Move Data Between Completely Different Tables

kakshat — Fri, 04 Jan 2013 05:45:40 GMT

You can use two field-symbols - one for the source table and one for the target.

Re: Move Data Between Completely Different Tables

Former Member — Fri, 04 Jan 2013 05:53:40 GMT

Hi ,

try this..

Data : p1 type c,

p2 type c,

p3 type c,

comma type c value','. " comma splitter

now use split..

SPLIT string AT comma into p1 p2 p3....

now move p1... pn to ur work area and append to intab..

one more thing .. if u hav a int table struct then use split like this

SPLIT string AT comma INTO TABLE int_struct

then use this int_struct( here with 128 fields as you said ) for ur calculations

Thanks

Ben

Re: Move Data Between Completely Different Tables

Former Member — Fri, 04 Jan 2013 06:04:02 GMT

Hi,

I can not specify p1 p2 p3 because first I do not know the Number of fields I'l get and the names of the columns of the table formed since it has been created dynamically.

and can not use SPLIT string AT comma INTO TABLE int_struct since this gives me output.

wa-col1 wa-col2 wa-col3 .....

Thanks,

Chandni Sharma

Re: Move Data Between Completely Different Tables

Former Member — Fri, 04 Jan 2013 06:05:50 GMT

If I understood correctly what you said, You meant take the name of the field of the dynamic internal table into a field symbol and assign that component a value from first table.

Please help me get the name of the field of Dynamic internal Table into a field symbol. I am struggling with that only.

Thanks,

Chandni Sharma.

Re: Move Data Between Completely Different Tables

Former Member — Fri, 04 Jan 2013 06:10:58 GMT

Hi Chandni

Can you try transposing the result of SPLIT into table result in int_struct... .

Just loop through the int_struct and modify the int int_struct with index .... if this satisfy ur requirement...

--- for this you need to have another int tab of same struct and need to modify this intab on looping the original

Thanks Ben

Re: Move Data Between Completely Different Tables

kakshat — Fri, 04 Jan 2013 06:16:40 GMT

No, I meant take the nth field from first internal table and set it to the nth field from the second internal table. Something like below.

LOOP AT itab1 ASSIGNING <fs_1>.

DO 128 TIMES. " 128 = no. of fields in itab1

ASSIGN COMPONENT sy-index OF STRUCTURE <fs_1> TO <fs_val1>.

ASSIGN COMPONENT sy-index OF STRUCTURE <fs_2> TO <fs_val2>.

<fs_val2> = <fs_val1>.

ENDDO.

APPEND <fs_2> TO itab2.

ENDLOOP.

Re: Move Data Between Completely Different Tables

Former Member — Fri, 04 Jan 2013 06:27:22 GMT

but the second assign statement gives me sy-subrc 4 and hence no result.

Thanks,

Chandni Sharma.

Re: Move Data Between Completely Different Tables

kumud — Fri, 04 Jan 2013 06:41:34 GMT

Hi Chandni,

Please post your code as to how you have declared internal table. Why are you trying to move data between internal tables? What's the requirement? Thanks!

Regards,

Kumud

Re: Move Data Between Completely Different Tables

Former Member — Fri, 04 Jan 2013 06:53:08 GMT

hi,

I have data in Excel file in which I am getting the names of the fields in the first row and data corresponding to that in next few rows. I have to declare an internal table( already done) with the fields specified in first row. The only problem now I am facing is how to move data from next rows to respective columns of the Dynamically Declared table.

itab contains the data from the excel.

read table itab into wa index 1.

a3 = wa-aa.

do.

split a3 at ',' into a1 a2.

w_it-fieldname = a1.

append w_it to it.

i_1-str = a1.

append i_1.

if a1 ne a3.

concatenate a1 ',' into a1.

replace first occurrence of a1 in a3 with space.

condense a3.

else."if a3 is initial.

exit.

endif.

enddo.

call method cl_alv_table_create=>create_dynamic_table

exporting

it_fieldcatalog = it

importing

ep_table = ep_table.

ep_table is the dynamically created table.

Re: Move Data Between Completely Different Tables

Former Member — Fri, 04 Jan 2013 07:22:26 GMT

Hi Chandni Sharma,

For your requirement you have to know the concept of RTTI and RTTS

See the links for your requirement

<link farm removed>

Message was edited by: Suhas Saha

Re: Move Data Between Completely Different Tables

RaymondGiuseppi — Fri, 04 Jan 2013 07:29:33 GMT

As already written perform a LOOP with ASSIGN COMPONENT sy-index, and don't forget to manage with sy-subrc on ASSIGN statements and/ord TRY/CATCH classes like CX_SY_CONVERSION_ERROR/ENDTRY on the MOVE statements when you must exit the loop or raise an error.

LOOP AT itab1 ASSIGNING <struc1>.
  APPEND INITIAL LINE TO itab2 ASSIGNING <struc2>.
  DO.
    ASSIGN COMPONENT sy-index OF STRUCTURE <struc1> TO <field1>.
    IF sy-subrc NE 0. EXIT. ENDIF.
    ASSIGN COMPONENT sy-index OF STRUCTURE <struc2> TO <field2>.
    IF sy-subrc NE 0. EXIT. ENDIF.
    TRY.
        <field2> = <field1>.
      CATCH: cx_sy_conversion_no_number,
             cx_sy_conversion_overflow,
             cx_sy_move_cast_error.
        " Error message ?
    ENDTRY.
  ENDDO.
ENDLOOP.

Regards,

Raymond

Re: Move Data Between Completely Different Tables

kumud — Fri, 04 Jan 2013 08:13:38 GMT

Hi Chandni,

Using RTTI is always preferred way of declaring dynamic internal tables. However, going by the way you have done so far, Kumar Akshat's solution seems right to me. If I have to write the Pseudo code for your requirement it would be like:

Loop at itab from index 2.

Do (no. of fields in itab) times.

*Assign component sy-index of ep_table to <fs_val1>.

*Read the value of first component from itab to <fs_val2>.

*Exchange the values <fs_val1> = <fs_val2>.

Enddo.

*Append the table

Endloop.

Re: Move Data Between Completely Different Tables

Former Member — Fri, 04 Jan 2013 08:46:18 GMT

Hi Kumud,

as I have mentioned it is not working as I am not getting the component in <fs_val1>. I will read about RTTI to check if that solves my problem.

Thanks,

Chandni Sharma.

Re: Move Data Between Completely Different Tables

kumud — Fri, 04 Jan 2013 08:50:46 GMT

Please post your code!

Regards,

Kumud