Logo in report

[Former Member]

Hi

How to print a logo in any program?? If possible give me sample code also plz

Helpfull points will be rewarded

Regards

Pavan

[Former Member]

Hello,

U can do that in ALV report.

In the transaction OAOR, you should be able to insert your company Logo.

GOTO - OAOR (Business Document Navigator)

Give Class Name - PICTURES Class Type - OT..... then Execute

It will show you the list, then select ENJOYSAP_LOGO.

On that list, you will find one control with a "create" tab.

Click std. doc types.

Select SCREEN and double-click.

It will push FILE selection screen.

Select your company logo (.gif) and press OK.

It will ask for a description- for instance: "company logo".

It will let you know your doc has been stored successfully.

You can find your logo under ENJOYSAP_LOGO->Screen->company logo.

Just run your ALV program, you should find your company logo in place of the EnjoySAP logo.

FORM TOP-OF-PAGE.

CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'

EXPORTING

IT_LIST_COMMENTARY = HEADING[]

I_LOGO = 'ENJOYSAP_LOGO'

I_END_OF_LIST_GRID ='GT_LIST_TOP_OF_PAGE'.

.

ENDFORM. "TOP-OF-PAGE

Here 'ENJOYSAP_LOGO' will replace by ur created logo.

n pls reply me.

Refer this link

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

http://www.sap-img.com/abap/alv-logo.htm

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

Regards,

Deepu.K

[Former Member]

But i dont want in ALv report as i want to use this logo for salary slip so i dont want to print it in ALV format so please if any more suggestions

Regards

Pavan

[Former Member]

Hi

Use the Tcode

<b>SMW0.</b>

See the links:

Reward points if useful

Regards

Anji

[Former Member]

Hi Pavan.

if u want to print a logo

In SCRIPTS through TCode SE78.and Imprt the logo into script editor.

In ALV reports, through TCode OAER and using the FM ' REUSE_ALV_COMMENTERY _WRITE'.

Reward with points if helpful.

Regards,

Naveen

[Former Member]

Hi naveen

I want my company logo to be printed in report output not in script or smartforms and also i dont want to use alv grid also can u say me any other idea

Regards

Pavan

[dev_parbutteea]

Hi,

try using

CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'

EXPORTING

I_LOGO = 'ENJOYSAP_LOGO'

IT_LIST_COMMENTARY = GT_LIST_TOP_OF_PAGE.

Regards,

Sooness

[Former Member]

Hi Pavan,

Execute OAER t-code and remainig steps follow as per above solution.

Regards,

Kuamr.

[Former Member]

Hi,

Here is a sample alv which includes a logo, just go through this:

&----

---

*& Report ZDEMO_ALVGRID *

*& *

&----

---

*& *

*& Example of a simple ALV Grid Report *

*& ................................... *

*& *

*& The basic requirement for this demo is to display a number of *

*& fields from the EKKO table. *

&----

---

REPORT zdemo_alvgrid .

TABLES: ekko.

type-pools: slis. "ALV Declarations

*Data Declaration

*----

---

TYPES: BEGIN OF t_ekko,

ebeln TYPE ekpo-ebeln,

ebelp TYPE ekpo-ebelp,

statu TYPE ekpo-statu,

aedat TYPE ekpo-aedat,

matnr TYPE ekpo-matnr,

menge TYPE ekpo-menge,

meins TYPE ekpo-meins,

netpr TYPE ekpo-netpr,

peinh TYPE ekpo-peinh,

END OF t_ekko.

DATA: it_ekko TYPE STANDARD TABLE OF t_ekko INITIAL SIZE 0,

wa_ekko TYPE t_ekko.

*ALV data declarations

data: fieldcatalog type slis_t_fieldcat_alv with header line,

gd_tab_group type slis_t_sp_group_alv,

gd_layout type slis_layout_alv,

gd_repid like sy-repid,

gt_events type slis_t_event,

gd_prntparams type slis_print_alv.

************************************************************************

*Start-of-selection.

START-OF-SELECTION.

perform data_retrieval.

perform build_fieldcatalog.

perform build_layout.

perform build_events.

perform build_print_params.

perform display_alv_report.

&----

---

*& Form BUILD_FIELDCATALOG

&----

---

• Build Fieldcatalog for ALV Report

----

---

form build_fieldcatalog.

