data type doubt

[Former Member]

Hi Friends,

I have a small doubt, Actually I have created a 'Z' table and in that I took a field as integer. And send to the production it is working fine. Now the user wants to change the data type (he wants to enter negatives values for that field) If I change the table and do it does it effect the data which is already keyed ?

If so how to do it.

Regards,

Line

[Former Member]

sap not allowed negative value.

so maintain same table separtly.

example +200

-200

positive 1

negative 0

200 1 positive

200 0 negitive

sap logic also used sap funcational

[former_member194669]

Hi,

Yes it will get affected.

Download the data into a local file as XLS or space tab limited file.

and write a small utility program after the data element change upload the data into the table.

or create the new field in the table and transport upto production, and write utility program to move value from old to new field. then delete the old field and make a transport

aRs

Message was edited by:

a®

[RichHeilman]

If you database field is using the type INT4, then this will allow negatives by default. So no need to do anything.

But to answer your question, the system will take appropriate actions to try to convert the data within the field. But you should really test this, to be safe.

Regards,

RIch Heilman

[Former Member]

Hi,

My data type is curr can any one tell me how can i accept the amount in negative values.

Regards,

Line

[RichHeilman]

CURR fields can also have negative values by default in the database. There is nothing special that you need to do to handle this when writing to the database. If your issue is allowing the user to enter this value in a screen, then there is some formatting that you do require.

Go to your screen using screen painter

Click on the element list tab

click on the texts/i/o templates

Find your field in the list

Now in the Text or I/O field, you will see an underscore ie _______________

Just add a "V" to this, so it looks like this ______________V

Doing so, is a placeholder for the sign. Now the user can enter negative values in your screen.

Regards,

Rich Heilman

[Former Member]

I create one custom table to proceess Finanace data,here i used

Data element WRBTR

Domain is WERT7

I am able to get negative values and i am able to save into Database.

Thanks

Seshu