topic Re: alv reports in Application Development and Automation Discussions

alv reports

Former Member — Wed, 13 Feb 2008 10:30:38 GMT

how to upload logo into alv reports?

Re: alv reports

Former Member — Wed, 13 Feb 2008 10:33:52 GMT

Hi,

use the FM ' REUSE_ALV_COMMENTARY_WRITE '.

Re: alv reports

Vijay — Wed, 13 Feb 2008 10:34:06 GMT

use this fm

call function 'REUSE_ALV_COMMENTARY_WRITE'

exporting

it_list_commentary = h_header

i_logo = 'logo name'.

regards

vijay

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Feb 13, 2008 5:50 PM

Re: alv reports

Former Member — Wed, 13 Feb 2008 10:37:17 GMT

use FM 'REUSE_ALV_COMMENTARY_WRITE'

call function 'REUSE_ALV_GRID_DISPLAY'
exporting
i_callback_program = gd_repid
i_callback_top_of_page = 'TOP-OF-PAGE'
i_grid_title = 'EMPLOYEE REPORTING'
is_layout = gd_layout
it_fieldcat = fieldcatalog[]

tables
t_outtab = it_ekko.


FORM top-of-page.

*ALV Header declarations
DATA: t_header TYPE slis_t_listheader,
wa_header TYPE slis_listheader,
t_line LIKE wa_header-info.



Title 
wa_header-typ = 'H'.
wa_header-info = 'Header type H : ASIKs Report'.
APPEND wa_header TO t_header.
CLEAR wa_header.

CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'
EXPORTING
it_list_commentary = t_header
I_LOGO = 'ENJOYSAP_LOGO'.

ENDFORM. "top-of-page

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Feb 13, 2008 5:50 PM

Re: alv reports

Former Member — Wed, 13 Feb 2008 10:37:31 GMT

Try this,

Build 'top_of_page' and call reuse_alv_commentry_write.

And Upload the logo in OAER.

the remaining body of the simple report, let it be same.

Hope it works...

Thanks.

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Feb 13, 2008 5:51 PM

Re: alv reports

Former Member — Wed, 13 Feb 2008 10:43:48 GMT

Hi..jayashankar..

Follow this navigation..

Use OAER Transaction :

navigation -> Goto OAER transaction

Class name - Pictures

class type - OT

Object key - Give any name ( Logo name ,this name you use in ALV top-of-page)

execute it -> second screen -> drag the standard doc types -> click on sceen -> give your logo file.

now you will get logo in ALV ..

You need to pass this logo name in REUSE_ALV_COMMENTORY_WRITE.

FORM top_of_page.

CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'

EXPORTING

it_list_commentary = it_listheadr[]

i_logo = 'ENJOYSAP_LOGO'. "From OAER transaction

ENDFORM. "TOP_OF_PAGE

Regards

sandeep.

Edited by: Sandeep Reddy on Feb 13, 2008 11:45 AM

Re: alv reports

Former Member — Wed, 13 Feb 2008 10:51:32 GMT

hi,

How do I print a logo/graphics in ALV?

http://www.sapfans.com/forums/viewtopic.php?t=81149

http://www.sapfans.com/forums/viewtopic.php?t=35498

http://www.sapfans.com/forums/viewtopic.php?t=5013

Hope this helps, <REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Feb 13, 2008 5:51 PM

Re: alv reports

Former Member — Wed, 13 Feb 2008 13:03:10 GMT

Hi, Just follwo the steps bellow and paste the code in SE38,then execute it.

THIS IS TO DISPLAY THE HEADER WITH LOGO.

Steps for uploading Logo :-:

1. Goto the transaction OAER

2. Enter the class name as 'PICTURES'

3. Enter the class type as 'OT'

4. Enter the object key as the name of the logo(e.g. tripodsm.gif) you wish to give

5. Execute

6. Then in the new screen select Standard doc. types in bottom window

Click on the Screen icon

Now, it will ask for the file path where you have to upload the logo

7. Now you can use this logo in REUSE_ALV_COMMENTARY_WRITE

call function 'REUSE_ALV_COMMENTARY_WRITE'

