Subtotal Currency

[Former Member]

Hi All,

how to subtotal currency wise.

ex;

10 EURO

20 EURO

30 USD.

subtotal: 40 EURO

30 USD

[Former Member]

HI,

I want subtotal in ALV.

[bpawanchand]

Hi

FM

K_KKB_SUBTOTALS_CHECK

LVC_KKB_SUBTOTALS_CHECK

PRICAT_SUBTOTALS_READ

i hope they may use to get your sol

Regards

Pavan

[Former Member]

HI,

I want subtotal in ALV.

[Former Member]

Hi,

check this link hope it will work...

Thanks,

Suman

[Former Member]

Hi gs_p,

Make use of control statements. first sort the internal table by currency field. while looping the table. Do as follows :

loop at itab,

   w_total  =  w_total + wa-price.

   at end of curr.

       write :/ w_total.

   endat.

endloop.

Regards,

Swapna.

Edited by: NagaSwapna Thota on Jul 8, 2008 7:45 AM

[venkatasriram_mygapula]

Hi,

if u want to subtotals in alv there is field in fieldcatlog

fieldcatlog-datatype = 'CURR'.

fieldcatlog-do_some = 'X'.

if you use these two fields to which field you want to subtotals.

you can get the sub totals.

[Former Member]

Hi ,

You can use sort table in ALV field catalog.Sort the table by

Currency and pass field curency to sort table

[Former Member]

Hi ,

If you use alv grid , subtotals will be given automatically.YOu can refer BCALV_GRID_02 .After excuting this you can click subtotal on currency field.You will get subtotal currency wise.

Reward points if help full

[Former Member]

Hi but i want to display Currency text like 40 EURO or 20 USD in subtotal line.

[Former Member]

Then you can check the Link in the Above post mentioned by Suman...

There you can give the subtotal text etc..

[Former Member]

pass the values to sort parameter of the alv display function module.

while filling the sort table pass the column name and pass value X to subtotal field.

here is the sample code

• Sort table by two levels of hierarchy

REFRESH T_SORT.

PERFORM PREPARE_SORTTABLE CHANGING T_SORT.

CALL METHOD W_GRID

->SET_TABLE_FOR_FIRST_DISPLAY

EXPORTING

IS_LAYOUT = FS_LAYOUT

CHANGING

IT_OUTTAB = T_FINAL[]

IT_FIELDCATALOG = T_FLDCAT[]

IT_SORT = T_SORT[]

EXCEPTIONS

INVALID_PARAMETER_COMBINATION = 1

PROGRAM_ERROR = 2

TOO_MANY_LINES = 3

OTHERS = 4.

• Structure for sort table

DATA:

LFS_SORT TYPE LVC_S_SORT.

LFS_SORT-SPOS = '1'.

LFS_SORT-FIELDNAME = 'PRDHA1'.

LFS_SORT-UP = 'X'.

LFS_SORT-SUBTOT = 'X'.

APPEND LFS_SORT TO PV_T_SORT.

CLEAR LFS_SORT.

LFS_SORT-SPOS = '2'.

LFS_SORT-FIELDNAME = 'PRDHA2'.

LFS_SORT-UP = 'X'.

LFS_SORT-SUBTOT = 'X'.

APPEND LFS_SORT TO PV_T_SORT.

[Former Member]

I want to display grid like BCALV_GRID_02 program when summation is clicked.

can any one please help me getting this

[Former Member]

Hi

Try using SORT on the currency field and pass the same to Function module

Regards

Shiva

[Former Member]

Thanks All