Sub-Totals and Totals Outputting Zeros

[Former Member]

Hi

I am struggling to get sub-totals and a report grand total. I can see them on the output but no data is getting into them.

Kind Regards

Brett

Coding approach

Global Data

V_DEPT_SUBTOTAL TYPE KONWA

V_TOTAL TYPE KONWA

V_N TYPE KONWA

Table > Calculations Tab

Operation Field Name Target Field Name Time Reset For Field Name

Total V_N V_DEPT_SUBTOTAL After Loop Sort Criterion ZDEPT

Total V_N V_TOTAL After Loop

Under Event on Sort End

Program Lines - Sub-Total

SHIFT V_DEPT_SUBTOTAL LEFT DELETING LEADING '0'.

Under Footer

Program Lines - Report Total

SHIFT V_TOTAL LEFT DELETING LEADING '0'.

Texts for the totals added to relevant places in the FORM, i.e. Subtotal - Event on Sort End and Total - Table Footer

[Former Member]

Hi Brett,

can you please explain about your requirement more clearly. Is it that you have used a Table in your main window and have created a line type for subtotal and printing the subtotal in that line and printing the Total in the footer of the table. You are able to see the subtotal and total text in the respective boxes but couldnt see the values for the same.

Please let me know if my understanding of your requirement is correct. can you also provide the table structure which you are displaying in the form.

Regards,

Praveenkumar T.

[Former Member]

Hi Praveen

You are 100% correct. Here is the table structure

MANDT MANDT CLNT 3 0 Client

ZDEPT ZDEDEPTNO NUMC 3 0 Department Number

ZEMP_NO ZDEEMPNO NUMC 4 0 Employee Number

ZEMP_NAME ZDEEMPNAME CHAR 30 0 Employee Name

ZDEPT_NAME ZDEDEPTNAME CHAR 30 0 Department Name

ZCURRENCY WAERS_V02D CUKY 5 0 Currency

ZSALARY_GROSS ZDESALGR CURR 15 2 Gross Salary

ZSALARY_DEDUCT ZDEDED CURR 15 2 Deductions

ZSALARY_NET ZDESALNT CURR 15 2 Net Salary

DELE CHAR 1 0 Deletion Indictaor

[Former Member]

Do you want it in an ALV report?

[madhu_vadlamani]

Hi Brett,

I can see them on the output but no data is getting into them..It is not clear.

Regards,

Madhu.