data element change

[Former Member]

Hi

I have created a custom table and created a data elemnent of type NUMC.

It has reached production . The table entries are created in production.

Now the users want to change the data element to char.

if the data element is changed from numc to char and released to production ,w ill the existing entries will be deleted ??

reg

Ramya

[Former Member]

hi.

I dnt think that existing enteries will be deleted.

there data type will be changed to char from numc.

[Former Member]

Hi,

we can activate and adjust the table with save data radio button in SE14.

thanks,

teja.

[Former Member]

Hi Ramya,

The table entries will remain same as you converting from numc to char .

But i guess the table will be party active

reagrds

Gowri

[Former Member]

Hi,

Create some table entires in Devlopment.

change the table in sE11.

Adjust table in SE14.

Check the table entries.

I am sure they will not be deleted but you would need to make sure while chnaging data type and activating table no inconsistencies are created.

[Former Member]

Hi Ramya,

the entries will not be deleted.

but with the type NUMC you will get the comma, for the values....if you changing to the CHAR..those comma will not appear in the output values.

Note: while changin and activate the table try do with Adujust + Acitve option from SE14.

Thanks!

[former_member404244]

Hi,

The entries wont be deleted in production.

Regards,

Nagaraj

[Former Member]

Entries wont be deleted from the table.

Make changes in development and transport the data will remain the same.

[Former Member]

Hi,

you have first created a data element of NUMC type and created entries according to that in production.

Now you convert data element into CHAR . As CHAR type itself accepts all the NUMC value I don't think it will create any problem but be sure that the output type will be same in both the cases. If still it shows partly active you have to activate and adjust table through SE14.

Regards,

Himanshu

[Former Member]

It will not delete the previous existing data even you change the NUMC to CHAR.

[Former Member]

Hi:

There is lot of chance to delete the data, use SE14 and select adjust data and activate it.

Best of luck.

Regards

Shashi

[Former Member]

bfore changing the data element. make sure that u take a dump of the data that is already present.(u can asK BASIS for this) as there is chance for the data to be deleted.

u can use SE14 to adjust the database after u chg the data element.

if at all the data gets deleted u can upload it through the dump u hve taken.

[naveen_inuganti2]

You can test it by your own by changing the dataelement in your development system.

If length is same in both cases, entries will not effects.

Dont go for NUMC type for Primary key fields.

Naveen.I

[Former Member]

Hi Ramya S ,

You have created a data element of type NUMC, which means some field in ur table has data type NUMC right? And now users want it to be CHAR right?

Well definitely this field must be used in some program right?

You have 2 ways :

1) You can change the data element, the entries won't get deleted. But yes slight change in format will take place, like preceding zeros will be seen in character format as per the length on the field defined...well thats because different data types have their own features.

2) Another way is keep the data element same as NUMC.

and you can change the data type of the field which you are using, in the code itself.

For Example : You have a field value a of type numc defined in table.

when defining internal table to use this field...u will as usual define it and it wud be in NUMC datatype.

then you can declare another variable b of type char of specific length and then assign a to b.

E.g.:

Table : EMPLOYEE

Field :EMPLOYEE_NO

Data Element : ZEMP_NO

Data Type : NUMC

In Code :

• Declaring Internal Table ***

Data : Begin of itab,

employee_no TYPE employee-zemployee_no,

End of itab.

• Variable of type CHAR ***

Data : employee_no_new(10) TYPE c.

• Assigning old value to new variable ***

employee_no_new = itab-employee_no.

now all the values will have properties of data type CHAR. You can even send it to production...won't give any problems...

I have just given an example...you can try this for the feld you have created. Hope this helps you.

If any more doubts, do revert

Regards,

Radhika

Edited by: RadhikaS on Mar 25, 2009 6:18 PM