BDC

[Former Member]

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

[Former Member]

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

[Former Member]

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)

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Thanks !

[Former Member]

Hi,

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

Regards

Shiva