Monthly wise data display

[Former Member]

i need logic for output format like below where the data are presented in only one internal table.this should go for the perod required

____________________________________________________________________

• <b>Month 1</b> ************* <b>Month 2</b>******************|

Material | MaterialDesc | M.Group | O/B | QTY Received ||O/B | qty Rec. |

-

---

Message was edited by:

jagadish emmadi

[Former Member]

Hi

Firstd eclare the internal table with the fields

matnr,MAKTX,matkl, ob1,qt1,ob2,qt2,ob3,qt3....upto ob12,qt12..

then fetch the date from the respective tables and based on the received date field segregate the qty into the corresponding month and fill the internal table and then display that data

Reward points for useful Answers

Regards

Anji

[Former Member]

hi jagadish,

this u can do by using dynamic internal tables.

reward points if useful,

regards,

seshu.

[Former Member]

Hi

Firstd eclare the internal table with the fields

matnr,MAKTX,matkl, ob1,qt1,ob2,qt2,ob3,qt3....upto ob12,qt12..

then fetch the date from the respective tables and based on the received date field segregate the qty into the corresponding month and fill the internal table and then display that data

Reward points for useful Answers

Regards

Anji

[Former Member]

Hi,

you have to maintian twelve fields

mon1 to mon12

then if the value is for frist month

then modify the internal table by inserting the record into mon1 field

in your case

maintain

O/B 1 QTY Received 1

O/B 2 QTY Received 2

......

O/B 12 QTY Received 12

then only you can able to maintain

reward points if helpful

regards,

venkatesh

[Former Member]

in this case u have to create dynamic Field cata log If u are using ALV.

sample code will be.

months data

01/2007

02/2007.

so while creating fieldcatalog.

loop at month.

fcat-field name = month-month.

append fcat.

endloop.

and u have to design ur final internal table in the same way.

Regards

Peram

[Former Member]

hai Peram ,

can u send me any sample code for me about the logic .

<b>final_table</b> Table Name

<b>matnr,maktl,maktx,open_balace,qty_recived,Month_name</b>.field names

Message was edited by:

jagadish emmadi