• There are a number of ways to create a fieldcat.

• For the purpose of this example i will build the fieldcatalog manualy

• by populating the internal table fields individually and then

• appending the rows. This method can be the most time consuming but can

• also allow you more control of the final product.

• Beware though, you need to ensure that all fields required are

• populated. When using some of functionality available via ALV, such as

• total. You may need to provide more information than if you were

• simply displaying the result

• I.e. Field type may be required in-order for

• the 'TOTAL' function to work.

fieldcatalog-fieldname = 'EBELN'.

fieldcatalog-seltext_m = 'Purchase Order'.

fieldcatalog-col_pos = 0.

fieldcatalog-outputlen = 10.

fieldcatalog-emphasize = 'X'.

fieldcatalog-key = 'X'.

• fieldcatalog-do_sum = 'X'.

• fieldcatalog-no_zero = 'X'.

append fieldcatalog to fieldcatalog.

clear fieldcatalog.

fieldcatalog-fieldname = 'EBELP'.

fieldcatalog-seltext_m = 'PO Item'.

fieldcatalog-col_pos = 1.

append fieldcatalog to fieldcatalog.

clear fieldcatalog.

fieldcatalog-fieldname = 'STATU'.

fieldcatalog-seltext_m = 'Status'.

fieldcatalog-col_pos = 2.

append fieldcatalog to fieldcatalog.

clear fieldcatalog.

fieldcatalog-fieldname = 'AEDAT'.

fieldcatalog-seltext_m = 'Item change date'.

fieldcatalog-col_pos = 3.

append fieldcatalog to fieldcatalog.

clear fieldcatalog.

fieldcatalog-fieldname = 'MATNR'.

fieldcatalog-seltext_m = 'Material Number'.

fieldcatalog-col_pos = 4.

append fieldcatalog to fieldcatalog.

clear fieldcatalog.

fieldcatalog-fieldname = 'MENGE'.

fieldcatalog-seltext_m = 'PO quantity'.

fieldcatalog-col_pos = 5.

append fieldcatalog to fieldcatalog.

clear fieldcatalog.

fieldcatalog-fieldname = 'MEINS'.

fieldcatalog-seltext_m = 'Order Unit'.

fieldcatalog-col_pos = 6.

append fieldcatalog to fieldcatalog.

clear fieldcatalog.

fieldcatalog-fieldname = 'NETPR'.

fieldcatalog-seltext_m = 'Net Price'.

fieldcatalog-col_pos = 7.

fieldcatalog-outputlen = 15.

fieldcatalog-do_sum = 'X'.

fieldcatalog-datatype = 'CURR'.

append fieldcatalog to fieldcatalog.

clear fieldcatalog.

fieldcatalog-fieldname = 'PEINH'.

fieldcatalog-seltext_m = 'Price Unit'.

fieldcatalog-col_pos = 8.

append fieldcatalog to fieldcatalog.

clear fieldcatalog.

endform. " BUILD_FIELDCATALOG

&----

---

*& Form BUILD_LAYOUT

&----

---

• Build layout for ALV grid report

----

---

form build_layout.

gd_layout-no_input = 'X'.

gd_layout-colwidth_optimize = 'X'.

gd_layout-totals_text = 'Totals'(201).

• gd_layout-totals_only = 'X'.

• gd_layout-f2code = 'DISP'. "Sets fcode for when double

• "click(press f2)

• gd_layout-zebra = 'X'.

• gd_layout-group_change_edit = 'X'.

• gd_layout-header_text = 'helllllo'.

endform. " BUILD_LAYOUT

&----

---

*& Form DISPLAY_ALV_REPORT

&----

---

• 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

i_callback_top_of_page = 'TOP-OF-PAGE' "see FORM

i_callback_user_command = 'USER_COMMAND'

• i_grid_title = outtext

is_layout = gd_layout

it_fieldcat = fieldcatalog[]

• it_special_groups = gd_tabgroup

it_events = gt_events

is_print = gd_prntparams

i_save = 'X'

• is_variant = z_template

tables

t_outtab = it_ekko

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. " DISPLAY_ALV_REPORT

&----

---

*& Form DATA_RETRIEVAL

&----

---

• Retrieve data form EKPO table and populate itab it_ekko

----

---

form data_retrieval.

select ebeln ebelp statu aedat matnr menge meins netpr peinh

