ALV grid display help

[Former Member]

Hi

I am displaying a Cost report which month and Fiscal yaer wise.If in the selection screen I enter the month 01 and Fiscal 2004, in the ALV grid display it'll show the records for that period.

Now if the user enters month 01 to 04 and for fiscal year 2004, in the ALV grid display I want the display to be monthwise.

like 01/2004

data1

data2

data3

data SUM

like 02/2004

data1

data2

data3

data SUM

like 03/2004

data1

data2

data3

data SUM

and so on.......

what would I need to do here. Is there any functionality I need to use in the ALV report.

The Fiscal is a Parameter and month is a SELECT-OPTION, and when I give month as 01,I retrieve the data between the 1/01/2004 and last day of the month 31/01/2004.

and if month is entered something like 01 and 03, the I take the data between 01/01/2004 and 31/03/2004, which I am taking care in the program. The only thing I need is the Monthly wise segmentation report in ALV grid display.

Many thanks in advance,

Regards,

Mira

[Former Member]

Hi

I am displaying a Cost report which month and Fiscal yaer wise.If in the selection screen I enter the month 01 and Fiscal 2004, in the ALV grid display it'll show the records for that period.

Now if the user enters month 01 to 04 and for fiscal year 2004, in the ALV grid display I want the display to be monthwise.

like 01/2004

data1

data2

data3

data SUM

like 02/2004

data1

data2

data3

data SUM

like 03/2004

data1

data2

data3

data SUM

and so on.......

what would I need to do here. Is there any functionality I need to use in the ALV report.

The Fiscal is a Parameter and month is a SELECT-OPTION, and when I give month as 01,I retrieve the data between the 1/01/2004 and last day of the month 31/01/2004.

and if month is entered something like 01 and 03, the I take the data between 01/01/2004 and 31/03/2004, which I am taking care in the program. The only thing I need is the Monthly wise segmentation report in ALV grid display.

Many thanks in advance,

Regards,

Mira

[Former Member]

Try using FM REUSE_ALV_HIERSEQ_LIST_DISPLAY if you want an ALV hierarchical report.

You can look at program BCALV_TEST_HIERSEQ_LIST as a sample.

[Former Member]

Hi Mira.

If you display in your ALV the columns Fiscal year and month than it should work if you use the Sum(Fiscal year) and Subtotals(month).

I don´t know if this easy solution is one you tried already. Let us know, if it doesn´t work.

Regards Michael.

[Former Member]

Refer this :

and this:

/people/subramanian.venkateswaran2/blog/2004/11/19/dynamic-internal-table

Regards,

Subramanian V.