Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Material details

Dear Friends,

My client has an requirement to see the list of material which is got invoiced for a month with distribution channel wise also he wants to see the qty and value

please help me on this

i have tried thru MCTC it was not working

Regards

Shakthi

replied

Dear,

There is standard report: MC+Q, as also replied by me in response to your earlier thread.

In this report, key-in:

1. Distribution Channel (Range: From and To)

and

2. Period (Range: From and To)

And F8.

This report lists out all the Materials, invoiced within period-range for all the Distribution Channels (as ranged), along with Billed Qty and Gross Sale.

If you need to include more inputs, just press F6.

Now, as you are saying that none of your Standard reports (MCTC, MC+Q etc...) are not fetching any data; Please check whether LIS-Update has been maintained or not.

To Check LIS-Update:

SPRO --> IMG --> Logistics-General --> Logistics Information System --> Logistics Datawarehouse --> Updating --> Updating Control --> Assign Update Group at Item Level

Entries must be maintained for the Combination:

A. Sales OrgDist.ChannlDivisionCustomer Statistic Group ()Material Statistic Group (1)Statistics group for sales document type (1)+Statistics group for the item category (1)

B. Sales OrgDist.ChannlDivisionCustomer Statistic Group ()Material Statistic Group (1)Statistics group for sales document type (2)+Statistics group for the item category (2)

Similarly for:

SPRO --> IMG --> Logistics-General --> Logistics Information System --> Logistics Datawarehouse --> Updating --> Updating Control --> Assign Update Group at Header Level

A. Sales OrgDist.ChannlDivisionCustomer Statistic Group ()+Statistics group for sales document type (1)

B. Sales OrgDist.ChannlDivisionCustomer Statistic Group ()+Statistics group for sales document type (2)

I am confident that you will get the desired result.

Best Regards,

Amit

Note: I have writen such a long response as the same is working at my end.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question