topic Re: Total for two different types on same output in Application Development and Automation Discussions

Total for two different types on same output

former_member386063 — Thu, 01 May 2014 18:09:08 GMT

Hello experts,

I have a smartform in which for example:

If it shows an output of 5 pages.Out of 5 pages, 2 pages shows Type 3 output and 3 pages shows Type 53 output.The pages of Type 3 comes in sequence and then the pages of Type 53 in sequence (Or of Type 53 first in sequence then Type 3 in sequence). I want to have the grand total of "amount" at the end of page where Type 3 gets ended and the grand total of amount values at the end of page where Type 53 gets ended.

The example which I have presented here is of 5 pages. It can of any number of pages. So I want to count Type 3 pages and Type 53 pages separately with there respective Grand Total amount at respective end pages.

Please Help Experts.

Regards,

Titiksha

Re: Total for two different types on same output

Private_Member_7726 — Thu, 01 May 2014 18:58:55 GMT

Hi,

You'd need two variables that will hold the numbers of last page for each type (l_page_type_3 and l_page_type_53, for example). I hope you are able to determine those... If not, one would need to see how you control the smartfrom page breaks to figure that out... Once you have figured out those, create final windows for totals output, with condition sfsy-page = l_page_type_3 and sfsy-page = l_page_type_53.

cheers,

Jānis

Re: Total for two different types on same output

Abhijit74 — Thu, 01 May 2014 19:11:13 GMT

Hello,

I am sure that you are displaying type 3 and 53 inside a loop. So, what you can do is take two variables for type3 and 53. Inside your loop after displaying all of your cell you can create a program lines and there you can put sum3 = sum3 + itab-amount.

sum5 = sum5 + itab-amount.

You can also take a look into subtoal in smartforms.

Thanks & Regards,

Abhijit

Re: Total for two different types on same output

former_member386063 — Fri, 02 May 2014 11:41:11 GMT

Hello,

Please tell me how to determine type 3 is ending in which page on runtime.

Regards,

Titiksha

Re: Total for two different types on same output

former_member188827 — Fri, 02 May 2014 11:50:00 GMT

In smartforms, use event to achieve this. In Tables node, first define "type" as your sort field and check the checkbox "Event on Sort End". In calculations tab, add your subtotals field.Then create a table line on event and place your variable in a text element. After subtotal text node, create program lines and clear the subtotal variable. you can search this further on SCN.

Regards

Re: Total for two different types on same output

Private_Member_7726 — Sat, 03 May 2014 08:47:39 GMT

Hi,

Do you already have an existing smartfom to adjust, or are you building a new one..? How is the data for which you calculate totals structured - one internal table, the way Abhijit and Mehwish assume, or something else? If you already do have a form - what pages are defined (one page to output both types, or a separate page for each type?)

cheers

Janis

Re: Total for two different types on same output

former_member386063 — Sun, 04 May 2014 17:10:05 GMT

Hello,

I have an already existing smartform to adjust and separate pages for both the types. One internal table is displaying the total.

Regards,

Titiksha

Re: Total for two different types on same output

Private_Member_7726 — Sun, 04 May 2014 18:07:26 GMT

Ok, then simply add a "dummy" Secondary Window on each page (or use the page header window, if there already is one in the form) and place the Abap code to assign current page number (variable sfsy-page) to l_page_type_3 or l_page_type_53 in those windows. Don't forget to clear the l_ variables in Initialization

The Final Window will permit you to output the totals at a static position "at the end of page". If the data to be summed is processed via Tables node and the total needs to come immediately after the end of table, try the Mehwish suggestion.

cheers,

Jānis

Re: Total for two different types on same output

former_member386063 — Tue, 06 May 2014 03:20:51 GMT

Hello Mehwish,

I have done exactly as u said.

The thing is, it is already created smartform and total of every page is been done already by some other person in the footer part of table node.

I have to take those total into consideration, and have to do grandtotal at the end of respective types(Type 3 and Type 53).

I have done the things as u said, but if I create table line on event, it is created in Main area of table node. But I have to show the Grand total in the footer part below the total (which is already been done) at the end of respective types only.

Please help.

Regards,

Titiksha.

Re: Total for two different types on same output

Private_Member_7726 — Wed, 07 May 2014 07:45:48 GMT

Hi,

Then, I'm afraid, the only way would be to use code in sorting events to clear and set the flag that controls the output of type total and placing the actual output of type total in table footer (after page total). Basically, you have to clear the flag at Event on Sort Begin, and you set the flag at Event on Sort End.

To place the code within sorting events you have to "wrap" it in the table line node... Just make sure there is only the code node assigned to some cell and no nodes doing any actual output. Such a line type will be executed but will not produce any actual output.

