topic Re: At New problem in Application Development and Automation Discussions

At New problem

former_member251546 — Mon, 08 Feb 2010 10:41:22 GMT

Hi,

Good day guys.

Control break event problem. plz can any one help me

Iam dev the alv report. its fine. but client has chaged the req. He need the req is first i need to disply the total and then items details.

Name Qty

boltes 30

boltes 10

so first ive summed the items and then appending items to final ita.

iam using nested loops. but its not working.

DATA : lwa_out1 TYPE zsalessm.

CLEAR: lwa_out5.
REFRESH: lt_machine_sales2,
lt_machine_sales4.
lt_machine_sales2[] = lt_machine_sales[].
SORT lt_machine_sales2 BY ktgrm_d.
SORT lt_machine_sales BY ktgrm_d.

LOOP AT lt_machine_sales INTO lwa_out5. " Here iam doing the total sum
AT NEW ktgrm_d.
SUM.
lwa_out5-sales_qty = lwa_out5-sales_qty * -1.
lwa_out5-act_sales_p = lwa_out5-act_sales_p * -1.
lwa_out5-act_cos_p = lwa_out5-act_cos_p * -1.
lwa_out5-act_gross_p = lwa_out5-act_gross_p * -1.
lwa_out5-act_gross_perc_P = lwa_out5-act_gross_perc_p * -1.
lwa_out5-netwr = lwa_out5-netwr * -1.

APPEND lwa_out5 TO lt_machine_sales4.

IF sy-subrc EQ 0.
LOOP AT lt_machine_sales2 INTO lwa_out1 where ktgrm_d = lwa_out5-ktgrm_d. " here iam appending the iteam details

APPEND lwa_out1 TO lt_machine_sales4.
clear:lwa_out1.
ENDLOOP.
ENDIF.
clear:lwa_out5.
ENDAT.
ENDLOOP.

Plz any one tell me how to do it?

Regards

Re: At New problem

Former Member — Mon, 08 Feb 2010 10:54:45 GMT

Hi,

Are you not able to sum up the items or you are not able to append the items into new internal table.

Actually, you can do both the things in a single step.

Just loop at you internla table. Thn, use collect statement to sum up the items, at the same time before summing up you can append your work area to new internal table. So, it will solve both issues.

Thanks

Archana

Re: At New problem

former_member206377 — Mon, 08 Feb 2010 10:56:59 GMT


iam using nested loops. but its not working.

What is the issue you are facing?Are you getting any error/ data is not getting filled??

Re: At New problem

former_member251546 — Mon, 08 Feb 2010 10:59:35 GMT

Hi,

Good day

Thank you. sorry for the disterb u. Generally for summing i did At New event.

If you dont mind, plz send sample code for it.

REgards

Re: At New problem

former_member251546 — Mon, 08 Feb 2010 11:00:45 GMT

Data was filed.

Re: At New problem

Former Member — Mon, 08 Feb 2010 11:07:08 GMT

Hi,

You can do F1 on collect statement for more information. Refer to the below code:

LOOP AT lt_machine_sales INTO lwa_out5. " Here iam doing the total sum

 APPEND lwa_out1 TO " your new internal table.
 Collect lwa_out5 into lt_machine_sales4.
 clear:lwa_out1, lwa_out5.
ENDLOOP.

Thanks,

Archana

Re: At New problem

former_member491305 — Mon, 08 Feb 2010 11:07:29 GMT

Hi,

No need for nested loop.You can do the achieve the same by putting the detailed item level append after the AT ENDAT block.

Pls look at the below sample.

LOOP AT lt_machine_sales INTO lwa_out5.

lwa_out = lwa_out5.

AT NEW ktgrm_d.

SUM.

lwa_out5-sales_qty = lwa_out5-sales_qty * -1.

lwa_out5-act_sales_p = lwa_out5-act_sales_p * -1.

lwa_out5-act_cos_p = lwa_out5-act_cos_p * -1.

lwa_out5-act_gross_p = lwa_out5-act_gross_p * -1.

