Amount WRBTR in TCode FB60

[Former Member]

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

[Former Member]

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

[Former Member]

Hi

thanks for the reply..

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

thanks

[Former Member]

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.

[Former Member]

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.