topic Re: alv report in Application Development and Automation Discussions

alv report

Former Member — Tue, 01 May 2007 06:54:02 GMT

hi guru's,

In alv reports wat is the use of slis.wat slis is this.and wat is the use of it_field_catalog.with out field ctalog can we able to write alv report.pls give me indetail.

use full full points.

thanx

yogi

Re: alv report

Former Member — Tue, 01 May 2007 06:56:37 GMT

HI Yogi,

SLIS is a type group.., where all the declaractions required for the ALV list generation are stored !!

and about this FIELDCATALOg..

In the function module we have on parameter I_STRUCTURE .. this parameter accepts the dictionary structures !!

suppose if u are generating an ALV display for the SPFLI table's data . hope u want to print all the fields of the table .. then u can go for the option I_STRUCTURE and pass 'SPFLI' to this parameter !!

Now the list contains all the fields along with their column headings ,, and column widths .. taken from dictionary structure SPFLI..

But if u want to print Onli two fields CARRID and CONNID.. then u cannot use the I_STRUCTURE option.. now u need to go for the FIELDCATALOg..

Here u can prints onli those columns which u want.. u can customize ur ALV list output using this parameter !!

regards,

sai ramesh

Re: alv report

Former Member — Tue, 01 May 2007 06:57:48 GMT

Hi,

slis is a type pool,in type pools we can define variables and constants.

all the variables which are useful for alv reporting will be available in slis.

with out creating fieldcat alv reporting is not possible.

fieldcat gives the output structue.

but without using reuse_fieldcat_merge we can create a fieldcat manually.

check this code which has two ways of creating fieldcat.

REPORT ZBHALV_LIST_GRID2.

TABLES:MARA.

DATA:BEGIN OF ITAB OCCURS 0,

MATNR LIKE MARA-MATNR,

ERSDA LIKE MARA-ERSDA,

ERNAM LIKE MARA-ERNAM,

MBRSH LIKE MARA-MBRSH,

END OF ITAB.

TYPE-POOLS:SLIS.

DATA:AFIELD TYPE SLIS_FIELDCAT_ALV.

DATA:FIELDCAT1 TYPE SLIS_T_FIELDCAT_ALV.

DATA:FIELDCAT TYPE SLIS_T_FIELDCAT_ALV WITH HEADER LINE.

DATA:EVE TYPE SLIS_T_EVENT WITH HEADER LINE.

DATA:HEAD TYPE SLIS_T_LISTHEADER WITH HEADER LINE.

CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'

EXPORTING

I_PROGRAM_NAME = SY-REPID

I_INTERNAL_TABNAME = 'ITAB'

I_STRUCTURE_NAME = 'ITAB'
I_CLIENT_NEVER_DISPLAY = 'X'

I_INCLNAME = SY-REPID

I_BYPASSING_BUFFER =
I_BUFFER_ACTIVE =

CHANGING

CT_FIELDCAT = FIELDCAT1.

CLEAR AFIELD.

AFIELD-Col_pos = 1.

AFIELD-fieldname = 'MATNR'.

AFIELD-KEY = 'X'.

APPEND AFIELD TO FIELDCAT.

CLEAR FIELDCAT.

CLEAR AFIELD.

AFIELD-Col_pos = 2.

AFIELD-fieldname = 'ERSDA'.

AFIELD-KEY = 'X'.

APPEND AFIELD TO FIELDCAT.

CLEAR FIELDCAT.

CLEAR AFIELD.

AFIELD-Col_pos = 3.

AFIELD-fieldname = 'ERNAM'.

APPEND AFIELD TO FIELDCAT.

CLEAR FIELDCAT.

CLEAR AFIELD.

AFIELD-Col_pos = 4.

AFIELD-fieldname = 'MBRSH'.

APPEND AFIELD TO FIELDCAT.

CLEAR FIELDCAT.

EVE-NAME = 'TOP_OF_PAGE'.

EVE-FORM = 'HEADER'.

APPEND EVE.

CLEAR EVE.

EVE-NAME = 'END_OF_LIST'.

EVE-FORM = 'LISTEND'.

APPEND EVE.