lwa_out5-act_gross_perc_P = lwa_out5-act_gross_perc_p * -1.

lwa_out5-netwr = lwa_out5-netwr * -1.

APPEND lwa_out5 TO lt_machine_sales4.

ENDAT.

APPEND lwa_out TO lt_machine_sales4.

ENDLOOP.

Regards,

Vignesh.

Re: At New problem

Former Member — Mon, 08 Feb 2010 11:11:53 GMT

While using at new. Following is the standard functionality:

say itab1 has field F1, F2, F3.

So in when you give

loop at itab1.

at new F2.

UR logic

endat.

endloop.

If the value of F1 changes and F2 is still the same. It will execute the At new logic.(i.e. if value of any of pramaters upto current paramter changed the At new Logic will be executed).

Please check if this is working fine.

Hoping it helps..

Regards,

Komal

Re: At New problem

former_member251546 — Mon, 08 Feb 2010 11:19:10 GMT

hi,

Thank you vignaswaran. ur right 100% coding. but i dont know ,At New event is not working.

when iam summing the Qty, Act sales, Act cost..and etc.. these r not summing.

When i was debugging..its not -ve value lke 123-

thats why ive taken values one which the fields are getting the -ve like "lwa_out5-sales_qty = lwa_out5-sales_qty * -1."

But still there is prob. its not summing

Thank you

Regards

Re: At New problem

former_member491305 — Mon, 08 Feb 2010 11:26:38 GMT

Hi,

I am not sure ..how is your internal table is declared.If you are using KTGRM_D alone for summing the line,then make sure you declare KTGRM_D as a first field in the internal table .You are already sorted the intenral table by KTGRM_D .That is fine.

Thanks,

Vigneswaran.

Re: At New problem

former_member251546 — Mon, 08 Feb 2010 11:31:33 GMT

hi,

Iam sorry i didnt tell you.

In the internal table there is first field Mt_pos.

Mt_pos got two values Znarm , NORM. But in my report mt-pos will not be displayed.

If ive sorted the based on mt_pos. its diffecult to summed the Items.

My itab Data is like below

Mtpos ktgrm_d values

znarm ind 10

norm ind 10

znarm aus 10

REgards

Raghu

Re: At New problem

former_member491305 — Mon, 08 Feb 2010 11:45:39 GMT

Hi,

Since you have not put KTGRM_D as a first field in internal table ,the control break statement AT NEW did not summ up correctly.

These are the two basic steps need to be followed before using control break statement.

1.The field(s) to be considered for summing up the line should be on the left hand side of the internal table.

2.The internal table should be sorted by those field(s).

Since the first condition is not satisfied in your case,the summation is going wrong.Put KTGRM_D field as a first field in internal table and then check your output.It should summ up correctly.

Thanks,

Vigneswaran .

Re: At New problem

former_member251546 — Mon, 08 Feb 2010 11:48:44 GMT

Its not summing rightly. Can u plz send the solution plz

Regards

Re: At New problem

former_member491305 — Mon, 08 Feb 2010 11:57:01 GMT

Hi,

check out the below code.If you still say it is not summing up correclty,then just show me the actual content of the itab and also the summarized value you get.


Data:beging of  lwa_out5,
        KTGRM_d type c,
        Mtpos type posnr,
        qty1 type ..,
        qty2 type .
        end of lwa_out5,

lt_machine_sales like standard table of lwa_out5.
lt_machine_sales2 like standard table of lwa_out5.

 CLEAR: lwa_out5.
 REFRESH: lt_machine_sales2,
