How to change the data type in the table ESLL for the field USERF2_NUM ?

[Former Member]

Hello Friends,

I have a requirement in which one of the change is to convert the data type of the field 'USERF2_NUM' in the table 'ESLL' from 'QUAN' to 'CHAR'.

How do i do it if i have an access to change it..........i think i should also check the impact of the change if done.

Kindly tell me as my requirement starts with this small change.

Regards,

Rajesh Kumar

[Former Member]

Hi,

A Quan field will have 13 characters and 3 Decimal places.

In case you need to change it to Char, You might have to define the length of the datatype as 17. ( 16 + 1 for decimal place).

You can change this to char of length 17 in the domain.

Thanks,

Sowmya.

[Former Member]

Once you change the data type, ensure that the reference field to the Quan field is also removed..

[Former Member]

Thanks for the reply Sowmya.

I would like to know 2 things.

1. Is it ok to change the data type of the field 'USERF2_NUM ' which is in the table ESLL. from quan to char.

2. The table ESLL already has entries. if we change the data type from QUAN to CHAR what is the effect on the existing entries of the table .

Kindly reply me back.

Thanks & Regards,

Rajesh Kumar

[Former Member]

1) If data is already there in the Table and you change the Data type or Length there can be a loss of data.

2) Changing Quantity Field to char Field is never Suggested.

quantity Field will always hold Numeric values but when you change it to Char field it can hold any values.

Which will lead in Inconsistencies.

So its not advisable to Change Quantity to Char.

What exactly are your requirements?

Regards,

Gurpreet

[Former Member]

Hi,

If the name of the field remains same and if the data type is changed, there would not be any data loss.

If you change the data type of the field, you need to adjust the table using Database utility (SE14) with the option save data.

Thanks,

Sowmya