Query on ALV

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

hi

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

[Former Member]

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.