up to 10 rows

from ekpo

into table it_ekko.

endform. " DATA_RETRIEVAL

----

---

• Form TOP-OF-PAGE *

----

---

• ALV Report Header *

----

---

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,

ld_lines type i,

ld_linesc(10) type c.

• Title

wa_header-typ = 'H'.

wa_header-info = 'EKKO Table Report'.

append wa_header to t_header.

clear wa_header.

• Date

wa_header-typ = 'S'.

wa_header-key = 'Date: '.

CONCATENATE sy-datum+6(2) '.'

sy-datum+4(2) '.'

sy-datum(4) INTO wa_header-info. "todays date

append wa_header to t_header.

clear: wa_header.

• Total No. of Records Selected

describe table it_ekko lines ld_lines.

ld_linesc = ld_lines.

concatenate 'Total No. of Records Selected: ' ld_linesc

into t_line separated by space.

wa_header-typ = 'A'.

wa_header-info = t_line.

append wa_header to t_header.

clear: wa_header, t_line.

call function 'REUSE_ALV_COMMENTARY_WRITE'

exporting

it_list_commentary = t_header.

• i_logo = 'Z_LOGO'. "Here it inserts a logo.

endform.

----

---

• FORM USER_COMMAND *

----

---

• --> R_UCOMM *

• --> RS_SELFIELD *

----

---

FORM user_command USING r_ucomm LIKE sy-ucomm

rs_selfield TYPE slis_selfield.

• Check function code

CASE r_ucomm.

WHEN '&IC1'.

• Check field clicked on within ALVgrid report

IF rs_selfield-fieldname = 'EBELN'.

• Read data table, using index of row user clicked on

READ TABLE it_ekko INTO wa_ekko INDEX rs_selfield-tabindex.

• Set parameter ID for transaction screen field

SET PARAMETER ID 'BES' FIELD wa_ekko-ebeln.

• Sxecute transaction ME23N, and skip initial data entry screen

CALL TRANSACTION 'ME23N' AND SKIP FIRST SCREEN.

ENDIF.

ENDCASE.

ENDFORM.

&----

---

*& Form BUILD_EVENTS

&----

---

• Build events table

----

---

form build_events.

data: ls_event type slis_alv_event.

call function 'REUSE_ALV_EVENTS_GET'

exporting

i_list_type = 0

importing

et_events = gt_events[].

read table gt_events with key name = slis_ev_end_of_page

into ls_event.

if sy-subrc = 0.

move 'END_OF_PAGE' to ls_event-form.

append ls_event to gt_events.

endif.

read table gt_events with key name = slis_ev_end_of_list

into ls_event.

if sy-subrc = 0.

move 'END_OF_LIST' to ls_event-form.

append ls_event to gt_events.

endif.

endform. " BUILD_EVENTS

&----

---

*& Form BUILD_PRINT_PARAMS

&----

---

• Setup print parameters

----

---

form build_print_params.

gd_prntparams-reserve_lines = '3'. "Lines reserved for footer

gd_prntparams-no_coverpage = 'X'.

endform. " BUILD_PRINT_PARAMS

&----

---

*& Form END_OF_PAGE

&----

---

form END_OF_PAGE.

data: listwidth type i,

ld_pagepos(10) type c,

ld_page(10) type c.

write: sy-uline(50).

skip.

write:/40 'Page:', sy-pagno .

endform.

&----

---

*& Form END_OF_LIST

&----

---

form END_OF_LIST.

data: listwidth type i,

ld_pagepos(10) type c,

ld_page(10) type c.

skip.

write:/40 'Page:', sy-pagno .

endform.

Hope this info helps.

Regards,

Kumar.

[Former Member]

hi,

you can use ALV grid display in the report.

so that you can upload the logo in the report output.

thanks.

[former_member223537]

HI,

Refer program RSDEMO_CUSTOM_CONTROL.

Also, how @ a Smartform. Later on you can convert the Smartform spool into PDF & send as email.

Best regards,

Prashant

[Former Member]

Hi Pavan,

Try to use this code in your top of page.

data: gt_list_top_of_page type slis_t_listheader. " Top of page text.

Initialization.

perform comment_build using gt_list_top_of_page[].

form top_of_page.

• Note to self: the gif must be loaded into transaction OAOR with

• classname 'PICTURES' AND TYPE 'OT' to work with ALV GRID Functions.

