topic Re: Problems with formatting Layout set. in Application Development and Automation Discussions

Problems with formatting Layout set.

Former Member — Thu, 23 Jun 2005 03:04:33 GMT

Hi,

I have modified a Layout set and this layout set is called directly by an ABAP program. The problem is with fields that hold a numeric value gets formatted through some thing which I can’t trace.

Example:

10,000.20 -

is displayed like -

10.000,20

500.346 -

is displayed like -

500,346

As you could see the decimal place (“.”) is replaced with comma (“,”). What should I do to get this appear normal. Do remember that the Layout set and the calling ABAP program was not written from scratch by me it was already there and I modified it.

There should be a flag in the calling program that control this format. Pls I need a answer.

Thnkx

Kishan

Re: Problems with formatting Layout set.

Former Member — Thu, 23 Jun 2005 03:29:49 GMT

Hi Kishan,

The first thing to check would be your user profile settings:

System --> User Profile --> Own Data

then go to the defaults TAB. Check the Currency format there.

Re: Problems with formatting Layout set.

Former Member — Thu, 23 Jun 2005 03:54:46 GMT

Hi Aaron Rose,

I checked my User Profile under the Defaults Tab the Decimal Notation is set to "1,234,567.89". Yet the problem keeps on poping. It has to do something with the calling Program or Layoutset.

Thanks,

Kishan

Re: Problems with formatting Layout set.

Clemenss — Thu, 23 Jun 2005 10:32:49 GMT

Hi,

don't know what program calls what layout set. In layout set as in program many things are possible to change the formatting; i.e. in sales documents the formatting may be based on the country specifics for the receiving party.

Compare SAP documentation:

The formatting for certain field types depends on the country settings. These field types include, for example, date fields and number fields that include either a decimal point or the 'thousands' separator character. The formatting options defined in the user master record are usually the ones used here. The SET COUNTRY control command can be used to select a formatting option other than that specified in the user master record. The country-dependent formatting options are stored in the T005X table.

Syntax:

/: SET COUNTRY country_key

If you don't find a solution that way, you may identify the wrongly formatted field and check it's filling and formatting inside SAPscript debugger.

Hope it helps,

Clemens Li

Independent Workbench Consultant