CLEAR EVE.

EVE-NAME = 'TOP_OF_LIST'.

EVE-FORM = 'LISTTOP'.

APPEND EVE.

CLEAR EVE.

SELECT * FROM MARA INTO CORRESPONDING FIELDS OF TABLE ITAB UP TO 20 ROWS

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

I_CALLBACK_PROGRAM = SY-REPID

I_STRUCTURE_NAME = 'ITAB'

IT_FIELDCAT = FIELDCAT1

I_DEFAULT = 'X'

I_SAVE = 'A'

IT_EVENTS = EVE[]

TABLES

T_OUTTAB = ITAB.

CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'

EXPORTING

I_CALLBACK_PROGRAM = SY-REPID

I_STRUCTURE_NAME = 'ITAB'

IT_FIELDCAT = FIELDCAT[]

I_DEFAULT = 'X'

I_SAVE = 'A'

IT_EVENTS = EVE[]

TABLES

T_OUTTAB = ITAB.

FORM HEADER.

REFRESH HEAD.

HEAD-TYP = 'H'.

HEAD-INFO = 'GENERAL MATERIAL DATA'.

APPEND HEAD.

CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'

EXPORTING

IT_LIST_COMMENTARY = HEAD[].

ENDFORM.

FORM LISTEND.

REFRESH HEAD.

HEAD-TYP = 'H'.

HEAD-INFO = 'END OF THE LIST'.

APPEND HEAD.

CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'

EXPORTING

IT_LIST_COMMENTARY = HEAD[].

ENDFORM.

FORM LISTTOP.

REFRESH HEAD.

HEAD-TYP = 'H'.

HEAD-INFO = 'TOP OF THE LIST'.

APPEND HEAD.

CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'

EXPORTING

IT_LIST_COMMENTARY = HEAD[].

ENDFORM.

rgds,

bharat.

Re: alv report

sreeramkumar_madisetty — Tue, 01 May 2007 06:58:06 GMT

SLIS is a type group.., where all the declaractions required for the ALV list generation are stored !!

Type-groups: slis.

For better understandability go thru slis once.

Regards,

Sreeram

Re: alv report

Former Member — Tue, 01 May 2007 06:59:22 GMT

hi,

field catalog is used to specify the output display characteristics of the fields.

without field catalog also u can display alv but u have to specify the database table or structure.

Re: alv report

Former Member — Tue, 01 May 2007 07:00:33 GMT

Hi,

SLIS is a TYPE-POOLS, there we have all the global declarations, if you look at this from SE11, there press display, then you will find all the global declarations in this one.

The field catalog is defined in the Data Dictionary through table type LVC_T_FCAT . Each row of the field catalog table explains a field in your output table. Depending on whether a reference structure exists in the DDIC or not, you must at least fill the following fields of the field catalog structure for each field

FIELDNAME

REF_TABLE

REF_FIELD

Regards

Sudheer

Re: alv report

Former Member — Tue, 01 May 2007 07:00:37 GMT

hi ramesh,

tht's clear for me.but my doubt is that with out fieldcatalog can we able to write a alv report.if it's possible then wat is the use of field catalog.

thanx

yogi

Re: alv report

Former Member — Tue, 01 May 2007 07:01:53 GMT

HI,

All the definitions of internal tables, structures and Constants are declared in a type-pool called SLIS.

u can write an alv report even without field catlog but u need 2 pass the standard structure like spfli, mara to it_structure.

reward points if helpful.

regards,

kiran kumar k

Re: alv report

Former Member — Tue, 01 May 2007 07:01:56 GMT

Hi Yogi,

Check out these links : top one is on slis specifcally,

Reward if useful !!

Re: alv report

Former Member — Tue, 01 May 2007 07:02:24 GMT

Now the list contains all the fields along with their column headings ,, and column widths .. taken from dictionary structure SPFLI..

But if u want to print Onli two fields CARRID and CONNID.. then u cannot use the I_STRUCTURE option.. now u need to go for the FIELDCATALOg..

Here u can prints onli those columns which u want.. u can customize ur ALV list output using this parameter !!

