cancel
Showing results for 
Search instead for 
Did you mean: 

Need Clarification on MCHB Table

Former Member
0 Kudos

Hi Experts,

I have an issue, I am using MCHB table to extract data for a material and plant combination for the posting period say 08.2010....

I am getting the output, but when I try for thr period 07.2010, it gives blank page.. as the Closiong stock of previous month should become openings stock for the current month... but the BW is able to give the data for previous month also (I mean 07.2010).. please suggest, whether is there any table where I need to find the history data.. or I am using the wrong table??

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

check whether MCE7 is helpful

Former Member
0 Kudos

Hi Guru,

Table MCHB contains only current month stock details at batch level.

If you need previous month stock levels, use history table MCHBH.

MCHB - Current month stock ( for current month 10)

MCHBH - Previous history stock. ( For previous month 9, 8, etc)

So, in your case please use MCHBH history table to get stock quantity information.

Regards

Ravi

former_member197616
Active Contributor
0 Kudos

Hi,

MCHB is the batch stock table. Yes you can use the table MDEWH which will give you the hostoty of the vcaluated stocks.

Regards

Former Member
0 Kudos

Hello

You are using wrong table. MCHB contain current stock. You need to use table MBEWH

Former Member
0 Kudos

Hi,

Can you try with tcode MC.5 whether it is helpful.

Regards,

MBKM