topic Re: ALV filter in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/alv-filter/m-p/6797312#M1466848 <HTML><HEAD></HEAD><BODY><P>yes filteration is possible in alv...</P><P></P><P>please see the post</P><P></P><P>use like </P><P></P><P>DATA : IT_SORT TYPE SLIS_T_SORTINFO_ALV,</P><P>WA_SORT TYPE SLIS_SORTINFO_ALV,</P><P></P><P>WA_SORT-TABNAME = 'IT_OUTPUT'. " your internal table name</P><P>WA_SORT-FIELDNAME = 'AMOUNT'. " field name for Amount</P><P>WA_SORT-UP = 'X'.</P><P>WA_SORT-GROUP = 'X'.</P><P>WA_SORT-SUBTOT = 'X'.</P><P>APPEND WA_SORT TO IT_SORT.</P><P>CLEAR WA_SORT.</P><P></P><P>WA_SORT-TABNAME = 'IT_OUTPUT'.</P><P>WA_SORT-FIELDNAME = 'CURRENCY'. " field name for currency</P><P>WA_SORT-UP = 'X'.</P><P>WA_SORT-GROUP = 'X'.</P><P>WA_SORT-SUBTOT = 'X'.</P><P>APPEND WA_SORT TO IT_SORT.</P><P>CLEAR WA_SORT.</P><P></P><P>and</P><P></P><P>CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'</P><P>EXPORTING</P><P>I_CALLBACK_PROGRAM = SY-REPID</P><P>I_CALLBACK_TOP_OF_PAGE = 'TOP-OF-PAGE'</P><P>I_GRID_TITLE = ''</P><P>IS_LAYOUT = GS_LAYOUT</P><P>IT_FIELDCAT = IT_FIELDCAT</P><P>IT_SORT = IT_SORT</P><UL><LI level="1" type="ul"><P>IT_FILTER = IT_FILTER</P></LI></UL><P>I_DEFAULT = 'X'</P><P>I_SAVE = 'A'</P><P>TABLES</P><P>T_OUTTAB = IT_OUTPUT</P><P>EXCEPTIONS</P><P>PROGRAM_ERROR = 1</P><P>OTHERS = 2.</P><P>IF SY-SUBRC 0.</P><P>MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO</P><P>WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.</P><P>ENDIF.</P></BODY></HTML> Fri, 09 Apr 2010 06:08:39 GMT Former Member 2010-04-09T06:08:39Z ALV filter https://community.sap.com/t5/application-development-and-automation-discussions/alv-filter/m-p/6797311#M1466847 <HTML><HEAD></HEAD><BODY><P>Dear Experts,</P><P></P><P></P><P>May i have information on ALV filter options. Is t possible to filter fields on ALV, i.e. totlal column of fields and remaing fields are display all values.</P><P></P><P>venkey</P></BODY></HTML> Fri, 09 Apr 2010 05:19:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-filter/m-p/6797311#M1466847 former_member650792 2010-04-09T05:19:19Z Re: ALV filter https://community.sap.com/t5/application-development-and-automation-discussions/alv-filter/m-p/6797312#M1466848 <HTML><HEAD></HEAD><BODY><P>yes filteration is possible in alv...</P><P></P><P>please see the post</P><P></P><P>use like </P><P></P><P>DATA : IT_SORT TYPE SLIS_T_SORTINFO_ALV,</P><P>WA_SORT TYPE SLIS_SORTINFO_ALV,</P><P></P><P>WA_SORT-TABNAME = 'IT_OUTPUT'. " your internal table name</P><P>WA_SORT-FIELDNAME = 'AMOUNT'. " field name for Amount</P><P>WA_SORT-UP = 'X'.</P><P>WA_SORT-GROUP = 'X'.</P><P>WA_SORT-SUBTOT = 'X'.</P><P>APPEND WA_SORT TO IT_SORT.</P><P>CLEAR WA_SORT.</P><P></P><P>WA_SORT-TABNAME = 'IT_OUTPUT'.</P><P>WA_SORT-FIELDNAME = 'CURRENCY'. " field name for currency</P><P>WA_SORT-UP = 'X'.</P><P>WA_SORT-GROUP = 'X'.</P><P>WA_SORT-SUBTOT = 'X'.</P><P>APPEND WA_SORT TO IT_SORT.</P><P>CLEAR WA_SORT.</P><P></P><P>and</P><P></P><P>CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'</P><P>EXPORTING</P><P>I_CALLBACK_PROGRAM = SY-REPID</P><P>I_CALLBACK_TOP_OF_PAGE = 'TOP-OF-PAGE'</P><P>I_GRID_TITLE = ''</P><P>IS_LAYOUT = GS_LAYOUT</P><P>IT_FIELDCAT = IT_FIELDCAT</P><P>IT_SORT = IT_SORT</P><UL><LI level="1" type="ul"><P>IT_FILTER = IT_FILTER</P></LI></UL><P>I_DEFAULT = 'X'</P><P>I_SAVE = 'A'</P><P>TABLES</P><P>T_OUTTAB = IT_OUTPUT</P><P>EXCEPTIONS</P><P>PROGRAM_ERROR = 1</P><P>OTHERS = 2.</P><P>IF SY-SUBRC 0.</P><P>MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO</P><P>WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.</P><P>ENDIF.</P></BODY></HTML> Fri, 09 Apr 2010 06:08:39 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-filter/m-p/6797312#M1466848 Former Member 2010-04-09T06:08:39Z