ALV Report

[Former Member]

Hi All...

I am Creating ALV report to display list of Purchase orders and Purchase requisitions. The design of the report must be as:

The program should display the list of Purchase orders and Purchase requisitions created for specified materials. The output should be displayed in form of ALV grid. There should be separate ALV Grid for Purchase order and Purchase requisition list.The user should also have an option to save various ALV layouts and should be able to choose the ALV layout on the selection screen The user should be able to navigate to the relevant document form the ALV grid. (Use hyperlink).

Selection screen fields–

Material Number

Creation date (For both, PR and PO).

Output fields –

List one –

PO Number

PO Item number

Vendor

Date

Material Number

Material Quantity

List two –

PR Number

Material Number

Material Quantity

Release status

Date.

Reference

Tables: EKPO, EKKO, EBAN

Transactions: ME23N

HINT – Use class - CL_GUI_ALV_GRID

As i'm new to ALV reporting can anyone help me to develop the report.

[Former Member]

Hi All...

I am Creating ALV report to display list of Purchase orders and Purchase requisitions. The design of the report must be as:

The program should display the list of Purchase orders and Purchase requisitions created for specified materials. The output should be displayed in form of ALV grid. There should be separate ALV Grid for Purchase order and Purchase requisition list.The user should also have an option to save various ALV layouts and should be able to choose the ALV layout on the selection screen The user should be able to navigate to the relevant document form the ALV grid. (Use hyperlink).

Selection screen fields–

Material Number

Creation date (For both, PR and PO).

Output fields –

List one –

PO Number

PO Item number

Vendor

Date

Material Number

Material Quantity

List two –

PR Number

Material Number

Material Quantity

Release status

Date.

Reference

Tables: EKPO, EKKO, EBAN

Transactions: ME23N

HINT – Use class - CL_GUI_ALV_GRID

As i'm new to ALV reporting can anyone help me to develop the report.

[Former Member]

Check out in se38..

BCALV* then take f4 you will get examples.. i hope those will help you..

[Former Member]

hi santosh...

creating ur report seems quite easy........

the alv can be created in many forms .

1) alv using grid function modules.

2) alv using list function modules .

3) alv tree using objects

4) alv using grid objects

even this site wud b helpful also

<u><i><b>http://www.sapdevelopment.co.uk/reporting/alvhome.htm</b></i></u>

and u can hv <u><b>check box</b></u> creation for different forms of alv displays...

so tht u can choose any one option for displaying purchae order and purchase requistions...

[former_member199581]

You can use the simplest FM to show a table in ALV Grid, that is HR_IT_SHOW_ANY_TABLE_ON_ALV.

Please, note that this FM doesn't set column headers but only fieldnames (In fact, if you have field LIFNR, in the output table you will not see column "Vendor" but column "LIFNR").

However, if you work on at least WAS 6.40, you can use class CL_SALV_TABLE.

The simplest way to call an ALV grid using this class is this, for example:

data: gt_outtab type table of <DATABASE_TABLE>. "Put here your structure

data: gr_table type ref to cl_salv_table.

*... Select data

select * from <DATABASE_TABLE> into corresponding fields of table gt_outtab.

*... Create Instance

call method cl_salv_table=>factory

IMPORTING

R_SALV_TABLE = gr_table

changing

t_table = gt_outtab.

*... Display table

gr_table->display( ).

And it's done.

Please reward if useful.

Roby