topic Re: Decimal Data type in Application Development and Automation Discussions

Decimal Data type

Former Member — Wed, 09 Aug 2006 07:48:15 GMT

Hi All,

I have a problem while printing field value of DECimal data type . iam fectching a field named KURSF from BKPF into a internal table and finally this internal table values are downloaded to application server. the problem is when viewing the file downloaded in application server i can see hashes in the field value of KURSF instead of actual values

Thanks in Advance,

Neha

Re: Decimal Data type

Former Member — Wed, 09 Aug 2006 07:57:30 GMT

i guess, the values are truncated. can you check the field length defined in that internal table?

field to which you are populating the database values.

regards

srikanth

Message was edited by: Srikanth Kidambi

Re: Decimal Data type

andreas_mann3 — Wed, 09 Aug 2006 08:01:10 GMT

hi,

move that field (kursf) before download to a char-field,

because it's a packed value - that you cannot use for other applications!

Message was edited by: Andreas Mann

Re: Decimal Data type

Former Member — Wed, 09 Aug 2006 08:08:07 GMT

The problem is not with the decimal points but when you transfer command with an itab with pack fields, you would see that sort of issue.

Best is to use UNPACK command basically to convert the value to char/numeric and than transfer it.

So the soln is define the internal table with character field (make sure that you have the lenght as twice the len of pack field). UNPACK the pack field to char/num field and than transfer.

Regards

Anurag

Re: Decimal Data type

Former Member — Wed, 09 Aug 2006 08:11:30 GMT

Hi,

When downloading CURRENCY or DECIMAL fields, you should MOVE the data into a CHARACTER Variable and then TRANSFER it to application server.

data : l_kursf type bkpf-kursf.

MOVE wa_tab-KURSF to l_kursf.

concatenate wa_tab-field1

wa_tab-field2

l_kursf

into l_string separated by `,`.

Transfer l_string to l_file.

close dataset.

Best regards,

Prashant

Re: Decimal Data type

Former Member — Wed, 09 Aug 2006 08:20:18 GMT

Hi,

that problem is common, since it will fail to transfer the currency fields. so you need to convert that to Char and transfer it to application server. then you can see the data .

The problem is with the currency fields, try to convert it to char and check./

Regards

vijay