topic Re: Field length problem in Application Development and Automation Discussions

Field length problem

Former Member — Wed, 28 Mar 2007 05:43:47 GMT

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 — Wed, 28 Mar 2007 05:48:45 GMT

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 — Wed, 28 Mar 2007 05:51:26 GMT

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

Former Member — Wed, 28 Mar 2007 05:53:06 GMT

loop at itab.

if itab-waers = 'USD'.

itab-preis = itab-preis / 10.

modify itab.

endif.

endloop.

regards

shiba dutta

Former Member — Wed, 28 Mar 2007 05:53:20 GMT

Great.

Then try like this

DATA int TYPE i VALUE 12345678.

WRITE int NO-GROUPING CURRENCY 'USD'.

Reward points if useful...

Cheers,

Sam