topic Re: Amount Valiation in Application Development and Automation Discussions

Amount Valiation

Former Member — Tue, 09 Jan 2007 10:35:36 GMT

My requirement goes as follows:

When I am doing a BDC, if the Amount in the flat file which is for ex: 5,500.45 should get converted to 5.500,00 in SAP. Can someone help me finding out the solution for this. Is there any Funciton Module or some logic for this?

Thanks!!!!!!

Nitish.

Re: Amount Valiation

anversha_s — Tue, 09 Jan 2007 10:39:52 GMT

hi,

1,234,567.89  => 1.234.567,89.


data: l_amnt(100) type c.

l_amnt = '1.234.567,89'.

replace all occurrences of ',' in l_amnt with '#'.

replace all occurrences of '.' in l_amnt with ','.

replace all occurrences of '#' in l_amnt with '.'.

write : l_amnt.

Rgds

Anver

Re: Amount Valiation

former_member188829 — Tue, 09 Jan 2007 10:42:04 GMT

declare that field as a CURR

Re: Amount Valiation

Former Member — Tue, 09 Jan 2007 11:21:37 GMT

Thanks for the response. I still have things to clarify. Suppose there is a value in the flat file like for ex: 100000, then in that case what will be the o/p according to your logic?

As per my requirement it shld be like this:

100000 ==> 1.00.000,00

Can u please look into this & provide me with the solution?

Thanks!!!!

Nitish

Re: Amount Valiation

Former Member — Tue, 09 Jan 2007 11:24:59 GMT

Hi,

check the following code.

CASE l_dec.

WHEN 'X'. "N,NNN.NN

REPLACE ALL OCCURRENCES OF ',' IN p_comp_qty WITH ' '.

CONDENSE p_comp_qty NO-GAPS.

WHEN ' '. "N.NNN,NN

REPLACE ALL OCCURRENCES OF '.' IN p_comp_qty WITH ' '.

REPLACE ',' IN p_comp_qty WITH '.'.

CONDENSE p_comp_qty NO-GAPS.

WHEN 'Y'. "N NNN NNN,NN

REPLACE ',' IN p_comp_qty WITH '.'.

CONDENSE p_comp_qty NO-GAPS.

WHEN OTHERS.

RETURN.

ENDCASE.

hope its useful...

Sarath

Re: Amount Valiation

Former Member — Tue, 09 Jan 2007 11:52:11 GMT

hi,

parameters : val like vbap-netpr.
data: val2(13) type c.

val = trunc( val ).        "--->use this 
write:/ val.
write val to val2.
replace '.' with ',' into val2.
replace ',' with '.' into val2.
write:/ val2.

check ur input as 5,500.45

regards

vijay.

Re: Amount Valiation

Former Member — Wed, 10 Jan 2007 07:59:44 GMT

Hi Anver,

The code which you gave works fine in ECC 6.0 but when I am trying to execute the same in 4.6 C it is throwing error. Can u please suggest on how to proceed with this?

Thanks!!!!!!

Nitish