MC.9

[Former Member]

Hi Experts,

We can take Valuated Stock and value thru Tcode MC.9.

My points are

1. Is there any standard report available like MC.9 where we can get details , Dist. channel wise ?

2. Can we add Distrubution channel on selection Screen , so that we can have display/drill down Dist.channel , too..

3. IF point no.2 is not possible, I wud like to develop a report in ABAP. , here , I need tables where Stock value and Stock gets stored ,as per distribution channel wise. Which Tables I need to see f?

Please do help

[Former Member]

Stocks cannot be viewed by distribution channel.

Stocks can only be viewed by plant or/and storage location.

All standard invertory reports will give you both these options.

Suresh

[Former Member]

Ok

Can we develop something for this in ABAP...

if yes, How can we link the tables and from which tables we can get Stock and value ?

[Former Member]

Hi,

This report is build with LIS tables.

3 tables :

S039 for the result (no update rules)

S031 = alls movements (material document) --> Std table MSEG (structure LIS : MCMSEG)

S032 = Material Stocks --> std table MARD (structure LIS : MCBEST)

S039 is used to be link S031 with S032 to calculate historical stocks.

In ABAP report, you can used these tables.

It's simple to add distr channel if you are a good rule =

1 plant = 1 Sales org & 1 distr channel

Regards,

Lionel