lt_machine_sales4.
 lt_machine_sales2] = lt_machine_sales[.
 SORT lt_machine_sales2 BY ktgrm_d.
 SORT lt_machine_sales BY ktgrm_d.

LOOP AT lt_machine_sales INTO lwa_out5. 
lwa_out = lwa_out5.
AT NEW ktgrm_d.
SUM.
lwa_out5-sales_qty = lwa_out5-sales_qty * -1.
lwa_out5-act_sales_p = lwa_out5-act_sales_p * -1.
lwa_out5-act_cos_p = lwa_out5-act_cos_p * -1.
lwa_out5-act_gross_p = lwa_out5-act_gross_p * -1.
lwa_out5-act_gross_perc_P = lwa_out5-act_gross_perc_p * -1.
lwa_out5-netwr = lwa_out5-netwr * -1.

APPEND lwa_out5 TO lt_machine_sales4.

ENDAT.

APPEND lwa_out TO lt_machine_sales4.
ENDLOOP.

Thanks,

Vigneswaran.

Re: At New problem

former_member251546 — Mon, 08 Feb 2010 12:23:30 GMT

hi,

Ive declared the data as below as

DATA: lwa_out1 type zsalessm.
  DATA: lwa_out5 type zsalessm.
: DATA  : lt_machine_sales4  TYPE TABLE OF zsalessm.
DATA  : lt_machine_sales  TYPE TABLE OF zsalessm.


And coding
SORT lt_machine_sales BY ktgrm_d ascending.

  LOOP AT lt_machine_sales INTO lwa_out5.
    lwa_out1 = lwa_out5.
    AT NEW ktgrm_d.
      SUM.
      lwa_out5-sales_qty = lwa_out5-sales_qty * -1.
      lwa_out5-act_sales_p = lwa_out5-act_sales_p * -1.
      lwa_out5-act_cos_p = lwa_out5-act_cos_p * -1.
      lwa_out5-act_gross_p = lwa_out5-act_gross_p * -1.
      lwa_out5-act_gross_perc_P = lwa_out5-act_gross_perc_p * -1.
      lwa_out5-netwr      = lwa_out5-netwr * -1.
      APPEND lwa_out5 TO lt_machine_sales4.
      clear:lwa_out5.
     ENDAT.

     Append lwa_out1 To lt_machine_sales4.
     clear:lwa_out1.


  ENDLOOP.

I think, except data dec, remaining everything is same. I told you how my data wil looks like. if you dont mind, can u send << request for personal information removed >> . so i can send the print screen of dubug itab data.

Thank you very much for supporting

regards

Moderator message - Please use code tags to format your code

Edited by: Rob Burbank on Feb 8, 2010 2:19 PM

Re: At New problem

former_member491305 — Mon, 08 Feb 2010 13:06:47 GMT

Hi,

No need to worry about in which order the output fields is going to be displayed.In output,you can change the order of the fields displayed like any way and it does not necessarry be in same order like intenal table declaration.

So in your internal table declaration,instead of refering ZSALESMM structure,declare individual fields with the order mentioned in previous post.It should work.I dont think a any other better way than that.

Thanks,

Vignesh.

Re: At New problem

mike_m1 — Mon, 08 Feb 2010 16:38:38 GMT

Do you really need to resolve this issue with ABAP code?

Have you tried to create and save an ALV Grid display variant which includes subtotals/totals? These totals can be displayed before the entries they summarise.

Mike

Edited by: Mike Morgan on Feb 8, 2010 5:41 PM

Re: At New problem

Former Member — Mon, 08 Feb 2010 18:43:14 GMT

If this is a report you want to create, simply use "reuse_alv_list_display" or "reuse_alv_grid_display" and pass the internal table to the function module and display ur report., the user can use various operations on the OUTPUT displayed by using the Graphical Items on the display Page,.

eg: there is subtotal icon, grand total icon, sort icon's, list choose icon, export to presentation server icons, etc

sap has provided many things predefined use them to ur will........

Cheers,

Shravs

Re: At New problem

Former Member — Mon, 08 Feb 2010 18:44:36 GMT

i mean explain to the user the various advantages of using graphical user display...............

Hope it helps u find a solution cheaply...........

Re: At New problem

Former Member — Mon, 08 Feb 2010 19:11:24 GMT

Balaji,

After the "AT NEW ktgrm_d.", you also need to add this statement:

READ TABLE lt_machine_sales INTO lwa_out5 INDEX SY-TABIX.

This is needed if you access the fields defined after ktgrm_d.

Thanks,

Bhanu