ALV problem

[former_member734916]

Hi Friends,

I have one problem in ALV report. Please see below .

getting total for (purchase requisition) net value field and displaying currency field as 'USD'

and also getting total for purchase order value but here currency field not getting displayed.

i am filling field catalogue as follows.

1. for purchase requisition total.

CLEAR wa_fcat.

wa_fcat-fieldname = 'NETWR'.

wa_fcat-tabname = 'IT_RESULT'.

wa_fcat-ref_tabname = 'EKPO'.

wa_fcat-ref_fieldname = 'NETWR'.

wa_fcat-cfieldname = 'WAERS'.

wa_fcat-ctabname = 'IT_RESULT'.

wa_fcat-do_sum = 'X'.

wa_fcat-col_pos = '11'.

APPEND wa_fcat TO gs_fcat.

2. Currency field.

CLEAR wa_fcat.

wa_fcat-fieldname = 'WAERS'.

wa_fcat-tabname = 'IT_RESULT'.

wa_fcat-ref_tabname = 'EKKO'.

wa_fcat-ref_fieldname = 'WAERS'.

wa_fcat-col_pos = '12'.

APPEND wa_fcat TO gs_fcat.

3. Purchase order value.

CLEAR wa_fcat.

wa_fcat-fieldname = 'PNETWR'.

wa_fcat-tabname = 'IT_RESULT'.

wa_fcat-ref_tabname = 'EKPO'.

wa_fcat-ref_fieldname = 'NETWR'.

wa_fcat-cfieldname = 'PWAERS'.

wa_fcat-ctabname = 'IT_RESULT'.

wa_fcat-do_sum = 'X'.

wa_fcat-col_pos = '23'.

APPEND wa_fcat TO gs_fcat.

4. currency field.

CLEAR wa_fcat.

wa_fcat-fieldname = 'PWAERS'.

wa_fcat-tabname = 'IT_RESULT'.

wa_fcat-ref_tabname = 'EKKO'.

wa_fcat-ref_fieldname = 'WAERS'.

wa_fcat-col_pos = '24'.

APPEND wa_fcat TO gs_fcat.

the out put is.

__________________________________________________________________

Purchase req. value Currency PO value Currency

_________________________________________________________________

120 USD 300 USD

200 USD 500 USD

_________________________________________________________________

320 USD 800

(total) (currency key) (total ) ( currency key )

________________________________________________________________

but where as for purchase order value it showing only total amount as 800 but it is not showing currency key it is showing blank. i want currency key value.

[former_member734916]

it is urgent.

i can provide some more information if required.

krishna.

[Former Member]

Hi Krishnan ,

Please check if the data is there in the internal table you are passing to the ALV.

Put a break point just before you call the ALV and check if the value is there.

Regards

Arun

[former_member734916]

Hi Arun,

No problem with data, data is coming perfectly.

i need that currency key in the total column.

after that 800 in the output i need 'USD'.

for purchase requesition it is showing 320 and USD, but purchase order it is not showing.

Thanks for reply.

Krishna