When insert some data into data, we lost 3 digits after point

[former_member420377]

Hi Expert,

We met some serious problem in one add on program,the problem is described as below:

Some finicial deal need us to 7 digitals after point and we modified addnoon table the relevant column as 7 decimical places. In our DEV system everything is ok. Howerver when we transport the table structure and program to QAS. Some abnomral happens: the data in database table can only reserve 4 digitals after the point and the last 3 digitals are '000'. In order to find the problem, we trace the program and before the data is inserted into the database table, the data in internal table is accurate (7 digitals reserved).

After that we compare the table structure between DEV & QAS, there is no difference.

So anybody has some ideas about this? Your help is greatly appreciated.

Best Regards,

Derek Yang

2010-02-23

[Former Member · Accepted solution]

Were there any error messages in transport log ?

Does transaction SE11 show the table as Active ?

How many Decimals in SE11 ?

Did you cross check with database tools (like sqlplus in case of Oracle) ?

[former_member420377 · Accepted solution]

Hi Joe,

Were there any error messages in transport log ?

A: No error

Does transaction SE11 show the table as Active ?

A: In se11 Ac

How many Decimals in SE11 ?

A: In se11 the addon table is set to 7 demicial places.

Did you cross check with database tools (like sqlplus in case of Oracle) ?

A: Our database is MS SQL Server 2005, and the structure is correct.

Additional information: The test in our DEV is all right, which could reserve 7 digitals howerver after the transport of table structure and program to QAS, the lost of digitals occurred.

We have compared the table and program between DEV and QAS, they are totally the same.

So any further advice?

Best Regards,

Derek Yang