Skip to Content
author's profile photo Former Member
Former Member

An ALV requirement

Hi all

my requirement is i need to get the min of the last column (mv-minimum value) for each employee and i should get the total (tmvs- total minimun values ) of all these minimun values for all the emp # . i dont want the subtotals now . ( if subtotal is also possible let me also know the solution ) .

this should be done in alv.

my questions are

1) is there any field definition in SLIS_FIELDCAT_ALV ,..etc to calclulate the total , sub total in the program and assign in ALV display -Funtion module .

2) is there any other way to get the job done.

see the give data below

1001	LXHO	PUNI		            Joe Trebisky	01/01/1999	1,000,000.00
1001	LXHO	PUNI		            Joe Trebisky	05/01/1999	1,000,000.00
1001	LXHO	PUNI		            Joe Trebisky	06/01/1999	1,000,000.00
1001	LXHO	PUNI		            Joe Trebisky	01/01/2000	250,000.00
1001	LXHO	PUNI		            Joe Trebisky	02/01/2000	250,000.00
1001	LXHO	PUNI		            Joe Trebisky	03/02/2000	250,000.00
1001	LXHO	PUNI		            Joe Trebisky	09/15/2003	

									mv	250,000.00
                                  
3902	AACI	ABEL	10000078	MXN TCS Allied Salaried	12/30/2001	38,052.00
3902	AACI	ABEL	10000078	MXN TCS Allied Salaried	01/01/2003	35,125.00
3902	AACI	ABEL	10000078	MXN TCS Allied Salaried	05/16/2004	50,000.00
3902	AACI	ABEL	10000078	MXN TCS Allied Salaried	05/17/2004	00
3902	AACI	ABEL	10000078	MXN TCS Allied Salaried	01/01/2005	96,000.00
                                                                                mv       35,125

								        tmvs	285125

if any body has the information on this . i will be helpful to them

cheers

senthil bala

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 11, 2005 at 12:59 PM

    Hi senthil,

    well... if you display the data thru FM REUSE_ALV_LIST_DISPLAY, then you can check the amount column, press button "Total" (you know, the one with the "sigma"-letter), and then go to menu "Edit > Compute > Mininum" (please forgive me, but I cannot view it in english, just in spanish, so the menu path may change 😀). So the totalized column will now show just the minimum.

    Please let me know if it helped. BR,

    Alvaro

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Am getting the min value in subtotal but not in the final total

      subtotal are in bold n

      total in bold n underlined

      1001	LXHO	PUNI		Joe Trebisky	01/01/1999	1,000,000.00
      1001	LXHO	PUNI		Joe Trebisky	05/01/1999	1,000,000.00
      1001	LXHO	PUNI		Joe Trebisky	06/01/1999	1,000,000.00
      1001	LXHO	PUNI		Joe Trebisky	01/01/2000	250,000.00
      1001	LXHO	PUNI		Joe Trebisky	02/01/2000	250,000.00
      1001	LXHO	PUNI		Joe Trebisky	03/02/2000	250,000.00
      1001	LXHO	PUNI		Joe Trebisky	09/15/2003	
      1001				                     
                           <b>1,000,000.00</b>
      3902	AACI	ABEL	10000078	MXN TCS Allied Salaried	12/30/2001	38,052.00
      3902	AACI	ABEL	10000078	MXN TCS Allied Salaried	01/01/2003	35,125.00
      3902	AACI	ABEL	10000078	MXN TCS Allied Salaried	05/16/2004	50,000.00
      3902	AACI	ABEL	10000078	MXN TCS Allied Salaried	05/17/2004	
      3902	AACI	ABEL	10000078	MXN TCS Allied Salaried	01/01/2005	96,000.00
      3902						<b>96,000.00</b>
      						                                      <b><u>1,000,000.00</u></b>
      

      Message was edited by: senthil bala

      Message was edited by: senthil bala

      Message was edited by: senthil bala

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.