exporting

it_list_commentary = i_header

i_logo = 'tripodsm.gif'.

SE38 code

TABLES VBAK.

TYPE-POOLS SLIS.

Data Declaration

TYPES: BEGIN OF T_VBAK,

VBELN TYPE VBAK-VBELN,

ERDAT TYPE VBAK-ERDAT,

ERNAM TYPE VBAK-ERNAM,

AUDAT TYPE VBAK-AUDAT,

VBTYP TYPE VBAK-VBTYP,

NETWR TYPE VBAK-NETWR,

VKORG TYPE VBAK-VKORG,

VKGRP TYPE VBAK-VKGRP,

LINE_COLOR(4) TYPE C,

END OF T_VBAK.

DATA: IT_VBAK TYPE STANDARD TABLE OF T_VBAK INITIAL SIZE 0,

WA_VBAK TYPE T_VBAK.

ALV Data Declaration

DATA: FLDCAT TYPE SLIS_T_FIELDCAT_ALV WITH HEADER LINE,

GD_LAYOUT TYPE SLIS_LAYOUT_ALV,

GD_REPID TYPE SY-REPID.

START-OF-SELECTION.

PERFORM DATA_RETRIEVAL.

PERFORM BLD_FLDCAT.

PERFORM BLD_LAYOUT.

PERFORM DISPLAY_ALV_REPORT.

Build Field Catalog for ALV Report

FORM BLD_FLDCAT.

FLDCAT-FIELDNAME = 'VBELN'.

FLDCAT-SELTEXT_M = 'Sales Document'.

FLDCAT-COL_POS = 0.

*FLDCAT-EMPHASIZE = 'C411'.

FLDCAT-OUTPUTLEN = 20.

FLDCAT-KEY = 'X'.

APPEND FLDCAT TO FLDCAT.

CLEAR FLDCAT.

FLDCAT-FIELDNAME = 'ERDAT'.

FLDCAT-SELTEXT_L = 'Record Date created'.

FLDCAT-COL_POS = 1.

FLDCAT-KEY = 'X'.

APPEND FLDCAT TO FLDCAT.

CLEAR FLDCAT.

FLDCAT-FIELDNAME = 'ERNAM'.

FLDCAT-SELTEXT_L = 'Cteated Object Person Name'.

APPEND FLDCAT TO FLDCAT.

CLEAR FLDCAT.

FLDCAT-FIELDNAME = 'AUDAT'.

FLDCAT-SELTEXT_M = 'Document Date'.

FLDCAT-COL_POS = 3.

FLDCAT-EMPHASIZE = 'C110'.

APPEND FLDCAT TO FLDCAT.

CLEAR FLDCAT.

FLDCAT-FIELDNAME = 'VBTYP'.

FLDCAT-SELTEXT_L = 'SD Document category'.

FLDCAT-COL_POS = 4.

APPEND FLDCAT TO FLDCAT.

CLEAR FLDCAT.

FLDCAT-FIELDNAME = 'NETWR'.

FLDCAT-SELTEXT_L = 'Net Value of the SO in Document Currency'.

FLDCAT-COL_POS = 5.

FLDCAT-OUTPUTLEN = 60.

FLDCAT-DO_SUM = 'X'.

FLDCAT-DATATYPE = 'CURR'.

APPEND FLDCAT TO FLDCAT.

CLEAR FLDCAT.

FLDCAT-FIELDNAME = 'VKORG'.

FLDCAT-SELTEXT_L = 'Sales Organization'.

FLDCAT-COL_POS = 6.

APPEND FLDCAT TO FLDCAT.

CLEAR FLDCAT.

FLDCAT-FIELDNAME = 'VKGRP'.

FLDCAT-SELTEXT_M = 'Sales Group'.

FLDCAT-COL_POS = 7.

FLDCAT-EMPHASIZE = 'C801'.

APPEND FLDCAT TO FLDCAT.

CLEAR FLDCAT.

ENDFORM.

Build Layout for ALV Grid Report

FORM BLD_LAYOUT.

GD_LAYOUT-NO_INPUT = 'X'.

