Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Input must be in the format

Former Member
0 Likes
1,731

Hi,

I am facing a problem with currency. The issue is i made a custom screen there are some fields on it. Some fields are currency fields which are attached with a currency. The probelm is in our scenario for USD currency the no. of decimal places defined are 4 so when the screen is displayed the amount is converted to 4 decimal places. Since the component used has 2 decimal places the screen gives and error saying Input must be in the format

___,___,___,___,___,___,__~.__V.

Can anyone tell how should i sovle this problem.

Khusro Habib

Hi,

I am facing a problem with currency. The issue is i made a custom screen there are some fields on it. Some fields are currency fields which are attached with a currency. The probelm is in our scenario for USD currency the no. of decimal places defined are 4 so when the screen is displayed the amount is converted to 4 decimal places. Since the component used has 2 decimal places the screen gives and error saying Input must be in the format

___,___,___,___,___,___,__~.__V.

Can anyone tell how should i sovle this problem.

Khusro Habib

5 REPLIES 5
Read only

Former Member
0 Likes
939

It looks like the currency field you used is a sign-enabled one.

On the screen painter, specify the value in your currency fields as _______V (enter V at the end, filling the rest of the space with underscores)

Hope this helps.

Sudha

Read only

0 Likes
939

Hi,

Thanks for the reply, i have tried doing that, but what i think is the problem, is that sicne this is SAP functionality that it converts the data according to currency settings, but since the field on the screen is made from a field that has type with decimals 2 places it is unable to place the data from screen into the variable, but this happens in sap transactions every where. THere must be a way to solve this issue.

Read only

Former Member
0 Likes
939

Hi,

One way u can do it is round off the input to 2 places before displaying it on the screen.

Other way is create a field in any internal table in ur program like

amt type p decimals 4.

Then use this field to define the field on the screen.

Regards,

Himanshu

Read only

Former Member
0 Likes
939

Hi,

Try like this - On Screen painter, don't refer the field to be a currency type. Refer the field type as Character with length as total output length of the currency field.

thanks,

sksingh

Read only

Former Member
0 Likes
939

I found a solution to this problem. The reason was that the field was not in chain end chain and since it was a table control the field was not in chain end chain in the loop.