topic Amount WRBTR in TCode FB60 in Application Development and Automation Discussions

Amount WRBTR in TCode FB60

Former Member — Tue, 04 Sep 2007 10:14:32 GMT

Hi all,

i am working on BDC for Transaction Code FB60

Can anyone help me in BDC for this transaction.

I have amount field name say wrbtr in the structure INVFO, it has the type CURR.

But It_BDCDATA has field Fval of the type c with length 132.

so it will not append the value of amount from the flat file.

If I take the value into the variable of the type string.

Then I will be able to append the value in it_bdcdata but....................

when transaction will run then it will give the error that amount should defined in a particular format of __,__,__.__

i think Conversion routine should be used but i am not sure................

can anyone of you help me in it

thanks

ekta

Re: Amount WRBTR in TCode FB60

Former Member — Tue, 04 Sep 2007 10:19:42 GMT

Hi ekta

on BDC, the field that you used to get the data from field wrbtr should be string and the format for number is not required because on BDC the format of number is the same as format in the user profile . It 's good way that you use 10000 instead of 10,000. if you set the format in the text file , you need to set format as the same with the user profile.

Regards

Wiboon

Re: Amount WRBTR in TCode FB60

Former Member — Tue, 04 Sep 2007 10:24:08 GMT

Don't worry abt it. Chretcter type is capeble of holding any kind of data. When you place the curerencly amt in the field using BDC the converstion routin automatically triggets and will takes care of the conversion.

Cheers,

Jaleel.

Re: Amount WRBTR in TCode FB60

Former Member — Tue, 04 Sep 2007 10:26:37 GMT

thanks for the reply..

but i am not getting what you want to say for the reply.

thanks

Re: Amount WRBTR in TCode FB60

Former Member — Tue, 04 Sep 2007 10:41:57 GMT

U dont need a conversion exit - the following line will do -

DATA : L_CHAR_AMT type char15.
WRITE : P_WRBTR TO L_CHAR_AMT.

This piece of code will do the conversion ( with comma dor etc ).

Hope it solves ur prob.