I still don't know how your smartform controls page break per type... but I´have created and attached a simple SF with one page that illustrates the principle. This SF is using SPFLI as data table and CARRID as type. You would need some data in SPFLI to run it; program SAPBC_DATA_GENERATOR generates the data. The SF gets the data within INTIALIZATION of global SF data. Make sure there is at least 2 different CARRID selected... Hope you can figure it out; if not - just ask

cheers

Janis

Re: Total for two different types on same output

former_member386063 — Fri, 16 May 2014 11:26:53 GMT

Hello...

Thanks a lot for the help. Sorry for late reply.

Regards,

Titiksha

Re: Total for two different types on same output

Private_Member_7726 — Fri, 16 May 2014 11:39:37 GMT

You're welcome; I know one day you'll help with that someone else

cheers

Jānis

Re: Total for two different types on same output

former_member386063 — Mon, 19 May 2014 04:36:04 GMT

Hello,

I need one more help.

Now I need to display the page numbers according to 'Type' (3 or 53).

Example: Page: ____ of Total _____ Pages. at the header of the every page.

If there are two pages for Type 3 and two Pages to Type 53 then:

Page: 1 of Total 2 Pages -----( for Type 3).

Page: 2 of Total 2 Pages -----( for Type 3).

Page: 1 of Total 2 Pages ------( for Type 53).

Page: 2 of Total 2 Pages ------( for Type 53).

Please Help.

Regards,

Titiksha

Re: Total for two different types on same output

Private_Member_7726 — Mon, 19 May 2014 06:23:22 GMT

Hi,

Are there currently page counters somewhere in the form? If yes, I hope their output is not tied somehow to the table footer, because then we would need to find a way to calculate the total number of pages per type in advance...

cheers

Janis

Re: Total for two different types on same output

former_member386063 — Mon, 19 May 2014 06:35:29 GMT

Hello,

Nothing is been coded for this.

We need to do it ina separate window in header part.

Regards,

Titiksha

Re: Total for two different types on same output

former_member386063 — Tue, 20 May 2014 06:09:50 GMT

Hello,

Have you found out any solution for this?

I need to do it as early as possible.

Regards,

Titiksha

Re: Total for two different types on same output

Private_Member_7726 — Tue, 20 May 2014 07:26:12 GMT

Hi,

Sorry, I couldn't attend to this yesterday evening, and this morning... I seem to be unable to solve this seemingly simple requirement...

I'll try to solve it tonight. I'm starting to think it may be better idea to split the table in driver program an call the form per type.

Edit in: Ok, I was overthinking it, trying to use SFSY-PAGE and SFSY-FORMPAGES variables... I have now solved it in my example SF ZJBTT3 (see attached) as follows:

1) defined an internal table GT_PAGES, which will hold the page counters per type;

2) added an Abap node SET_PAGE_NUMBERS in data Table Footer->Total per page, which populates the type and TOTAL_PAGES columns in this table pro type ;

3) added a Final Window (will be processed when the rest of form logic is finished), where:

- in the Abap node GET_PAGE_NUMBERS:

- I'm reading first record in GT_PAGES; increasing the current page number, and, if the current page number = total page numbers per type, deleting GT_PAGES entry, otherwise modifying GT_PAGES with current page number;

- returning the GT_PAGES entry via GS_PAGES;

- in the text node I'm outputing GS_PAGES counters

I also changed the way ZJBTT3 handles table footers for the last page (via Flag in Table Footer definition, and not via explicit page break), because the previous version was producing extra white page at the end.

As always, it is important not to forget to clear/initialize the global variables in SF INITIALIZATION logic.

The reason why we need to use Final Window(s) here is - we will know the total pages per type only when the table processing is finished. Sorry for the somewhat chaotic description of algorithm - I hope you'll again figure out the principle from my example SF. If not - please ask again

cheers

Janis

Message was edited by: Jānis B

Re: Total for two different types on same output

Private_Member_7726 — Tue, 20 May 2014 12:40:41 GMT

And thanks for the question, I learned quite a bit trying to solve it!

cheers

Janis

Re: Total for two different types on same output

former_member386063 — Wed, 21 May 2014 04:41:01 GMT

Hello,

It is showing the error in Global Definition which is shared in above image.

Error: No component exists with the name 'PRIMARY_KEY'.....

Regards,

Titiksha

Re: Total for two different types on same output

Private_Member_7726 — Wed, 21 May 2014 07:22:51 GMT

Hi,

I developed it on ABAP 7.02 system, and you must be on a lower version then.

Try this attachment please - I rewrote it while trying to use 4.70 syntax only and it works on my system. If it still doesn't compile, get rid of SORTED and KEY additions in the table altogether.. you'd probably need to adjust the READ and MODIFY statements as well then.

cheers

Janis