topic Re: ALV LIST in Application Development and Automation Discussions

ALV LIST

Former Member — Thu, 08 Jun 2006 17:34:46 GMT

IAM DISPLAYING THE OUTPUT IN ALV LIST FORMAT

IAM MAINTAINING THE SUBTOTAL AND SUBTOTAL TEXTS

IAM NOT GETTING THE CURRENCY IN SUBTOTAL AND GRAND TOTAL COLUMNS

Re: ALV LIST

former_member181966 — Thu, 08 Jun 2006 17:37:37 GMT

see the demo`s in SE38 = BALVDEMO*

Hope this’ll give you idea!!

P.S award the points.

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

Re: ALV LIST

Former Member — Thu, 08 Jun 2006 17:46:57 GMT

if u check the T.code FBL5N

we are getting currency in totals also

but iam not able to find the logic where they have written

thanks in advance

venu

Re: ALV LIST

Former Member — Thu, 08 Jun 2006 17:46:59 GMT

Hi,

Have a look at the programs in the package SLIS..

Regards,

Tanveer.

Please mark helpful answers

Re: ALV LIST

Former Member — Thu, 08 Jun 2006 19:15:14 GMT

Hi Venu,

The hope the below Link gives u the clear desc for ur criteria.

http://help.sap.com/saphelp_erp2004/helpdata/en/ff/4649b1f17411d2b486006094192fe3/content.htm

Re: ALV LIST

RichHeilman — Thu, 08 Jun 2006 19:20:04 GMT

Can you post your code please?

Regards,

Rich Heilman

Re: ALV LIST

Former Member — Fri, 09 Jun 2006 04:07:40 GMT

Hi Venu,

summation is being done on a particular value (Quantity field) and the summation is shown individually in terms of its units (units are differing).

Let as declare a field catalog table ITAB of type “TYPE slis_fieldcat_alv”

This field catalog table ITAB will have a number of fields defined by SAP for displaying a report in ALV format.

We will take into account two such fields viz. FIELDNAME and QFIELDNAME.

Regards,

Rayeez

Re: ALV LIST

Former Member — Fri, 09 Jun 2006 05:32:37 GMT

I THINK IT IS POSSIBLE to display subtot and total of curr ONLY IN alv_grid_diplay...first try with that...

if it is helpful plz rewards the points..

Re: ALV LIST

venkat_o — Fri, 09 Jun 2006 06:34:05 GMT

Hello Venugopal Raddy,

1.

For which field u want Subtotal and Grand total those fields should refer Currency or Quantity fields,

Ex:

insme TYPE mard-insme,

2.

Grand total on OutPut :

While building fieldcatalog ,mark w_field1-DO_SUM = 'X'.

Ex:

w_field1-fieldname = 'INSME' .

w_field1-do_sum = 'X'.

w_field1-tabname = 'I_MARD'.

w_field1-seltext_m = 'quality Stock'.

APPEND w_field1 TO i_field1.

CLEAR w_field1.

3.

Build i_sort table TYPE slis_t_sortinfo_alv.

For example :If Plant(WERKS) is changed ,subtotal should be displayed :

CLEAR :i_sort1[],w_sort1.

w_sort1-spos = 1.

w_sort1-fieldname = 'WERKS'.

w_sort1-tabname = 'I_MARD'.

w_sort1-up = 'X'.

APPEND w_sort1 TO i_sort1.

CLEAR w_sort1.

4.

Finally pass this Sort table to REUSE_ALV_LIST_DISPLAY.

I think that it helps u .

Thanks,

Venkat.O