You can color a particular column, you can give different column heading , you can make a particular column editable .., like so many options are there !!

GOTO the documentation of this parameter ( In SE37 transaction open the fm REUSE_ALV_GRID_DISPLA and in this goto the parameter IT_FIELDCATALOG's Documentation)

these many options are there for fieldcatalog paramter !!

wa_fieldcat-row_pos = 2.

wa_fieldcat-col_pos = 3.

wa_fieldcat-fieldname = 'FLTIME'.

wa_fieldcat-tabname =

wa_fieldcat-currency

wa_fieldcat-cfieldname

wa_fieldcat-ctabname

wa_fieldcat-ifieldname

wa_fieldcat-quantity

wa_fieldcat-qfieldname

wa_fieldcat-qtabname

wa_fieldcat-round

wa_fieldcat-exponent

wa_fieldcat-key = 'X'.

wa_fieldcat-key_sel = ' '.

wa_fieldcat-icon = 'X'.

wa_fieldcat-symbol

wa_fieldcat-checkbox

wa_fieldcat-just = 'C'.

wa_fieldcat-no_sign

wa_fieldcat-no_zero = 'X'.

wa_fieldcat-no_out = 'X'.

wa_fieldcat-no_convext =

wa_fieldcat-edit_mask =

wa_fieldcat-emphasize = 'C400'.

wa_fieldcat-fix_column = 'X'.

wa_fieldcat-do_sum = 'X'.

wa_fieldcat-no_sum = 'X'.

wa_fieldcat-hotspot = 'X'.

wa_fieldcat-tech =

wa_fieldcat-outputlen = 6.

wa_fieldcat-offset =

wa_fieldcat-seltext_l = 'Airline Carrierid'.

wa_fieldcat-seltext_m = 'Carrier ID'.

wa_fieldcat-seltext_s = 'Aircarrid'.

wa_fieldcat-ddictxt =

wa_fieldcat-rollname =

wa_fieldcat-datatype =

wa_fieldcat-inttype =

wa_fieldcat-intlen =

wa_fieldcat-lowercase = 'X'.

wa_fieldcat-ref_fieldname = 'CARRID'.

wa_fieldcat-ref_tabname = 'SPFLI'.

wa_fieldcat-roundfieldname =

wa_fieldcat-roundtabname =

wa_fieldcat-decimalsfieldname =

wa_fieldcat-decimalstabname =

wa_fieldcat-decimals_out =

wa_fieldcat-text_fieldname =

wa_fieldcat-reptext_ddic = 'SPFLI DATA'.

wa_fieldcat-ddic_outputlen = 8.

regards,

sai ramesh

Re: alv report

Former Member — Tue, 01 May 2007 07:02:53 GMT

hi sudheer,

tht's clear for me.but my doubt is that with out fieldcatalog can we able to write a alv report.if it's possible then wat is the use of field catalog.

thanx

yogi

Re: alv report

Former Member — Tue, 01 May 2007 07:04:05 GMT

Hi Eswar,

SLIS is the standard TYPE GROUP,where definitions are created for global use....

And field catalog is one of the interface parameter,Actually it is internal table.

To set attributes to the fields which are there on the screen.

Say for example: I want the first to be desplayed in RED color,second with some other...

not only this very option are there......see LVC_S_FCAT structure for more info.

Yes,we can do so.See this standard program BCALV_EDIT_02.

Here field catalog is not used in this standard program.

Just giving Structure itself is enough.

Reward all helpful answers

Regards,

V.Raghavender.

Re: alv report

Former Member — Tue, 01 May 2007 07:05:34 GMT

Your question is very right !!

There is no need of making a field catalog when u are using a standard table from the SAP ..

field catalog is to tell the system what you want to display .. u need it only when :

1. change the order of display of standard table fields or

2.mix tables with join or

3.define your own fields along with standard table fields, then u need to tell the system about it.

Message was edited by:

shweta soni

Re: alv report

Former Member — Tue, 01 May 2007 07:07:12 GMT

Hi Eswar,

Yes,we can do so.See this standard program BCALV_EDIT_02.

Here field catalog is not used

Reward all helpful answers.

Regards,

V.Raghavender