Problem in ALV reports!

[Former Member]

Hi,

I want to generate a report in ALV using a combined fields from 2 tables... I have already created an internal table from these two DB table fields using the inner join. in the ALV report i want the reslt of each field to be displayed in the report.. for Example:

field1 in internal table contain (amount 13324.225 34432.214 ....ans so on) so in the ALV i want to calculate the result of all the entries regarding this particular field..

depending on a particular period of time which be choosen from a select-option..

please advice how to do that??

[Former Member]

Hi,

I want to generate a report in ALV using a combined fields from 2 tables... I have already created an internal table from these two DB table fields using the inner join. in the ALV report i want the reslt of each field to be displayed in the report.. for Example:

field1 in internal table contain (amount 13324.225 34432.214 ....ans so on) so in the ALV i want to calculate the result of all the entries regarding this particular field..

depending on a particular period of time which be choosen from a select-option..

please advice how to do that??

[huseyindereli]

Hi ,

I'm not sure about your need but if you like sum up your fields , you can use do_sum as below. Totals will appear automatically.

LOOP AT gt_fieldcat.
if gt_fieldcat-fieldname = 'YOUR_COLUMN'.
   gt_fieldcat-do_sum = 'X'.
endif.

  MODIFY gt_fieldcat.
ENDLOOP.

Regards.

[Former Member]

Hi,

If you are creating the field catalog manually, then use for that particular field you need the summation result. Otherwise if you are getting the field catalog using then give the loop and modify your field catalog for changes.

Thanks,

[Former Member]

Thank you all,

Problem Resolved!