topic Re: Monthly wise data display in Application Development and Automation Discussions

Monthly wise data display

Former Member — Tue, 12 Jun 2007 09:43:12 GMT

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

____________________________________________________________________

Month 1 ************* Month 2******************|

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

Message was edited by:

jagadish emmadi

Re: Monthly wise data display

Former Member — Tue, 12 Jun 2007 09:52:29 GMT

hi jagadish,

this u can do by using dynamic internal tables.

reward points if useful,

regards,

seshu.

Re: Monthly wise data display

Former Member — Tue, 12 Jun 2007 09:52:51 GMT

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

Re: Monthly wise data display

Former Member — Tue, 12 Jun 2007 09:54:51 GMT

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

Re: Monthly wise data display

Former Member — Tue, 12 Jun 2007 09:55:12 GMT

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

Re: Monthly wise data display

Former Member — Tue, 12 Jun 2007 10:05:17 GMT

hai Peram ,

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

final_table Table Name

matnr,maktl,maktx,open_balace,qty_recived,Month_name.field names

Message was edited by:

jagadish emmadi