topic Re: Changing the database field in Application Development and Automation Discussions

Changing the database field

Former Member — Mon, 03 Sep 2007 04:56:43 GMT

Hi,

Whether it is possible to change the all the rate or value field with 5 decimals,

ex: the price which we enter in invoice or sales order.

now it two decimals whether it can be made as five.

and it should happen even in the corresponding screens.

Points assured.

regards,

Prabhu

Re: Changing the database field

Former Member — Mon, 03 Sep 2007 04:59:08 GMT

Can you elaborate your requirement??

Re: Changing the database field

amit_khare — Mon, 03 Sep 2007 04:59:23 GMT

You need access key to do that.

Re: Changing the database field

kiran_k8 — Mon, 03 Sep 2007 05:00:45 GMT

Prabhu,

you can declare the field as type P decimals 5.

kursf type p decimals 5.But changing the attributes of a field in a standard table is not advisable.

K.Kiran.

Re: Changing the database field

Former Member — Mon, 03 Sep 2007 05:01:21 GMT

Hi prabhu

It is impossible to do that because normally price in sap will be controlled with currency which consultant will config the decimal of each currency in the system . if you would like to change the decimal , you need to change in config of each currency.

Regards

Wiboon

Re: Changing the database field

Former Member — Mon, 03 Sep 2007 05:01:39 GMT

I guess it is not possible,there is no user exit to change the data type like 2 decimals to 5 decimals or 5 decimals to 2 decimals.

Thanks

Seshu

Re: Changing the database field

Former Member — Mon, 03 Sep 2007 05:14:31 GMT

Thanx.

regards,

Prabhu