Report requirement

[Former Member]

Hi

We have this requirement:

A report to compare incoming orders and billings (invoiced sales) on a month-to-date (MTD) basis. This report is based on companyu2019s sales organizational structure, in other words, by sales organization and distribution channel. Report should also contain information about sales employee, customer, and materials sold.

How to do this?

Thanks

[Former Member · Accepted solution]

This is brief summary as how to process your requirement. In case of any problems, post error messages.

In transaction MC21, create info structure with application as 1.

Click [Choose charact]

Scan the right side of the Selection list screen, looking for an appropriate field catalog that may have your desired characteristics. Double-click on that field catalog. Note that your selected field catalog is in the u2018Chosen field catalogu2019 field at the top of the screen.

Repeat with the next field and field catalog until all your

characteristics are selected.

When you are finished with your selection, click on [Copy + close].

Click again on [Copy].

Select the 'key figures' for your info structure in the same way as described above. For this, click [Choose key figures]in this case.

Generate your info structure.

Now go to Logistics / Sales/distribution / Sales Info System / Standard Analysis to check your report.

[Former Member · Accepted solution]

Hi

thanks for your replies.

require assistance as i am stuck. please provide detailed steps to choose characteristics & key figures.

thx

[former_member217082 · Accepted solution]

hi manik

T.code MC18 , select the field catalog and give the application as 01

T.code MC21 to create info structure

T.code MC24

T.code OMO1 to update the info structures

T.code OVRA Here the statistics group for customers is maintained

T.code OVRF Here the material statistics group is maintained

T.code OVRN Document statistics group is assigned to sales doc type

T.code OVRH assignment of sales doc type to item category

T.code OVRK Assignment of delivery doc type

T.code OVRP Assignment of sales area to cust statistics grp and material statistics grp

T.code OVRO Assignment of update grp to the update control and sales orgn and dist channel

After all settings are over , use t.code MCSI

Regards

Srinath

[Former Member · Accepted solution]

Go to transaction MC23 and analyze as to how info structure is designed for example S006 - sales employee.

In your case, report is based on sales organization and distribution channel & should also contain information about sales employee, customer, and materials sold.. So this would be characteristics.

Sales organization and Distribution channel are contained in field catalog SD: Sales organization (order). If you double click it you would get field catalog fields. select SO & DC.

Similarly select your other characteristics by this method by looking other field catalogs.

You want report to contain information on incoming orders and billings (invoiced sales) on a month-to-date (MTD) basis. This would be your 'key figures'

Search for required key figures in field catalogs. for example in field catalog SD: Additional key figures you have field 'incoming orders'.

Similarly select your other key figures and generate your info structure.

Hope this would clarify your doubt.

[former_member217082]

Hi manik rao

I hope these reports will help you to meet your requirement

Sales org analysis - MCTE

Sales org analysis-Invoiced sales - MC+2

Material Analysis-Incoming orders - MC(E

Sales Employee, Incoming Orders - MC(Q

Sales Employee Sales Volume - MC-Q

Regards

Srinath