topic DDIC problem in Application Development and Automation Discussions

DDIC problem

Former Member — Mon, 19 May 2008 10:32:26 GMT

I am using one Customize table where 3 string fields are allready there. I need to add some more fields into that table which may contain another two string fields. But in one table more than three string fields are not alowed. What could be the best solution to resolve this problem?

Re: DDIC problem

valter_oliveira — Mon, 19 May 2008 10:37:27 GMT

Hello.

I had the same problem. There is no way to have mora than 3 fields in a table.

The solution (in my case) was to store 3 strings into one string field, separated by a "separator".

Like this:


CONCATENATE str1 "<string end>" str2 "<string end>" str3   INTO wa-string1.
CONCATENATE str4 "<string end>" str5 "<string end>" str6   INTO wa-string2.
CONCATENATE str7 "<string end>" str8 "<string end>" str9   INTO wa-string3.
INSERT ztable from wa.

Best regards.

Valter Oliveira.

Re: DDIC problem

Former Member — Mon, 19 May 2008 10:37:38 GMT

See if u can add bigger length fields like CHAR100

Re: DDIC problem

Former Member — Mon, 19 May 2008 10:39:55 GMT

hi,

Make use of concatenate statement to achieve the same ..

Regards,

Santosh