GD_LAYOUT-COLWIDTH_OPTIMIZE = 'X'.

GD_LAYOUT-INFO_FIELDNAME = 'LINE_COLOR'.

GD_LAYOUT-WINDOW_TITLEBAR = 'GRID DISPLAY'.

GD_LAYOUT-CONFIRMATION_PROMPT = 'X'. “ This asks the confirmation before leaving the screen.

ENDFORM.

Display report using ALV grid

FORM DISPLAY_ALV_REPORT.

GD_REPID = SY-REPID.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

I_CALLBACK_PROGRAM = GD_REPID

IS_LAYOUT = GD_LAYOUT

I_CALLBACK_TOP_OF_PAGE = 'TOP_OF_PAGE'

I_GRID_TITLE = 'SALES DOCUMENT HEADER'

IT_FIELDCAT = FLDCAT[]

I_SAVE = 'X'

TABLES

T_OUTTAB = IT_VBAK

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.

ENDFORM.

Retrieve data from VBAK table and populate itab IT_VBAK

FORM DATA_RETRIEVAL.

DATA LD_COLOR(1) TYPE C.

SELECT VBELN ERDAT ERNAM AUDAT VBTYP NETWR VKORG

UP TO 20 ROWS

FROM VBAK

INTO TABLE IT_VBAK.

LOOP AT IT_VBAK INTO WA_VBAK.

LD_COLOR = LD_COLOR + 1.

IF LD_COLOR = 8.

LD_COLOR = 1.

ENDIF.

CONCATENATE 'C' LD_COLOR '10' INTO WA_VBAK-LINE_COLOR.

MODIFY IT_VBAK FROM WA_VBAK.

ENDLOOP.

ENDFORM.

FORM TOP_OF_PAGE.

DATA: T_HEADER TYPE SLIS_T_LISTHEADER,

W_HEADER TYPE SLIS_LISTHEADER.

W_HEADER-TYP = 'H'.

W_HEADER-INFO = 'WELCOME HEADER LIST'.

APPEND W_HEADER TO T_HEADER.

W_HEADER-TYP = 'S'.

W_HEADER-KEY = 'REPORT:'.

W_HEADER-INFO = SY-REPID.

APPEND W_HEADER TO T_HEADER.

W_HEADER-TYP = 'S'.

W_HEADER-KEY = 'DATE:'.

CONCATENATE SY-DATUM6(2) ' / ' SY-DATUM4(2) ' / ' SY-DATUM(4) INTO W_HEADER-INFO.

APPEND W_HEADER TO T_HEADER.

CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'

EXPORTING

IT_LIST_COMMENTARY = T_HEADER

I_LOGO = ‘TRIPODSM.GIF’.

ENDFORM.

<REMOVED BY MODERATOR>

Thanks,

chandu.

Edited by: Alvaro Tejada Galindo on Feb 13, 2008 5:52 PM

Re: alv reports

Former Member — Wed, 13 Feb 2008 13:19:53 GMT

CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'

EXPORTING

it_list_commentary = it_listheadr[]

i_logo = 'ENJOYSAP_LOGO'. "From OAER transaction

I_END_OF_LIST_GRID = I_END_OF_LIST_GRID
I_ALV_FORM = I_ALV_FORM

Re: alv reports

Former Member — Sat, 05 Apr 2008 02:20:19 GMT

hi jaya shankar

we have a transaction code called 'OAER' in it we need to pass pictures, ot (others), objectname as zname

press f8

we get a bunch of list in bottom screen.

their u need to select picture

save it

later in alv report we have a fn module reuse_alv_commentry_write in this we need to pass object name which we have passed in the oaer.

this should be writtenn in the event called top-of-page .

For getting the top-of-page events we have another fn called reuse_alv_event_get.

if u have got the relavent answer reward me points

Re: alv reports

Former Member — Thu, 12 Feb 2009 10:35:17 GMT

This message was moderated.

Re: alv reports

Former Member — Thu, 12 Feb 2009 11:19:43 GMT

This message was moderated.

Re: alv reports

Former Member — Thu, 12 Feb 2009 11:25:22 GMT

This message was moderated.