Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Problem with summing up the currency fields

Former Member

‎2010 May 03 11:14 AM

0 Likes
535

The below is my code through which I cannot display hthe sum at the end for all the below fields please advice on the soln. Also srched in SDN the answers are bit ambigious/also tried.


gw_fieldcat-fieldname  = 'WTGXXX'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Material(Transaction currency)'.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

  gw_fieldcat-fieldname  = 'WOGXXX'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Material(Object currency)'.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

  gw_fieldcat-fieldname  = 'WKGXXX'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Material(Controlling area currency)'.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

  gw_fieldcat-fieldname  = 'WTGXXX1'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Labour(Transaction currency)'.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

  gw_fieldcat-fieldname  = 'WOGXXX1'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Labour(Object currency)'.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

  gw_fieldcat-fieldname  = 'WKGXXX1'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Labour(Controlling area currency)'.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

  gw_fieldcat-fieldname  = 'TOTAL1'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Total(Transaction currency)'.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

  gw_fieldcat-fieldname  = 'TOTAL2'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Total(Object currency) '.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

  gw_fieldcat-fieldname  = 'TOTAL3'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Total(Controlling area currency)'.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

thanks in advance.

The below is my code through which I cannot display hthe sum at the end for all the below fields please advice on the soln. Also srched in SDN the answers are bit ambigious/also tried.


gw_fieldcat-fieldname  = 'WTGXXX'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Material(Transaction currency)'.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

  gw_fieldcat-fieldname  = 'WOGXXX'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Material(Object currency)'.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

  gw_fieldcat-fieldname  = 'WKGXXX'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Material(Controlling area currency)'.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

  gw_fieldcat-fieldname  = 'WTGXXX1'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Labour(Transaction currency)'.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

  gw_fieldcat-fieldname  = 'WOGXXX1'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Labour(Object currency)'.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

  gw_fieldcat-fieldname  = 'WKGXXX1'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Labour(Controlling area currency)'.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

  gw_fieldcat-fieldname  = 'TOTAL1'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Total(Transaction currency)'.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

  gw_fieldcat-fieldname  = 'TOTAL2'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Total(Object currency) '.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

  gw_fieldcat-fieldname  = 'TOTAL3'.
  gw_fieldcat-datatype   = 'CURR'.
*  gw_fieldcat-cfieldname = 'WAERS'.
  gw_fieldcat-tabname    = 'gt_output'.
  gw_fieldcat-seltext_l  = 'Total(Controlling area currency)'.
  gw_fieldcat-no_zero    = 'X'.
  gw_fieldcat-do_sum     = 'X'.
  APPEND gw_fieldcat TO gt_fieldcat.
  CLEAR gw_fieldcat.

thanks in advance.

Reply
3 REPLIES 3
Read only

kesavadas_thekkillath
Active Contributor

‎2010 May 03 11:16 AM

0 Likes
485

Try passing datatype = 'DEC'.

Read only

SuhaSaha
Product and Topic Expert
Product and Topic Expert

‎2010 May 03 11:23 AM

0 Likes
485

How are the fields defined in your output table GT_OUTPUT ? Anyways in case of currency fields you have to pass the CFIELDNAME value, why have you commented that out ?

Also make sure you perform the [ALV Consistency Check|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/15961] [original link is broken] [original link is broken] [original link is broken]; to check if there are any errors.

BR,

Suhas

Read only

Former Member

‎2010 May 06 7:25 AM

0 Likes
485

Solve by self