monthly wise sales report

[Former Member]

hai,

i m working on sales report where in i need to get month wise sales of the products and the related cost incured to company by the sales in the matrix form as shown below can u help me in which way can i get this monthly report

march april may june july......feb

mtrl 25 30 0 19 23 ........(mtrl quantity)

cost 30000 15000 0 45000 ..........(amt in rs)

where in the above i m able to get yearly sales in one column (i.e i m able to show for one particular customer total sales in one column) but i m unable to split sales monthly and unable to show in a report so how can i able to sow in this matrix form

[Former Member]

Hi,

Could please state your requirement in more detail way. I was unable to understand the exact way in which the report needs to be shown.

Regards,

Ashlesha

[Former Member]

can u give me ur mail adree i will send u the atttatchment of the requiremnt

[Former Member]

Hi,

TRY TCODE MCSI

Regards,

V.Balaji

Reward if Usefull...

[Former Member]

mcsi tcode is not working....

[Former Member]

either use dynamic internal table and alv OR

list printing with write statements.

Sameer

[Former Member]

Hi,

The following link will be used to build a dynamic internal table

http://scn.sap.com/docs/DOC-42525

[rajkumarnarasimman]

Dear Raj,

Please find the code for monthly wise report in PA0001 Table for calculation of Administrator time Recording.

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