topic Re: ALV in Application Development and Automation Discussions

ALV

Former Member — Mon, 19 Nov 2007 08:32:11 GMT

Hi,

1. How to get top-of-page in ALV reports and how to upload logo in ALV reports.

2. what is diff ALV reports and list reports.

3. what are the function modules in ALV reports.

4. what is diff ALV grid report and ALV list report.

5. how to write alv interactive reports and send me coding also.

Thx,

Srinivas

Re: ALV

Former Member — Mon, 19 Nov 2007 08:34:59 GMT

Check out this link:

<u>http://www.erpgenie.com/sapgenie/docs/Using%20ALV.pdf</u>

Thanks

Vasudha

Re: ALV

Former Member — Mon, 19 Nov 2007 08:39:48 GMT

Simple ALV report

http://www.sapgenie.com/abap/controls/alvgrid.htm

http://wiki.ittoolbox.com/index.php/Code:Ultimate_ALV_table_toolbox

ALV

1. Please give me general info on ALV.

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

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

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

http://www.sapfans.com/forums/viewtopic.php?t=66305 - this one discusses which way should you use - ABAP Objects calls or simple function modules.

2. How do I program double click in ALV?

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

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

Check the program in the following link:

http://sap-img.com/abap/display-secondary-list-using-alv-grid.htm

3. How do I add subtotals (I have problem to add them)...

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

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

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

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

http://www.sapdevelopment.co.uk/reporting/alv/alvgrid_basic.htm

4. How to add list heading like top-of-page in ABAP lists?

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

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

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

5. How to print page number / total number of pages X/XX in ALV?

http://www.sapfans.com/forums/viewtopic.php?t=29597 (no direct solution)

6. ALV printing problems. The favourite is: The first page shows the number of records selected but I don't need this.

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

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

7. How can I set the cell color in ALV?

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/coloring%2ba%2brow%2band%2bcolumn%2bin%2balv%2b(OOPS)

8. 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

9. How do I create and use input-enabled fields in ALV?

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

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

10. How can I use ALV for reports that are going to be run in background?

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

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

11. How can I display an icon in ALV? (Common requirement is traffic light icon).

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

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

12. How can I display a checkbox in ALV?

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

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

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

13. Top-of-page in ALV

14. ALV Group Heading

http://www.sap-img.com/fu037.htm

How to add list heading like top-of-page in ABAP lists?

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

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

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

15. ALV output to PDF conversion

It has an example code for PDF Conversion.

http://www.erpgenie.com/abap/code/abap51.htm

Go thru these programs they may help u to try on some hands on

ALV Demo program

BCALV_DEMO_HTML

BCALV_FULLSCREEN_DEMO ALV Demo: Fullscreen Mode

BCALV_FULLSCREEN_DEMO_CLASSIC ALV demo: Fullscreen mode

BCALV_GRID_DEMO Simple ALV Control Call Demo Program

BCALV_TREE_DEMO Demo for ALV tree control

BCALV_TREE_SIMPLE_DEMO

BC_ALV_DEMO_HTML_D0100

Reward Points if this helps,

Re: ALV

former_member386202 — Mon, 19 Nov 2007 08:39:57 GMT

Hi,

Refer this code..

&----

*& Form sub_create_events *

&----

This form will display the ALV Events *

----

FORM sub_create_events .

*--Local Work Area

DATA: lwa_event TYPE slis_alv_event. "Work area for Events

*--Call Function to display the events for the ALV

CALL FUNCTION 'REUSE_ALV_EVENTS_GET'

EXPORTING

i_list_type = 1

IMPORTING

et_events = it_events.

*--Sort by Name

SORT it_events BY name.

*--Clear

CLEAR lwa_event.

READ TABLE it_events INTO lwa_event WITH KEY name =

slis_ev_top_of_page

BINARY SEARCH.

IF sy-subrc = 0.

MOVE c_top_of_page TO lwa_event-form.

MODIFY it_events FROM lwa_event TRANSPORTING form WHERE

name = slis_ev_top_of_page.

ENDIF.

*--Clear

CLEAR : lwa_event.

ENDFORM. "sub_create_events

&----

*& Form sub_top_of_page *

&----

This form is to build the Page Header *

----

FORM sub_top_of_page .

