table

[Former Member]

Hi all,

I have created a Z table which has a field MAIL1. i changed it's type from CHAR to STRING.But when i activate the program - it says the Z table should be a flat structure :; you cannot use internal table, strings, references.......................wat could be wrong? kindly reply

thanks .

[amit_khare]

You cannot have type STRING in Tables/Structures.

Instead use a CHAR type as per requirement.

like CHAR255.

Regards,

Amit

reward all helpful replies.

[Former Member]

hi,

chk if u have used it elsewhere in some program. If so comment it and activate again.

regards,

raksha

[Former Member]

Hi Kavita ,

You cannot use string as a feild in a table , what i would suggest is you use the data type CHAR255.

Regards

Arun

[Former Member]

HI Kavitha,

Delete the Field and create a new one.

Data type : String Length : 256.

It will work.

Thanks.

[Former Member]

<b>After changing the datatype of the field,

GOTO UTILITIES->DATABASE UTILITY->ACTIVATE AND ADJUST DATABASE.

Regards,

Pavan P.</b>

[Former Member]

Hi

U canot use the string type in Table instead use char type.

Thanks

[Former Member]

hi kavitha,

when ever u have changed a database table then u sholud adjust it and activate it again as after completing all ur changes in SE11 -> UTILITIES -> DATABASE UTILITY -> CLICK ON ACTIVATE AND ADJUST DATABASE. then only all ur changes are reflected in database otherwise previous version of activated will take and displays same error again n again.

if helpful reward some points,

with regards,

Suresh.A

[Former Member]

Hi kavitha

you cannot use string in tables so u better use char type as

CHAR255

if use reward points

Regards,

Azhar