topic Re: Query on ALV in Application Development and Automation Discussions

Query on ALV

Former Member — Wed, 30 Aug 2006 10:42:25 GMT

I have a query on ALV.

When am doing a addition for a currency field with some negative amounts and positive amounts, the Sumation of all amounts are not happening.

Could someone please help me on this.

Thanks in advance.

Prince

Re: Query on ALV

Former Member — Wed, 30 Aug 2006 11:01:53 GMT

Hi Price,

Currency field length is 5 chars only.

so when you assign '-10000' value it is goign to take

'-1000' only so check the length while passing.

-Anu.

Re: Query on ALV

Former Member — Wed, 30 Aug 2006 11:10:00 GMT

Hi,

In ALV fieldcatalog, please pass the CFIELDNAME and CTABNAME.

CFIELDNAME = Currency Key,

CTABNAME = Currency key table name.

like use below code in the fieldcatalog

LS_FIELDCAT-CFIELDNAME = 'WAERK'.

LS_FIELDCAT-CTABNAME = 'VBAP'.

I think summation is working fine.

rewards if helpful.

Regards,

Subbarao

Re: Query on ALV

Former Member — Wed, 30 Aug 2006 11:11:45 GMT

good

check out with the -(negative) sign of the currency field wheather it is coming in the exact format or not, sometime it happend that the -(negative)sign didn't come properly and it give you the wrong result.

thanks

mrutyun

Re: Query on ALV

Former Member — Wed, 30 Aug 2006 11:15:38 GMT

Hi Prince,

Please check the data type of the field. also make sure that you have set the field DO_SUM to 'X' in the field catlog.

Regards,

Prabhas.