How to create grid based on select options

[Former Member]

How can i create alv grid based on select options example username and date.

select options date: 01.01.2014 to 04.01.2014

username: username1 and username2

Grid should look something like this:

                    01.01.2014    02.01.2014  03.01.2014   04.01.2014

username1        5                 4.2

username2                            3                                    4

Numbers 5, 4.2,3,4   are the values of one column of given table.

Thanks in advance

Moderator Message: FAQ - Dynamic internal tables. Un-marking this discussion as a question. Please read the SCN rules of engagement

Message was edited by: Kesavadas Thekkillath

[Former Member]

How can i create alv grid based on select options example username and date.

select options date: 01.01.2014 to 04.01.2014

username: username1 and username2

Grid should look something like this:

                    01.01.2014    02.01.2014  03.01.2014   04.01.2014

username1        5                 4.2

username2                            3                                    4

Numbers 5, 4.2,3,4   are the values of one column of given table.

Thanks in advance

Moderator Message: FAQ - Dynamic internal tables. Un-marking this discussion as a question. Please read the SCN rules of engagement

Message was edited by: Kesavadas Thekkillath

[Former Member]

Hi,

The ALV Grid control is a flexible tool for displaying lists. The tool provides common list operations as

generic functions and can be enhanced by self-defined options.

The ALV Grid control is used to build non-hierarchical, interactive, and modern-design lists. As a

control, it is a component that is installed on the local PC.

Please refer this link

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e8a1d690-0201-0010-b7ad-d9719a415...

[Former Member]

Hi,

You will need to transpose your given table to a dynamic one that will hold 1 column for the username as a key and 1 column for each day in the given period....

What have you tried? where are you stucked?

Br,

Manu.

[tolga_polat]

Hi,

Create dynamic table for date.

CL_ALV_TABLE_CREATE=>CREATE_DYNAMIC_TABLE SCN has a lot of document about this method.

Then fill your table with data for username.

you need table like this :

user	date1	date2	date3	date4
username	1	3	2	5

this is very easy with CREATE_DYNAMIC_TABLE

then you can assign your data to created table.

here is the example:

http://scn.sap.com/message/14468651#14468651

You need to assign field by field.

Regards

Tolga