Field length problem

[Former Member]

Hi Gurus,

In Purchase Requestion the Valuated Price is saving for

Currency INR as 168.00 / 1 NOS and for

Currency USD as <b>892.000</b> / 1 NOS

in the table EBAN field PREIS. The field length of PREIS is 11 and Decimal 2 points.

While i am retreiving the data in the report

My output is

168.00

8,920.00 -->But as per my Requirement the output should be 892.00

How to solve it?

Thanks & Regards

Arun

[Former Member]

Hey, if its an ALV report then change the fieldcatalog accordingly for that column. Set the currency to USD for that column.

Cheers,

Sam

[Former Member]

It is not an ALV report. It is a Classical report

[Former Member]

Great.

Then try like this

DATA int TYPE i VALUE 12345678.

WRITE int NO-GROUPING CURRENCY 'USD'.

Reward points if useful...

Cheers,

Sam

[Former Member]

loop at itab.

if itab-waers = 'USD'.

itab-preis = itab-preis / 10.

modify itab.

endif.

endloop.

regards

shiba dutta