Data type to be used

[Former Member]

Hi All,

I have a requirement where i have to fetch mutiple rows of a table and then concatenate the data of a particular field of all the rows and put it into a single variable.

I have no restrictions on the no of rows to be fetched due to which i cannot plan of the size of that single variable.

Can anyone suggest me some data type which can take variable lengths at run time. also the size limit can go beyond 255.

Please help.

Thanks,

Chandna

[Former Member]

Hi All,

I have a requirement where i have to fetch mutiple rows of a table and then concatenate the data of a particular field of all the rows and put it into a single variable.

I have no restrictions on the no of rows to be fetched due to which i cannot plan of the size of that single variable.

Can anyone suggest me some data type which can take variable lengths at run time. also the size limit can go beyond 255.

Please help.

Thanks,

Chandna

[Former Member]

hi,

u can choose data type as STRING also.

Cheers,

Rudhir

[keerthy_k]

Hi,

U can use string or xstring as the data type and concatenate all the variables into the string type one.

U can declare as :

DATA: str type string.

concatenate field1 field2 field3 into str.

Keerthi

Edited by: Keerthy K on Feb 25, 2009 11:49 AM

Edited by: Keerthy K on Feb 25, 2009 11:50 AM

[Former Member]

Hi,

You can use string or CHAR_1536.

Thanks,

Sriram Ponna.

[Former Member]

HI,

use EDI_SDATA data element which can hold 1000 characters.

OR

text should be treated as Long Text.

And the steps are:

1. Create Text Object Using SE75.

2. Create Text ID Using SE75.

3. Now you have to Save the text with FM SAVE_TEXT.

Regards,

Venkatesh

[former_member222860]

Hi,

Use SYCHAR512

Pl. refer table TAB512

[suredarreddy_pulimamidi]

Hi,

You can use local variable with lenght 65535 type c. It's the maximum length allowed for char data type.

Regards,

Surendar Reddy.

[Former Member]

Hello Chandna,

You can go with the following workaround;

DATA:
  w_var1 TYPE string,
  w_var2 TYPE string.

LOOP AT t_table INTO fs_table.
  CONCATENATE w_var1 fs_table-field1 INTO w_var2.
ENDLOOP.

Now, every time loop is run, current value is attached to previous value and at the end, you'll get concatenated values in w_var2.

You can very well use w_var2.

Hope, it helps you.

Thanks: Zahack