topic Re: Subtotal Currency in Application Development and Automation Discussions

Subtotal Currency

Former Member — Tue, 08 Jul 2008 05:35:39 GMT

Hi All,

how to subtotal currency wise.

ex;

10 EURO

20 EURO

30 USD.

subtotal: 40 EURO

30 USD

Re: Subtotal Currency

bpawanchand — Tue, 08 Jul 2008 05:38:35 GMT

K_KKB_SUBTOTALS_CHECK

LVC_KKB_SUBTOTALS_CHECK

PRICAT_SUBTOTALS_READ

i hope they may use to get your sol

Regards

Pavan

Re: Subtotal Currency

Former Member — Tue, 08 Jul 2008 05:42:07 GMT

Hi,

check this link hope it will work...

Thanks,

Suman

Re: Subtotal Currency

Former Member — Tue, 08 Jul 2008 05:42:38 GMT

HI,

I want subtotal in ALV.

Re: Subtotal Currency

Former Member — Tue, 08 Jul 2008 05:44:55 GMT

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

Re: Subtotal Currency

venkatasriram_mygapula — Tue, 08 Jul 2008 05:48:08 GMT

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.

Re: Subtotal Currency

Former Member — Tue, 08 Jul 2008 05:48:44 GMT

Hi ,

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

Currency and pass field curency to sort table

Re: Subtotal Currency

Former Member — Tue, 08 Jul 2008 05:56:02 GMT

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

Re: Subtotal Currency

Former Member — Tue, 08 Jul 2008 06:08:35 GMT

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

Re: Subtotal Currency

Former Member — Tue, 08 Jul 2008 06:10:01 GMT

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

There you can give the subtotal text etc..

Re: Subtotal Currency

Former Member — Tue, 08 Jul 2008 06:18:52 GMT

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.

Re: Subtotal Currency

Former Member — Tue, 08 Jul 2008 06:41:36 GMT

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

can any one please help me getting this

Re: Subtotal Currency

Former Member — Tue, 08 Jul 2008 06:46:01 GMT

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

Regards

Shiva

Re: Subtotal Currency

Former Member — Tue, 08 Jul 2008 08:45:39 GMT

Thanks All