topic Amount conversion in BDC in Application Development and Automation Discussions

Amount conversion in BDC

Former Member — Mon, 26 Feb 2007 04:48:38 GMT

Hi,

when iam displaying report after uploading data using BDC , amount field iam not getting properly.

iam expecting 1,234 ( what iam getting 12.34), any one can help.

Re: Amount conversion in BDC

Former Member — Mon, 26 Feb 2007 04:59:15 GMT

Check the user settings for currecny.

Re: Amount conversion in BDC

Former Member — Mon, 26 Feb 2007 05:04:59 GMT

Currency using is TWD.

Re: Amount conversion in BDC

Former Member — Mon, 26 Feb 2007 09:36:34 GMT

hi ,

for all the currency fields in BDc it is better to use the stmt

WRITE <fval> TO <gs_bdc_tab-fval> LEFT-JUSTIFIED.

as currenecy field is right justified field and we want to fill in as left justified so we might get some error.

and one more thing is user settings will also effect the output plz also verify the same

Re: Amount conversion in BDC

Former Member — Mon, 26 Feb 2007 12:23:51 GMT

Amount Field have 1,234.this value move to Char field than that Variable(V_CAHR) use for BDC ok

Data: v_Char(18),

V_AMOUNT = 1,234.

V_CHAR = V_AMOUNT.

Re: Amount conversion in BDC

Former Member — Mon, 26 Feb 2007 15:50:19 GMT

u need to the decimal correction.

pls see the extract of the code below :

***********

SELECT currkey currdec FROM tcurx INTO TABLE tbl_tcurx

FOR ALL ENTRIES IN tbl_bsik1

WHERE currkey = tbl_bsik1-waers.

IF sy-subrc = 0.

SORT tbl_tcurx BY currkey.

ENDIF.

READ TABLE tbl_tcurx WITH KEY currkey = tbl_bsik-waers

BINARY SEARCH.

IF sy-subrc = 0.

currency corrections

IF tbl_tcurx-currdec = 0.

tbl_final-wrbtr = tbl_bsik-wrbtr * 100.

ELSEIF tbl_tcurx-currdec = 1.

tbl_final-wrbtr = tbl_bsik-wrbtr * 10.

ELSEIF tbl_tcurx-currdec = 3.

tbl_final-wrbtr = tbl_bsik-wrbtr / 10.

ELSEIF tbl_tcurx-currdec = 5.

tbl_final-wrbtr = tbl_bsik-wrbtr / 1000.

ENDIF.

start

ELSE.

tbl_final-wrbtr = tbl_bsik-wrbtr.

ENDIF.

if found useful reward with points

Re: Amount conversion in BDC

Former Member — Mon, 26 Feb 2007 19:34:15 GMT

1)the ID which created BDC session & the ID which processed session must have the same settings for decimal point in user settings, otherwise you may see data inconsistencies.

2) when you create your BDC session and populate amounts, use write amt_field into char_field currency 'your currency', char_field should have proper length, then use this char_field in your BDC program.