topic Re: Problem in the changing field type in Application Development and Automation Discussions

Problem in the changing field type

Former Member — Mon, 28 Apr 2008 07:00:54 GMT

Hi Friends,

I have a doubt here. I am having a user defined table for the Invoice registration. In that I took a field Invoice amount of field type DMBTR. Now the user wants the Invoice amount to be negative also. If I change the Field type in the table does it have any impact to the data in the production?

Please suggest me what to do.

Regards,

SMP

Re: Problem in the changing field type

Former Member — Mon, 28 Apr 2008 07:25:11 GMT

HI SMP ,

U cannot change the field like this... bcoz... dmbtr is a standard field created by SAP.. So many tables use this field those tables may get affected.

So better u go for a custom field as ur using a custom table.

Venkat.

Re: Problem in the changing field type

Former Member — Mon, 28 Apr 2008 07:28:03 GMT

Yes,

I mean can I remove the DMBTR from the table and replace a custom defined field? Will it have any impact on the data which is already in the production.

Regards,

SMP

Re: Problem in the changing field type

Former Member — Mon, 28 Apr 2008 07:38:50 GMT

Hi,

You can change the domian data type as CHAR when you are activating the table go for the utilities and activate with save data option.

Regards,

madan

Re: Problem in the changing field type

Former Member — Mon, 28 Apr 2008 07:55:48 GMT

hi,you did not need to remove the fileds,you can try this way

first,you create a domain,in 'sign' label,you choose it.

then ,create a data type .

hope this can help you