topic Re: Field data type conversion - How it affects the system in Application Development and Automation Discussions

Field data type conversion - How it affects the system

Former Member — Mon, 22 Jun 2009 23:54:55 GMT

Hi Techies ,

I have got this task of changing the data type of the certain fields which are now of type dec,date to char

suiting one of the business needs.

Apparently it is a simple task and but have found it needs more research.

Steps I have planned to do :

1. Changing the type of the fields in the table which may result in changed date format to yyyymmdd and numerical values would result no change in their value

2.Finding the reports that use these fields in their arithmetic operations and disply, Correcting the reports

to make no flaw during execution and display

Are there any other checks I need make in order that this field type conversion would not make any flaw throughout production system.

As these field affect the more number of program, I think, The inputs from you guys would lead the successful execution of this task

Should I also need to deal with BAPIs and others associated objects.

Please provide your inputs on it.

I apprecite your valuable inputs

Thanks

Manivanna Prabu

Re: Field data type conversion - How it affects the system

Former Member — Tue, 23 Jun 2009 03:28:16 GMT

Hi Manivanna Prabu,

It is not advisable to change the data type of the dictionary fields...!

But still you have a requirement the use the SE11, SE12, SE13, SE14.

To Adjust and activate...!

-Dileep .C

Re: Field data type conversion - How it affects the system

Former Member — Tue, 23 Jun 2009 03:33:16 GMT

Hi,

Is it a standard table or a Ztable Field?

It is not recommended to change standard fields as it may be used in several places.

If it is a ztable field, you need to do a where used list for that field in SE11 and check all the dependency objects, make sure that the change is carried out throughout the system where and all the field is used.

Regards

Karthik D

Re: Field data type conversion - How it affects the system

Former Member — Tue, 23 Jun 2009 05:13:57 GMT

Adjust and Activate ,but it is not adivisible....

Re: Field data type conversion - How it affects the system

Former Member — Thu, 25 Jun 2009 04:54:54 GMT

Hi techies,

I appreciate your valuable replies on this task.

These are all the 'Z' or custom fields in the Standard SAP table that needs to be changed.

I do find the dependency objects using SE11( Where-used list ) and have sorted what changes needed in this objects.

Is this just enough making these change alone, Whatelse I am expected to carry out in the system so that the system would not be affected .

Please share your valuable inputs.

Can you guys provide any specific reasons why it is not advisable to carry out this.

Thanks,

Prabu

Re: Field data type conversion - How it affects the system

Former Member — Tue, 02 Mar 2010 05:12:12 GMT

Solved