ALV LIST

[Former Member]

Hi

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

[Former Member]

Hi

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

[former_member181966]

see the demo`s in SE38 = BALVDEMO*

Hope this’ll give you idea!!

<b>P.S award the points.</b>

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

[Former Member]

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

[RichHeilman]

Can you post your code please?

Regards,

Rich Heilman

[Former Member]

Hi,

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

Regards,

Tanveer.

<b>Please mark helpful answers</b>

[Former Member]

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

[Former Member]

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

[Former Member]

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..

[venkat_o]

Hello Venugopal Raddy,

<b>1</b>.

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

Ex:

insme TYPE mard-insme,

<b>2</b>.

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.

<b>3</b>.

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.

<b>4</b>.

Finally pass this Sort table to REUSE_ALV_LIST_DISPLAY.

I think that it helps u .

<b>Thanks,

Venkat.O</b>