topic Re: field catlog in Application Development and Automation Discussions

topic Re: field catlog in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/field-catlog/m-p/1956530#M393635 <HTML><HEAD></HEAD><BODY><P>HEllo,</P><P></P><P>Check this sample program.</P><P></P><P><A href="https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/bd4330fe-0701-0010-03be-f64659b88dca" target="test_blank">https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/bd4330fe-0701-0010-03be-f64659b88dca</A></P><P></P><P>Please reward for helpful answers:</P><P></P><P>Vasanth</P></BODY></HTML> Fri, 02 Mar 2007 09:25:49 GMT Former Member 2007-03-02T09:25:49Z field catlog https://community.sap.com/t5/application-development-and-automation-discussions/field-catlog/m-p/1956529#M393634 <HTML><HEAD></HEAD><BODY><P>I want to know abt field catlog ?if it is there with example, it will be better......</P></BODY></HTML> Fri, 02 Mar 2007 09:23:39 GMT https://community.sap.com/t5/application-development-and-automation-discussions/field-catlog/m-p/1956529#M393634 Former Member 2007-03-02T09:23:39Z Re: field catlog https://community.sap.com/t5/application-development-and-automation-discussions/field-catlog/m-p/1956530#M393635 <HTML><HEAD></HEAD><BODY><P>HEllo,</P><P></P><P>Check this sample program.</P><P></P><P><A href="https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/bd4330fe-0701-0010-03be-f64659b88dca" target="test_blank">https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/bd4330fe-0701-0010-03be-f64659b88dca</A></P><P></P><P>Please reward for helpful answers:</P><P></P><P>Vasanth</P></BODY></HTML> Fri, 02 Mar 2007 09:25:49 GMT https://community.sap.com/t5/application-development-and-automation-discussions/field-catlog/m-p/1956530#M393635 Former Member 2007-03-02T09:25:49Z Re: field catlog https://community.sap.com/t5/application-development-and-automation-discussions/field-catlog/m-p/1956531#M393636 <HTML><HEAD></HEAD><BODY><P>Go to the function module 'REUSE_ALV_LIST_DISPLAY'.</P><P>In that read documentation abt the IT_fieldcat ( Import parameter) and try to execute the following code..</P><P></P><P></P><P>tables spfli.</P><P>type-pools: slis.</P><P></P><P>DATA W_FCODE TYPE SLIS_EXTAB-FCODE.</P><P>*</P><P>*data: t_spfli TYPE SPFLI OCCURS 0 WITH HEADER LINE.</P><P>*</P><P>*select * from spfli into table t_spfli.</P><P></P><P>data : t_excluding TYPE SLIS_T_EXTAB .</P><P>*</P><P>*W_fcode = '&ETA'.</P><P>*append w_fcode to t_excluding.</P><P>*W_fcode = '&OUP'.</P><P>*append w_fcode to t_excluding.</P><P>*W_fcode = '&ODN'.</P><P>*append w_fcode to t_excluding.</P><P>*W_fcode = '&ILT'.</P><P>*append w_fcode to t_excluding.</P><P>*W_fcode = '&LFO'.</P><P>*append w_fcode to t_excluding.</P><P></P><P>*call function 'REUSE_ALV_LIST_DISPLAY'</P><UL><LI level="1" type="ul"><P>EXPORTING</P></LI><LI level="1" type="ul"><P> I_STRUCTURE_NAME = 'SPFLI'</P></LI><UL><LI level="2" type="ul"><P> IS_LAYOUT =</P></LI><LI level="2" type="ul"><P> IT_FIELDCAT =</P></LI><LI level="2" type="ul"><P> IT_EXCLUDING = T_EXCLUDING</P></LI></UL><LI level="1" type="ul"><P> tables</P></LI><LI level="1" type="ul"><P> t_outtab = T_SPFLI</P></LI><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>*if sy-subrc <> 0.</P><UL><UL><LI level="2" type="ul"><P>MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO</P></LI><LI level="2" type="ul"><P> WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.</P></LI></UL></UL><P>*endif.</P><P>data : fs_col type SLIS_LAYOUT_ALV.</P><P></P><P>data:</P><P> begin of fs_work,</P><P> check type c,</P><P> col(4) type c,</P><P> light type c value '1',</P><P> carrid type spfli-carrid,</P><P> connid type spfli-connid,</P><P> fltime type spfli-fltime,</P><P> distance type spfli-distance,</P><P> cell type slis_t_specialcol_alv,</P><P> end of fs_work.</P><P>DATA FS_CELL like line of fs_work-CELL.</P><P>parameters :</P><P> p_row type i default 5,</P><P> p_cellr type i default 6,</P><P> p_cellc type i default 3.</P><P></P><P>field-symbols <fs>.</P><P>data:</P><P> t_table like standard table</P><P> of fs_work</P><P> initial size 0.</P><P>data :</P><P> t_fieldcat TYPE STANDARD TABLE OF SLIS_FIELDCAT_ALV,</P><P> wa_fieldcat type slis_fieldcat_alv.</P><P></P><P>AT SELECTION-SCREEN .</P><P> select carrid</P><P> connid</P><P> fltime</P><P> DISTANCE</P><P> from spfli</P><P> into corresponding fields of table t_table.</P><P></P><P> if p_row not between 1 and sy-dbcnt</P><P> or p_cellr not between 1 and sy-dbcnt.</P><P> message 'Specified Row doesnot exist in the table' type 'E'.</P><P> endif.</P><P></P><P>start-of-selection.</P><P></P><P>*wa_fieldcat-row_pos = 2.</P><P>wa_fieldcat-col_pos = 3.</P><P>wa_fieldcat-fieldname = 'FLTIME'.</P><P>*wa_fieldcat-tabname =</P><P>*wa_fieldcat-currency</P><P>*wa_fieldcat-cfieldname</P><P>*wa_fieldcat-ctabname</P><P>*wa_fieldcat-ifieldname</P><P>*wa_fieldcat-quantity</P><P>*wa_fieldcat-qfieldname</P><P>*wa_fieldcat-qtabname</P><P>*wa_fieldcat-round</P><P>*wa_fieldcat-exponent</P><P>*wa_fieldcat-key = 'X'.</P><P>*wa_fieldcat-key_sel = ' '.</P><P>*wa_fieldcat-icon = 'X'.</P><P>*wa_fieldcat-symbol</P><P>*wa_fieldcat-checkbox</P><P>wa_fieldcat-just = 'C'.</P><P>*wa_fieldcat-no_sign</P><P>*wa_fieldcat-no_zero = 'X'.</P><P>*wa_fieldcat-no_out = 'X'.</P><P>*wa_fieldcat-no_convext</P><P>*wa_fieldcat-edit_mask</P><P>*wa_fieldcat-emphasize = 'C400'.</P><P>*wa_fieldcat-fix_column = 'X'.</P><P>*wa_fieldcat-do_sum = 'X'.</P><P>*wa_fieldcat-no_sum = 'X'.</P><P>*wa_fieldcat-hotspot = 'X'.</P><P>*wa_fieldcat-tech</P><P>wa_fieldcat-outputlen = 6.</P><P>*wa_fieldcat-offset</P><P>wa_fieldcat-seltext_l = 'Airline Carrierid'.</P><P>wa_fieldcat-seltext_m = 'Carrier ID'.</P><P>wa_fieldcat-seltext_s = 'Aircarrid'.</P><P>*wa_fieldcat-ddictxt</P><P>*wa_fieldcat-rollname</P><P>*wa_fieldcat-datatype</P><P>*wa_fieldcat-inttype</P><P>*wa_fieldcat-intlen</P><P>*wa_fieldcat-lowercase = 'X'.</P><P>*wa_fieldcat-ref_fieldname = 'CARRID'.</P><P>wa_fieldcat-ref_tabname = 'SPFLI'.</P><P>*wa_fieldcat-roundfieldname</P><P>*wa_fieldcat-roundtabname</P><P>*wa_fieldcat-decimalsfieldname</P><P>*wa_fieldcat-decimalstabname</P><P>*wa_fieldcat-decimals_out</P><P>*wa_fieldcat-text_fieldname</P><P>*wa_fieldcat-reptext_ddic = 'SPFLI DATA'.</P><P>*wa_fieldcat-ddic_outputlen = 8.</P><P>append wa_fieldcat to t_fieldcat.</P><P>CLEAR WA_FIELDCAT.</P><P></P><P>*wa_fieldcat-row_pos = 2.</P><P>wa_fieldcat-col_pos = 4.</P><P>wa_fieldcat-fieldname = 'DISTANCE'.</P><P>wa_fieldcat-no_zero = 'X'.</P><P>*wa_fieldcat-outputlen = 6.</P><P>*wa_fieldcat-key = 'X'.</P><P>wa_fieldcat-emphasize = 'C700'.</P><P>*wa_fieldcat-symbol = 'X'.</P><P>*wa_fieldcat-input = 'X'.</P><P>*wa_fieldcat-no_out = 'X'.</P><P>*wa_fieldcat-tech = 'X'.</P><P>*wa_fieldcat-lowercase = 'X'.</P><P>*wa_fieldcat-do_sum = 'X'.</P><P>*wa_fieldcat-just = 'C'.</P><P>wa_fieldcat-ref_tabname = 'SPFLI'.</P><P>append wa_fieldcat to t_fieldcat.</P><P>CLEAR WA_FIELDCAT.</P><P></P><P>*wa_fieldcat-row_pos = 2.</P><P>wa_fieldcat-col_pos = 1.</P><P>wa_fieldcat-fieldname = 'CARRID'.</P><P>*wa_fieldcat-outputlen = 6.</P><P>*wa_fieldcat-emphasize = 'C700'.</P><P>*wa_fieldcat-hotspot = 'X'.</P><P>*wa_fieldcat-icon = 'X'.</P><P>*wa_fieldcat-col = 'C401'.</P><P>*wa_fieldcat-symbol = 'X'.</P><P>wa_fieldcat-key = 'X'.</P><P>*wa_fieldcat-fix_column = 'X'.</P><P>*wa_fieldcat-do_sum = 'X'.</P><P>*wa_fieldcat-lzero = 'X'.</P><P>*wa_fieldcat-input = 'X'.</P><P>*wa_fieldcat-just = 'R'.</P><P>wa_fieldcat-ref_tabname = 'SPFLI'.</P><P>append wa_fieldcat to t_fieldcat.</P><P>CLEAR WA_FIELDCAT.</P><P></P><P>*wa_fieldcat-row_pos = 2.</P><P>wa_fieldcat-col_pos = 2.</P><P>wa_fieldcat-fieldname = 'CONNID'.</P><P>wa_fieldcat-outputlen = 6.</P><P>wa_fieldcat-emphasize = 'C700'.</P><P>*wa_fieldcat-hotspot = 'X'.</P><P>*wa_fieldcat-icon = 'X'.</P><P>*wa_fieldcat-col = 'C401'.</P><P>*wa_fieldcat-symbol = 'X'.</P><P>*wa_fieldcat-key = 'X'.</P><P>*wa_fieldcat-fix_column = 'X'.</P><P>*wa_fieldcat-do_sum = 'X'.</P><P>*wa_fieldcat-lzero = 'X'.</P><P>*wa_fieldcat-input = 'X'.</P><P>wa_fieldcat-just = 'R'.</P><P>wa_fieldcat-ref_tabname = 'SPFLI'.</P><P>append wa_fieldcat to t_fieldcat.</P><P>CLEAR WA_FIELDCAT.</P><P></P><UL><LI level="1" type="ul"><P>Getting the column name for the cell to be colored...</P></LI></UL><P>loop at t_fieldcat into wa_fieldcat where col_pos eq p_cellc.</P><P> fs_cell-fieldname = wa_fieldcat-fieldname.</P><P> fs_cell-color-col = 5.</P><P> append fs_cell to fs_work-cell.</P><P>endloop.</P><P>if sy-subrc ne 0.</P><P> message 'Column position does not exist' type 'I'.</P><P>endif.</P><P>clear wa_fieldcat.</P><P></P><P>modify t_table index p_cellr from fs_work transporting cell.</P><P></P><UL><LI level="1" type="ul"><P>Assigning the layout options to the layout structure...</P></LI></UL><P>fs_work-col = 'C910'.</P><P>fs_col-info_fieldname = 'COL'.</P><P>fs_col-box_fieldname = 'CHECK'.</P><P>fs_col-coltab_fieldname = 'CELL'.</P><P>*fs_col-no_vline = 'X'.</P><P>*fs_col-lights_fieldname = 'LIGHT'.</P><P>*fs_col-no_totalline = 'X'.</P><P>*fs_col-no_subchoice = 'X'.</P><P>fs_col-numc_sum = 'X'.</P><P>fs_col-no_input = 'X'.</P><P>fs_col-f2code = '&OUP'.</P><P>FS_COL-key_hotspot = 'X'.</P><P></P><P>modify t_table index p_row from fs_work transporting col.</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><LI level="1" type="ul"><P> I_BYPASSING_BUFFER =</P></LI><LI level="1" type="ul"><P> I_BUFFER_ACTIVE = ' '</P></LI><LI level="1" type="ul"><P> I_CALLBACK_PROGRAM = ' '</P></LI><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><LI level="1" type="ul"><P> I_STRUCTURE_NAME =</P></LI></UL><P> IS_LAYOUT = fs_col</P><P> IT_FIELDCAT = T_FIELDCAT</P><UL><LI level="1" type="ul"><P> IT_EXCLUDING = t_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><LI level="1" type="ul"><P> I_SAVE = ' '</P></LI><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> IR_SALV_LIST_ADAPTER =</P></LI><LI level="1" type="ul"><P> IT_EXCEPT_QINFO =</P></LI><LI level="1" type="ul"><P> I_SUPPRESS_EMPTY_DATA = ABAP_FALSE</P></LI></UL><P> tables</P><P> t_outtab = t_table</P><P> EXCEPTIONS</P><P> PROGRAM_ERROR = 1</P><P> OTHERS = 2.</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></P></BODY></HTML> Fri, 02 Mar 2007 09:26:53 GMT https://community.sap.com/t5/application-development-and-automation-discussions/field-catlog/m-p/1956531#M393636 Former Member 2007-03-02T09:26:53Z Re: field catlog https://community.sap.com/t5/application-development-and-automation-discussions/field-catlog/m-p/1956532#M393637 <HTML><HEAD></HEAD><BODY><P>Field catalog is an internal table which describes how each column in an ALV report should look like. It tells what should be the output length of the column, what should be th eheading text for that field, should it be input enabled or not, etc.</P><P>For examples look at BC<STRONG>ALV</STRONG> programs in se38 transaction.</P><P>Regards,</P><P>Ravi</P></BODY></HTML> Fri, 02 Mar 2007 09:27:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/field-catlog/m-p/1956532#M393637 Former Member 2007-03-02T09:27:06Z Re: field catlog https://community.sap.com/t5/application-development-and-automation-discussions/field-catlog/m-p/1956533#M393638 <HTML><HEAD></HEAD><BODY><P>Hi Sasi,</P><P></P><P>the field catalog is used in ALVs to describe the structure of the fields to be displayed in the ALV along with the positions of the fields (column positions) and technical attributes (like description, data type and length) of every field.</P><P></P><P>if your ALV has the same structure as that of a data dictionary structure or even an internal table, u can construct the field catalog by calling the REUSE_ALV_FIELDCATALOG_MERGE function module to build it auto.</P><P></P><P>Have a look at programs with patter BCALV* for more help on this and a where used list on the above function module.</P><P></P><P>Regards,</P><P>Aditya</P></BODY></HTML> Fri, 02 Mar 2007 09:28:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/field-catlog/m-p/1956533#M393638 Former Member 2007-03-02T09:28:04Z Re: field catlog https://community.sap.com/t5/application-development-and-automation-discussions/field-catlog/m-p/1956534#M393639 <HTML><HEAD></HEAD><BODY><P>field catalog fills the header for the output of ALV. It helps us put the order of the coloumns that we want in our report. The below extract code caqn help u understand better. In case u want a full code do revert back.</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& Form fill_field_catalog</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P></P><P>FORM fill_field_catalog.</P><P></P><P> PERFORM build_catalog USING:</P><P></P><P></P><P> 'LAND1' 'TBL_FINAL' text-026 'C' '01',</P><P> 'DATE' 'TBL_FINAL' text-020 'C' '02',</P><P> 'TEXT' 'TBL_FINAL' text-021 'C' '03',</P><P> 'INDICATOR' 'TBL_FINAL' text-027 'C' '04',</P><P> 'WAERS' 'TBL_FINAL' text-022 'C' '05',</P><P> 'WRBTR' 'TBL_FINAL' text-023 'N' '06'.</P><P></P><P></P><P></P><P></P><P>ENDFORM. " fill_field_catalog</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& Form build_catalog</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P></P><P>FORM build_catalog USING p_fieldname</P><P> p_table</P><P> p_short</P><P> p_type</P><P> p_col.</P><P></P><P> st_alv_fieldcat-fieldname = p_fieldname.</P><P> st_alv_fieldcat-tabname = p_table.</P><P> st_alv_fieldcat-seltext_s = p_short.</P><P> st_alv_fieldcat-seltext_m = p_short.</P><P> st_alv_fieldcat-seltext_l = p_short.</P><P> st_alv_fieldcat-col_pos = p_col.</P><P></P><P> IF p_type EQ 'C'.</P><P> st_alv_fieldcat-key = 'X'.</P><P> ELSE. "move packed info to right</P><P> st_alv_fieldcat-just = 'R'."L-Left R- Right C-center</P><P> ENDIF.</P><P></P><P> st_alv_fieldcat-outputlen = '15'.</P><P></P><P> IF st_alv_fieldcat-fieldname EQ 'TEXT'.</P><P> st_alv_fieldcat-outputlen = '40'.</P><P> ENDIF.</P><P></P><P> APPEND st_alv_fieldcat TO w_alv_fieldcat.</P><P> CLEAR st_alv_fieldcat.</P><P></P><P>ENDFORM. " build_catalog</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& Form alv_grid_display</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P></P><P>FORM alv_grid_display.</P><P></P><UL><LI level="1" type="ul"><P>optimize width</P></LI></UL><P> st_alv_settings-no_colwopt = 'X'.</P><P></P><P> CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'</P><P> EXPORTING</P><P> i_callback_program = w_alv_repid</P><P> i_callback_top_of_page = w_alv_top_of_page "'TOP_OF_PAGE'</P><P> i_background_id = 'ALV_BACKGROUND'</P><P> i_grid_settings = st_alv_settings</P><P> is_layout = st_alv_layout</P><P> it_fieldcat = w_alv_fieldcat</P><P> it_sort = tbl_alv_sort</P><P> is_variant = st_alv_variant</P><P> it_events = w_alv_events</P><P> i_save = 'A'</P><P> TABLES</P><P> t_outtab = tbl_final</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><P></P><P>ENDFORM. " alv_grid_display</P><P></P><P>If found useful reward with points</P></BODY></HTML> Fri, 02 Mar 2007 09:28:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/field-catlog/m-p/1956534#M393639 Former Member 2007-03-02T09:28:06Z Re: field catlog https://community.sap.com/t5/application-development-and-automation-discussions/field-catlog/m-p/1956535#M393640 <HTML><HEAD></HEAD><BODY><P>Field catalog containing descriptions of the list output fields (usually a subset of the internal output table fields).</P><P></P><P>A field catalog is required for every ALV list output.</P><P></P><P>The field catalog for the output table is built-up in the caller's coding. The build-up can be completely or partially automated by calling the REUSE_ALV_FIELDCATALOG_MERGE module</P><P></P><P></P><P>Supports the creation of the field catalog for the ALV function modules based either on a structure or table defined in the ABAP Data Dictionary, or a program-internal table.</P></BODY></HTML> Fri, 02 Mar 2007 09:31:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/field-catlog/m-p/1956535#M393640 Former Member 2007-03-02T09:31:00Z Re: field catlog https://community.sap.com/t5/application-development-and-automation-discussions/field-catlog/m-p/1956536#M393641 <HTML><HEAD></HEAD><BODY><P>done</P></BODY></HTML> Fri, 26 Aug 2011 08:50:12 GMT https://community.sap.com/t5/application-development-and-automation-discussions/field-catlog/m-p/1956536#M393641 Former Member 2011-08-26T08:50:12Z