topic Re: BDC in Application Development and Automation Discussions

BDC

Former Member — Thu, 18 Jun 2009 13:20:55 GMT

How do we handle Quan type fields in bdc in which value is in decimal like 10.5 ?

which is the datatype we take for such fields? is it char, as it is for other fields?

Pls. tell.

Regards

Tanu

Re: BDC

Former Member — Thu, 18 Jun 2009 13:26:20 GMT

Hello,

If you are getting the data from a file, just write them to the bds as it comes, just be be aware that the file should come as it has to be written on the field.

Usually it is helpfull to do it by char fields.

Bye

Gabriel

Re: BDC

Former Member — Thu, 18 Jun 2009 13:33:19 GMT

Hi,

Better to use CHAR fields. Use the total length including the decimals.

Regards

Shiva

Re: BDC

Former Member — Thu, 18 Jun 2009 13:39:28 GMT

but if we have such a value as 1,000.250

system takes it as 1.000,250

this is not what we intend.

how to manage this (user setting)

Re: BDC

Former Member — Thu, 18 Jun 2009 13:42:00 GMT

Hi,

Incase you have to handle the user settings then pass it to a character variable first using WRITE TO statement.

The character variable should be of length as the output length of your decimal field.

Then pass this character variable to the BDCDATA table in FVAL.

Regards,

Ankur Parab

Re: BDC

Former Member — Thu, 18 Jun 2009 13:45:39 GMT

Very helpful answer......... are you sure this is the only way to handle it?

Re: BDC

Former Member — Thu, 18 Jun 2009 13:48:09 GMT

Hi,

The write to is the easiest way around.

Else you will have to determine the separator from the user settings or USR01 table and check for the decimal separator and code accordingly.

Regards,

Ankur Parab

Re: BDC

Former Member — Thu, 18 Jun 2009 13:56:46 GMT

Thanks !