topic Re: ALV output problem. in Application Development and Automation Discussions

topic Re: ALV output problem. in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/alv-output-problem/m-p/2444708#M547478 <HTML><HEAD></HEAD><BODY><P>You can still use the FM to populate the field catalog. Just define the internal table like this:</P><P></P><PRE><CODE>data: begin of s_sflight2, carrid LIKE sflight-carrid, connid LIKE sflight-connid, fldate LIKE sflight-fldate, price LIKE sflight-price , seatsmax LIKE sflight-seatsmax, end of s_sflight2.</CODE></PRE><P></P><P>And move the internal table name to a varaible like this:</P><PRE><CODE>data: p_tabname TYPE slis_fieldcat_alv-tabname move 'S_SFLIGHT2' to p_tabname.</CODE></PRE><P></P><P>Then call the field catalog FM:</P><PRE><CODE>CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' EXPORTING i_program_name = sy-cprog i_internal_tabname = p_tabname *i_structure_name = p_tabname * I_CLIENT_NEVER_DISPLAY = 'X' i_inclname = sy-cprog i_bypassing_buffer = 'X' i_buffer_active = ' ' CHANGING ct_fieldcat = t_fieldcat EXCEPTIONS inconsistent_interface = 1 program_error = 2 OTHERS = 3.</CODE></PRE><P></P><P>This should give you the output.</P><P></P><P><b>Points are always welcome!!</b></P><P></P><P>Minami</P></BODY></HTML> Thu, 21 Jun 2007 20:48:41 GMT Former Member 2007-06-21T20:48:41Z ALV output problem. https://community.sap.com/t5/application-development-and-automation-discussions/alv-output-problem/m-p/2444706#M547476 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P> when i am executing the program,i am not any list out instead i am viewing blank list without no field values .</P><P>Here is my code:</P><P>type-pools:slis.</P><P>types:begin of s_sflight,</P><P> carrid like sflight-carrid,</P><P> connid like sflight-connid,</P><P> fldate like sflight-fldate,</P><P> price like sflight-price ,</P><P> seatsmax like sflight-seatsmax,</P><P> end of s_sflight.</P><P></P><P> data:it_sflight type standard table of s_sflight.</P><P> data:wa_sflight like it_sflight.</P><P></P><P> data:t_fieldcat type slis_t_fieldcat_alv ,"WITH HEADER LINE,</P><P> v_repid like sy-repid.</P><P></P><P> select carrid connid fldate price seatsmax</P><P> into table it_sflight from sflight.</P><P></P><P></P><P>CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'</P><P> EXPORTING</P><P> I_PROGRAM_NAME = v_repid</P><P> I_INTERNAL_TABNAME = 'IT_SFLIGHT'</P><P> I_STRUCTURE_NAME = 'S_SFLIGHT'</P><UL><LI level="1" type="ul"><P> I_CLIENT_NEVER_DISPLAY = 'X'</P></LI></UL><P> I_INCLNAME = v_repid</P><P> I_BYPASSING_BUFFER = 'X'</P><P> I_BUFFER_ACTIVE = ' '</P><P> CHANGING</P><P> CT_FIELDCAT = t_fieldcat</P><P> EXCEPTIONS</P><P> INCONSISTENT_INTERFACE = 1</P><P> PROGRAM_ERROR = 2</P><P> OTHERS = 3</P><P> .</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><P></P><P>CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'</P><P> EXPORTING</P><UL><LI level="1" type="ul"><P> I_INTERFACE_CHECK = ' '</P></LI></UL><P> I_BYPASSING_BUFFER = 'X'</P><P> I_BUFFER_ACTIVE = ' '</P><P> I_CALLBACK_PROGRAM = v_repid</P><UL><LI level="1" type="ul"><P> I_CALLBACK_PF_STATUS_SET = ' '</P></LI><LI level="1" type="ul"><P> I_CALLBACK_USER_COMMAND = ' '</P></LI></UL><P> I_STRUCTURE_NAME = 'S_SFLIGHT'</P><UL><LI level="1" type="ul"><P> IS_LAYOUT =</P></LI></UL><P> IT_FIELDCAT = t_fieldcat</P><UL><LI level="1" type="ul"><P> IT_EXCLUDING =</P></LI><LI level="1" type="ul"><P> IT_SPECIAL_GROUPS =</P></LI><LI level="1" type="ul"><P> IT_SORT =</P></LI><LI level="1" type="ul"><P> IT_FILTER =</P></LI><LI level="1" type="ul"><P> IS_SEL_HIDE =</P></LI><LI level="1" type="ul"><P> I_DEFAULT = 'X'</P></LI></UL><P> I_SAVE = 'A'</P><UL><LI level="1" type="ul"><P> IS_VARIANT =</P></LI><LI level="1" type="ul"><P> IT_EVENTS =</P></LI><LI level="1" type="ul"><P> IT_EVENT_EXIT =</P></LI><LI level="1" type="ul"><P> IS_PRINT =</P></LI><LI level="1" type="ul"><P> IS_REPREP_ID =</P></LI><LI level="1" type="ul"><P> I_SCREEN_START_COLUMN = 0</P></LI><LI level="1" type="ul"><P> I_SCREEN_START_LINE = 0</P></LI><LI level="1" type="ul"><P> I_SCREEN_END_COLUMN = 0</P></LI><LI level="1" type="ul"><P> I_SCREEN_END_LINE = 0</P></LI><LI level="1" type="ul"><P>IMPORTING</P></LI><LI level="1" type="ul"><P> E_EXIT_CAUSED_BY_CALLER =</P></LI><LI level="1" type="ul"><P> ES_EXIT_CAUSED_BY_USER =</P></LI></UL><P> TABLES</P><P> T_OUTTAB = IT_SFLIGHT</P><UL><LI level="1" type="ul"><P>EXCEPTIONS</P></LI><LI level="1" type="ul"><P> PROGRAM_ERROR = 1</P></LI><LI level="1" type="ul"><P> OTHERS = 2</P></LI></UL><P> .</P><P>IF SY-SUBRC <> 0.</P><UL><LI level="1" type="ul"><P>MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO</P></LI><LI level="1" type="ul"><P> WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.</P></LI></UL><P>ENDIF.</P></BODY></HTML> Thu, 21 Jun 2007 19:45:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-output-problem/m-p/2444706#M547476 Former Member 2007-06-21T19:45:19Z Re: ALV output problem. https://community.sap.com/t5/application-development-and-automation-discussions/alv-output-problem/m-p/2444707#M547477 <HTML><HEAD></HEAD><BODY><P>Field catalog is empty now. you can populate like </P><P></P><P>type-pools:slis.</P><P>types:begin of s_sflight,</P><P>carrid like sflight-carrid,</P><P>connid like sflight-connid,</P><P>fldate like sflight-fldate,</P><P>price like sflight-price ,</P><P>seatsmax like sflight-seatsmax,</P><P>end of s_sflight.</P><P></P><P>data:it_sflight type standard table of s_sflight.</P><P>data:wa_sflight like it_sflight.</P><P></P><P>data:t_fieldcat type slis_t_fieldcat_alv ,</P><P> WA_FIELDCAT TYPE SLIS_FIELDCAT_ALV,</P><P>v_repid like sy-repid.</P><P></P><P>select carrid connid fldate price seatsmax</P><P>into table it_sflight from sflight.</P><P></P><P>WA_fieldcat-fieldname = 'CARRID'.</P><P>wa_fieldcat-reptext_ddic = 'Airline Code'.</P><P>APPEND WA_FIELDCAT TO T_FIELDCAT.</P><P></P><P>WA_fieldcat-fieldname = 'CONNID'.</P><P>wa_fieldcat-reptext_ddic = 'Fl. Conn. NO.'.</P><P>APPEND WA_FIELDCAT TO T_FIELDCAT.</P><P></P><P>WA_fieldcat-fieldname = 'FLDATE'.</P><P>wa_fieldcat-reptext_ddic = 'Flight date'.</P><P>APPEND WA_FIELDCAT TO T_FIELDCAT.</P><P></P><P>WA_fieldcat-fieldname = 'PRICE'.</P><P>wa_fieldcat-reptext_ddic = 'Airfare'.</P><P>APPEND WA_FIELDCAT TO T_FIELDCAT.</P><P></P><P>WA_fieldcat-fieldname = 'SEATSMAX'.</P><P>wa_fieldcat-reptext_ddic = 'Maximum capacity in economy class'.</P><P>APPEND WA_FIELDCAT TO T_FIELDCAT.</P><P></P><P></P><P>CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'</P><P>EXPORTING</P><UL><LI level="1" type="ul"><P>I_INTERFACE_CHECK = ' '</P></LI></UL><P>I_BYPASSING_BUFFER = 'X'</P><P>I_BUFFER_ACTIVE = ' '</P><P>I_CALLBACK_PROGRAM = v_repid</P><UL><LI level="1" type="ul"><P>I_CALLBACK_PF_STATUS_SET = ' '</P></LI><LI level="1" type="ul"><P>I_CALLBACK_USER_COMMAND = ' '</P></LI></UL><P>I_STRUCTURE_NAME = 'S_SFLIGHT'</P><UL><LI level="1" type="ul"><P>IS_LAYOUT =</P></LI></UL><P>IT_FIELDCAT = t_fieldcat</P><UL><LI level="1" type="ul"><P>IT_EXCLUDING =</P></LI><LI level="1" type="ul"><P>IT_SPECIAL_GROUPS =</P></LI><LI level="1" type="ul"><P>IT_SORT =</P></LI><LI level="1" type="ul"><P>IT_FILTER =</P></LI><LI level="1" type="ul"><P>IS_SEL_HIDE =</P></LI><LI level="1" type="ul"><P>I_DEFAULT = 'X'</P></LI></UL><P>I_SAVE = 'A'</P><UL><LI level="1" type="ul"><P>IS_VARIANT =</P></LI><LI level="1" type="ul"><P>IT_EVENTS =</P></LI><LI level="1" type="ul"><P>IT_EVENT_EXIT =</P></LI><LI level="1" type="ul"><P>IS_PRINT =</P></LI><LI level="1" type="ul"><P>IS_REPREP_ID =</P></LI><LI level="1" type="ul"><P>I_SCREEN_START_COLUMN = 0</P></LI><LI level="1" type="ul"><P>I_SCREEN_START_LINE = 0</P></LI><LI level="1" type="ul"><P>I_SCREEN_END_COLUMN = 0</P></LI><LI level="1" type="ul"><P>I_SCREEN_END_LINE = 0</P></LI><LI level="1" type="ul"><P>IMPORTING</P></LI><LI level="1" type="ul"><P>E_EXIT_CAUSED_BY_CALLER =</P></LI><LI level="1" type="ul"><P>ES_EXIT_CAUSED_BY_USER =</P></LI></UL><P>TABLES</P><P>T_OUTTAB = IT_SFLIGHT</P><UL><LI level="1" type="ul"><P>EXCEPTIONS</P></LI><LI level="1" type="ul"><P>PROGRAM_ERROR = 1</P></LI><LI level="1" type="ul"><P>OTHERS = 2</P></LI></UL><P>.</P><P>IF SY-SUBRC <> 0.</P><UL><LI level="1" type="ul"><P>MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO</P></LI><LI level="1" type="ul"><P>WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.</P></LI></UL><P>ENDIF.</P></BODY></HTML> Thu, 21 Jun 2007 20:33:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-output-problem/m-p/2444707#M547477 Former Member 2007-06-21T20:33:23Z Re: ALV output problem. https://community.sap.com/t5/application-development-and-automation-discussions/alv-output-problem/m-p/2444708#M547478 <HTML><HEAD></HEAD><BODY><P>You can still use the FM to populate the field catalog. Just define the internal table like this:</P><P></P><PRE><CODE>data: begin of s_sflight2, carrid LIKE sflight-carrid, connid LIKE sflight-connid, fldate LIKE sflight-fldate, price LIKE sflight-price , seatsmax LIKE sflight-seatsmax, end of s_sflight2.</CODE></PRE><P></P><P>And move the internal table name to a varaible like this:</P><PRE><CODE>data: p_tabname TYPE slis_fieldcat_alv-tabname move 'S_SFLIGHT2' to p_tabname.</CODE></PRE><P></P><P>Then call the field catalog FM:</P><PRE><CODE>CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' EXPORTING i_program_name = sy-cprog i_internal_tabname = p_tabname *i_structure_name = p_tabname * I_CLIENT_NEVER_DISPLAY = 'X' i_inclname = sy-cprog i_bypassing_buffer = 'X' i_buffer_active = ' ' CHANGING ct_fieldcat = t_fieldcat EXCEPTIONS inconsistent_interface = 1 program_error = 2 OTHERS = 3.</CODE></PRE><P></P><P>This should give you the output.</P><P></P><P><b>Points are always welcome!!</b></P><P></P><P>Minami</P></BODY></HTML> Thu, 21 Jun 2007 20:48:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-output-problem/m-p/2444708#M547478 Former Member 2007-06-21T20:48:41Z Re: ALV output problem. https://community.sap.com/t5/application-development-and-automation-discussions/alv-output-problem/m-p/2444709#M547479 <HTML><HEAD></HEAD><BODY><P>Hi Rajasekhar,</P><P></P><P>Check this code.</P><P></P><PRE><CODE>*&---------------------------------------------------------------------* *& Report ZTEST100 *& *&---------------------------------------------------------------------* *& *& *&---------------------------------------------------------------------* REPORT ZTEST100. type-pools:slis. types:begin of s_sflight, carrid like sflight-carrid, connid like sflight-connid, fldate like sflight-fldate, price like sflight-price , seatsmax like sflight-seatsmax, end of s_sflight. data:it_sflight type standard table of s_sflight. data:wa_sflight like it_sflight. data:t_fieldcat type slis_t_fieldcat_alv , WA_FIELDCAT TYPE SLIS_FIELDCAT_ALV, v_repid like sy-repid. select carrid connid fldate price seatsmax into table it_sflight from sflight. WA_fieldcat-fieldname = 'CARRID'. wa_fieldcat-reptext_ddic = 'Airline Code'. APPEND WA_FIELDCAT TO T_FIELDCAT. WA_fieldcat-fieldname = 'CONNID'. wa_fieldcat-reptext_ddic = 'Fl. Conn. NO.'. APPEND WA_FIELDCAT TO T_FIELDCAT. WA_fieldcat-fieldname = 'FLDATE'. wa_fieldcat-reptext_ddic = 'Flight date'. APPEND WA_FIELDCAT TO T_FIELDCAT. WA_fieldcat-fieldname = 'PRICE'. wa_fieldcat-reptext_ddic = 'Airfare'. APPEND WA_FIELDCAT TO T_FIELDCAT. WA_fieldcat-fieldname = 'SEATSMAX'. wa_fieldcat-reptext_ddic = 'Maximum capacity in economy class'. APPEND WA_FIELDCAT TO T_FIELDCAT. CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' EXPORTING * I_INTERFACE_CHECK = ' ' I_BYPASSING_BUFFER = 'X' I_BUFFER_ACTIVE = ' ' I_CALLBACK_PROGRAM = v_repid * I_CALLBACK_PF_STATUS_SET = ' ' * I_CALLBACK_USER_COMMAND = ' ' I_STRUCTURE_NAME = 'S_SFLIGHT' * IS_LAYOUT = IT_FIELDCAT = t_fieldcat * IT_EXCLUDING = * IT_SPECIAL_GROUPS = * IT_SORT = * IT_FILTER = * IS_SEL_HIDE = * I_DEFAULT = 'X' I_SAVE = 'A' * IS_VARIANT = * IT_EVENTS = * IT_EVENT_EXIT = * IS_PRINT = * IS_REPREP_ID = * I_SCREEN_START_COLUMN = 0 * I_SCREEN_START_LINE = 0 * I_SCREEN_END_COLUMN = 0 * I_SCREEN_END_LINE = 0 * IMPORTING * E_EXIT_CAUSED_BY_CALLER = * ES_EXIT_CAUSED_BY_USER = TABLES T_OUTTAB = IT_SFLIGHT * EXCEPTIONS * PROGRAM_ERROR = 1 * OTHERS = 2 . IF SY-SUBRC <> 0. * MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO * WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4. ENDIF.</CODE></PRE><P></P><P>Regards</P><P>Aneesh.</P></BODY></HTML> Thu, 21 Jun 2007 20:51:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-output-problem/m-p/2444709#M547479 Former Member 2007-06-21T20:51:41Z Re: ALV output problem. https://community.sap.com/t5/application-development-and-automation-discussions/alv-output-problem/m-p/2444710#M547480 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>**decalre tables.</P><P>TABLES: sflight.</P><P></P><P>type-pools:slis.</P><P></P><P>****structure declaration</P><P>types:begin of s_sflight,</P><P> carrid like sflight-carrid,</P><P> connid like sflight-connid,</P><P> fldate like sflight-fldate,</P><P> price like sflight-price ,</P><P> seatsmax like sflight-seatsmax,</P><P> end of s_sflight.</P><P></P><P>**internal table declarations</P><P></P><P>data: wa_sflight like it_sflight.</P><P>data: it_sflight type standard table of s_sflight.</P><P></P><P>****field catalog declaration</P><P>data: t_fieldcat type slis_t_fieldcat_alv , "field catalog body,</P><P> v_repid like sy-repid.</P><P></P><P></P><P>start-of-selection.</P><P></P><P>select carrid connid fldate price seatsmax</P><P>into table it_sflight from sflight.</P><P></P><P>if sy-subrc = 0. " or IF it_sflight IS NOT INITIAL.</P><P></P><UL><UL><UL><UL><LI level="4" type="ul"><P>function module for providing field catalog</P></LI></UL></UL></UL></UL><P></P><P>CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'</P><P> EXPORTING</P><P> I_PROGRAM_NAME = v_repid</P><P> I_INTERNAL_TABNAME = 'it_sflight'</P><P> I_STRUCTURE_NAME = 's_sflight'</P><P></P><P> I_INCLNAME = v_repid</P><P> I_BYPASSING_BUFFER = 'X'</P><P> I_BUFFER_ACTIVE = ' '</P><P> CHANGING</P><P> CT_FIELDCAT = t_fieldcat</P><P> EXCEPTIONS</P><P> INCONSISTENT_INTERFACE = 1</P><P> PROGRAM_ERROR = 2</P><P> OTHERS = 3</P><P>.</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><P></P><P>****function moddule for displayin data in alv report</P><P></P><P>CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'</P><P> EXPORTING</P><P> I_BYPASSING_BUFFER = 'X'</P><P> I_BUFFER_ACTIVE = ' '</P><P> I_CALLBACK_PROGRAM = v_repid</P><P></P><P> I_STRUCTURE_NAME = 's_sflight'</P><P></P><P> IT_FIELDCAT = t_fieldcat</P><P> I_SAVE = 'A'</P><P></P><P> TABLES</P><P> T_OUTTAB = it_sflight.</P><P></P><P>1) in your program you declared internal table, structure and field catalog in small letetrs but you are passing as capital letters. you must take care while passing structure to the parameter of <b>reuse_alv_fieldcatalog_merge</b> function module because it can create field catalog for the entaire report based on structure only.</P><P></P><P>2) better to declare tables which are used for data reading.</P><P></P><P>3) Before dispalying data once check IF it_sflight IS NOT INITIAL and call function modules with in this and end with ENDIF.</P><P></P><P>4) better to design selection-screen for user input, based on that you can read data.</P><P></P><P></P><P>regards,</P><P>Ashokreddy</P></BODY></HTML> Thu, 21 Jun 2007 21:41:05 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-output-problem/m-p/2444710#M547480 Former Member 2007-06-21T21:41:05Z