How to Display.

57 Views

There are twelve fields ( for 12 months material consumption saved ) in MVER Table. I want to display Previous Three Months Consumption Based On In Put Date.How Can I write The Coading.

Ex-12-Months Material Consumption Saved In GSV01...GSV12 In MVER Table.I want If I input 01.10.2007. Then Consumption Of 09.2007, 08.2007,06.2007 Material Consumption Should Display In My Out Put Table.

If I input 01.06.2007. Then Consumption Of 05.2007, 04.2007,03.2007 Material Consumption Should Display In My Out Put Table.

*********now i have witing the coading As ***

CONSUMPTION VALUES**

SELECT SINGLE GSV01 GSV02 GSV03 GSV04 GSV05 GSV06 GSV07 GSV08 GSV09

GSV10 GSV11 GSV12

FROM MVER

INTO (IT_MVER-GSV01,IT_MVER-GSV02,IT_MVER-GSV03,IT_MVER-GSV04,

IT_MVER-GSV05,IT_MVER-GSV06,IT_MVER-GSV07,IT_MVER-GSV08, IT_MVER-GSV09,

IT_MVER-GSV10, IT_MVER-GSV11, IT_MVER-GSV12 )

WHERE MATNR = IT_MARC-MATNR AND

WERKS = P_WERKS AND

GJAHR = S_DATE-LOW+0(4).

****How Can I Display Here Plz Help Me Here...

APPEND IT_FINAL.(Final Internal Display Table)

***********what