• I Loaded NOVALOGO2 into system.

call function 'REUSE_ALV_COMMENTARY_WRITE'

exporting

• I_LOGO = 'NOVALOGO2'

• i_logo = 'ENJOYSAP_LOGO'

it_list_commentary = gt_list_top_of_page.

endform. " TOP_OF_PAGE

Reward points for helpful solutions.

Regards,

Harini

[Former Member]

Hi Pavan,

Logo is possible only in ALV or you need to use OLE in your report.

Regards,

Harini

[Former Member]

Hi Harini

what is this OLE where it will be used. and by using your code i havnt got any correct output so please can u send me another way or any modifications in ur coding only plz

Regards

pavan

[Former Member]

call function module

call function module reuse_alv_grid_display.

exporting.

programme = gd_repid.

top-of-page = 'TOP_OF_PAGE'.

importing .

t_outtab = itab_final.

exceptions.

form top_of_page.

wa_header-typ = 'H'.

wa_header-info = 'ALV Report'.

append wa_header to t_header.

clear wa_header.

wa_header-typ = 'S'.

wa_header-key = 'Date :'

concatenate Sy-datum+6(2) '.'

sy-datum+4(2) '.'

sy-datum(4) into wa_header-info.

append wa_header to t_header.

clear wa_header.

describe table itab_final lines line.

wa_header-typ ='A'.

linecount = line.

concatenate 'THe total no of records are:' linecount into wa_header-info seperated by space.

append wa_header to t_header.

clear wa_header.

endform.

reuse_alv_write_commentary.

header = t_header.

z_logo = 'MY SAP LOGO'.

reward with points if helpful.

[Former Member]

these are the various answers which i got at the time of arising the same question.

For uploading picture from desktop to SAP system, First goto SE78,

In that screen we have one option like BMAP Bitmap Image, So select that option

and give one name.After that In appln tool bar Import icon is there.you just click that and select any .bmp type picture from your desktop or from any drive

and click ok . and then save.Now your picture has been saved in SAP system.you can use this picture wherever you wan jus by using the picture name and type of that picture(.bmp)....

next method:

You can upload the picture using SE78.

You can also use Transaction 'OAER' to upload the picture.

For further understanding , you can refer the following links.

https://wiki.sdn.sap.com/wiki/display/KMC/CreatingContentinKnowledgeManagementandUploading+Images

next method:

You Can Upload Logo,

SAP Script :

BMP File using SE78

Tif File using RSTXLDMC

For ALV :

User OAER Transaction ,

Pass Parameters Like

Class Name : pictures

Class type : OT

Object Key : ur choice ( I mean give any name )

hope its useful...

Reward if useful.

thanks and regards

vijay

[Former Member]

Hi vijay

thanks for ur reply if it is in the case of script we can use ur technique but i want to add logo in my report without using alv grid i think u have understood my issue

regards

pavan

[Former Member]

Any help plz

[Former Member]

these are the various answers which i got at the time of arising the same question.

For uploading picture from desktop to SAP system, First goto SE78,

In that screen we have one option like BMAP Bitmap Image, So select that option

and give one name.After that In appln tool bar Import icon is there.you just click that and select any .bmp type picture from your desktop or from any drive

and click ok . and then save.Now your picture has been saved in SAP system.you can use this picture wherever you wan jus by using the picture name and type of that picture(.bmp)....

next method:

You can upload the picture using SE78.

You can also use Transaction 'OAER' to upload the picture.

For further understanding , you can refer the following links.

https://wiki.sdn.sap.com/wiki/display/KMC/CreatingContentinKnowledgeManagementandUploading+Images

next method:

You Can Upload Logo,

SAP Script :

BMP File using SE78

Tif File using RSTXLDMC

For ALV :

User OAER Transaction ,

Pass Parameters Like

Class Name : pictures

Class type : OT

Object Key : ur choice ( I mean give any name )

hope its useful...

Reward if useful.

thanks and regards

vijay

[Former Member]

Hi pavan,

if i understand you right, you will print a logo like write etc. not as ALV or script etc.

I think it's not possible doing it in this way.

regards, Dieter

[Former Member]

Hi dieter

I want to upload my company logo in report as if in case of scripts or else i want to add any coding part so that i can get data from that coding part and as a result in the output logo should be printed

Regards

Pavan