*--Local Variable

DATA : lv_title(120) TYPE c, " Title

lv_month(30) TYPE c,

lv_mont(30) TYPE c,

lv_bud(16) TYPE c.

*--Local Work Area

DATA : lwa_line TYPE slis_listheader. " Hold list header

CONCATENATE p_month 'to' s_hmonth INTO lv_month SEPARATED BY space.

IF NOT s_hmonth IS INITIAL.
lv_mont = lv_month.
ELSE.

lv_mont = p_month.

ENDIF.

*--Title Display

lwa_line-typ = 'H'. " header

lv_title = sy-title.

lwa_line-info = lv_title.

APPEND lwa_line TO it_header.

CLEAR lwa_line.

*--Month Display

lwa_line-typ = 'S'. " Item

WRITE: lv_mont TO lv_month.

lwa_line-key = text-024.

lwa_line-info = lv_month.

APPEND lwa_line TO it_header.

*--Budget Display

lwa_line-typ = 'S'. " Item

WRITE: p_bud TO lv_bud.

lwa_line-key = text-025.

lwa_line-info = lv_bud.

APPEND lwa_line TO it_header.

CLEAR: lwa_line,

lv_mont.

*--This funcation module will display the top of the page

CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'

EXPORTING

it_list_commentary = it_header

i_logo = 'SAPENJOY'.

*--Free

FREE : it_header.

ENDFORM. "sub_top_of_page

Regards,

Prashant

Re: ALV

Former Member — Mon, 19 Nov 2007 08:40:24 GMT

for top of page in ALV....

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

I_CALLBACK_PROGRAM = SY-REPID

I_CALLBACK_HTML_TOP_OF_PAGE = 'HTML_TOP_OF_PAGE'

IT_FIELDCAT = G_T_FIELDCAT[]

TABLES

T_OUTTAB = G_T_FINAL_REPORT[]

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.

FORM HTML_TOP_OF_PAGE USING DOCUMENT TYPE REF TO CL_DD_DOCUMENT.

DATA: TEXT TYPE SDYDO_TEXT_ELEMENT.

CALL METHOD DOCUMENT->ADD_GAP

EXPORTING

WIDTH = 500.

TEXT = TEXT-021.

CALL METHOD DOCUMENT->ADD_TEXT

EXPORTING

TEXT = TEXT

SAP_STYLE = TEXT-022.

CALL METHOD DOCUMENT->NEW_LINE.

TEXT = TEXT-023.

CALL METHOD DOCUMENT->ADD_TEXT

EXPORTING

TEXT = TEXT

SAP_EMPHASIS = TEXT-022.

CALL METHOD DOCUMENT->ADD_GAP

EXPORTING

WIDTH = 6.

TEXT = S_PERIOD-LOW.

CALL METHOD DOCUMENT->ADD_TEXT

EXPORTING

TEXT = TEXT

SAP_STYLE = TEXT-024.

CALL METHOD DOCUMENT->ADD_GAP

EXPORTING

WIDTH = 20.

TEXT = TEXT-025.

CALL METHOD DOCUMENT->ADD_TEXT

EXPORTING

TEXT = TEXT

SAP_EMPHASIS = TEXT-022.

CALL METHOD DOCUMENT->ADD_GAP

EXPORTING

WIDTH = 6.

TEXT = S_PERIOD-HIGH.

CALL METHOD DOCUMENT->ADD_TEXT

EXPORTING

TEXT = TEXT

SAP_STYLE = TEXT-024.

CALL METHOD DOCUMENT->NEW_LINE.

ENDFORM. "html_top_of_page

Re: ALV

Former Member — Thu, 17 Jan 2008 05:07:56 GMT

your answers are

1. you have to give top of page event in event catalog

and make its form for top of page. logo will be printed in list header.

2. alv reports are more formatted ones with more formatting options you can view list as well as grid.

3. function modules commonly used are

REUSE_ALV_LIST_DISPLAY

REUSE_ALV_GRID_DISPLAY

4. alv grid report is more like excel spreadsheet but list report is like classical reports.

5. to write alv interactive reports u need to know about field catalog and event catalog. so first study them then i will forward a code to you.gimme ur mail-id

reward if useful

KEEP ROCKIN,

vivek