topic Re: Thousand seperator in Application Development and Automation Discussions

Thousand seperator

SrihariNerella — Thu, 11 Jun 2009 04:45:10 GMT

Hi,

I am working on Vendor Balances .I got the balance of all vendors but problem is i want the separator of thousand .

For example 200000.34 i want to show this one as 2,00,000.34

548435265.67 i want to show this one as 54,84,35,265.67

For this any function module is availble .Please give your suggestion.

Regards

Nandan.

Re: Thousand seperator

Former Member — Thu, 11 Jun 2009 04:50:17 GMT

Dear Hari,

You can achive this with ur system setting or with help of ur functional consultant.

Rgds,

Kiran

Re: Thousand seperator

Sandeep_Panghal — Thu, 11 Jun 2009 05:14:12 GMT

Check user setting in SU3

Re: Thousand seperator

Former Member — Thu, 11 Jun 2009 05:14:20 GMT

Hi Nandan,

You can achieve this by changing the settings in the user profiles,,, or at SU01 TCode,,,

If still you have the same problem then pass the reference filed & Table for the vendor balances field,,,

Thanks & regards,

Dileep .C

Re: Thousand seperator

SrihariNerella — Thu, 11 Jun 2009 05:23:28 GMT

HI,

Thanks for your quick reply . I check the usersetting that same as our format . I am using Bapi for getting vendor balance on particular date .In the bapi i am getting balance with out comma . There is no function module for changing value with thosand seperator .

Regards

Nandan

Re: Thousand seperator

Former Member — Thu, 11 Jun 2009 05:26:41 GMT

Hi,

Declare a Variable with currency type and pass teh value that you get from the BAPI to it. This might help you out.

Thanks,

Prashanth

Re: Thousand seperator

SrihariNerella — Thu, 11 Jun 2009 06:37:39 GMT

Hi Prasanth,

Thanks for your reply .It's not working .

Regards

Nandan.

Re: Thousand seperator

Former Member — Thu, 11 Jun 2009 06:37:55 GMT

data: p1 type p DECIMALS 2.

p1 = '3121212.22'.

write p1. ---u will the required format.

Tried like this?

Re: Thousand seperator

Former Member — Thu, 11 Jun 2009 06:39:50 GMT

Hi,

What is the BAPI that you are using?

Prashanth

Re: Thousand seperator

SrihariNerella — Thu, 11 Jun 2009 06:47:11 GMT

Hi,

I am using the fallowing bapi .

CALL FUNCTION 'BAPI_AP_ACC_GETKEYDATEBALANCE'

EXPORTING

COMPANYCODE = '1000'

VENDOR = VENDOR

KEYDATE = KEYDATE

BALANCESPGLI = ' '
NOTEDITEMS = ' '
IMPORTING
RETURN =

TABLES

KEYBALANCE = KEYBALANCE

LOOP AT KEYBALANCE.

KDMBTR = KEYBALANCE-LC_BAL.

KWRBTR = KEYBALANCE-T_CURR_BAL.

CUR = KEYBALANCE-CURRENCY.

ENDLOOP.

balance = kdmbtr.

I taken balance as dmbtr .

But it is not showing .

Regards

Nandan.

Re: Thousand seperator

Former Member — Thu, 11 Jun 2009 07:00:40 GMT

   

select single * from usr01 where bname = sy-uname.

if usr01-dcpfm = 'X'.
right_decimal = '.'. 
wrong_decimal = ','.
else.
right_decimal = ','.
wrong_decimal = '.'.
endif.

now use this statement .
loop at itab. " if u see the separators here for the field 
replace wrong_decimal with right_decimal into itab-field .  "<------\
write itab-field. 
endloop.

here itab-field is ur currency or quantity field .

and then check the o/p .

for initial testing use write statement on the currency field and check the o/p . alter the o/p using hte above logic .

ex : write itab-field to gv_field .

First see the o/p and then modify the logic as per ur requirement.

Br,

Vijay.

Re: Thousand seperator

SrihariNerella — Thu, 11 Jun 2009 07:13:08 GMT

Hi,

I am getting the value like 5345678.00 i want in this format 5,345,678.00 .

Regards

Nandan

Re: Thousand seperator

Former Member — Thu, 11 Jun 2009 08:18:20 GMT

write itab-field will give u the output .

from 5345678.00 to 5,345,678.00 .

Tell me ur o/p after write statement .

br,

vijay.

Re: Thousand seperator

SimoneMilesi — Thu, 11 Jun 2009 08:22:01 GMT

As told by sniper and Veranji, use the WRITE command.

If you want to put in output, simply

write: balance.

If you need the value into a internal table,

write balance to itab-balance_c.

where itab-balance_c is declare as char (lenght usually is 18 or 20).

Re: Thousand seperator

SuhaSaha — Thu, 11 Jun 2009 08:27:19 GMT

Hello Srihari,

I think you have to use the WRITE .. TO ... CURRENCY stmt.

LOOP AT KEYBALANCE.
KDMBTR = KEYBALANCE-LC_BAL.
KWRBTR = KEYBALANCE-T_CURR_BAL.
CUR = KEYBALANCE-CURRENCY.
ENDLOOP.

" balance = kdmbtr.

WRITE KDMBTR TO BALANCE CURRENCY CUR.

Please note that the thousands separator will be displayed based on the currency key.

BR,

Suhas