Updating Consumption in Material Master Data (forecasting)

[Former Member]

Hello all,

I want to change the unplanned consumption values in the material master data for tab Forecasting. I found a Function module which could help me but it is not working for me. "MB_UPDATE_MATERIAL_CONSUMPTION"

Do you know other ways to change the unplanned consumption data of the forecasting in material master data ?

Best regards,

Yoolb

[Former Member]

You must enter a value in Period Ind. (BMMH1-PERKZ) so the system knows what to expect in the period field YYYYPPTT (PRIOD).  Without this, you will get error message M3126.

If PERKZ = M then PRIOD is 201201 --> 201212 (for the year 2012)

If PERKZ = W then PRIOD is 201201 --> 201252

If PERKZ = D then PRIOD is 20120101 --> 20121231

Hope this helps.

[Former Member]

Hope this problem is already solved.. Just for information

I was able to update the Forecast values using the fromat YYYYMM ( Program RMDATIND )

The additional field to be specified is BMMH1-PERKZ = 'M' (Month) in

<i>BMMH1 Material Master: Transfer of Main Data</i>

The load file format is :

MATNR	WERKS	PROPR	PRIOD	GSVBR
XXXXXXX	ABCD	XYZA	200706	3

Let me know if you need any further details..

Thanks,

Arun

[Former Member]

I had a very similar requirement to update the unplanned consumption in material master (MM02) Forecast view.

I started of with the FM : MB_UPDATE_MATERIAL_CONSUMPTION. It wasn't working for me.
And then onto FM:MATERIAL_ARRAY_UPDATE_RETAIL_2, looks like this FM is not documented well. After spending few hours, i gave up the puzzle.
Eventually it was FM: BAPI_MATERIAL_SAVEREPLICA  that helped me, achieve the requirement.

[former_member200473]

Hi Arun,

Thanks for valuable information.

Need one more suggestion

here we have structure  like

MATNR     WERKS     PROPR     PRIOD    (plnd consumption) (total consumption)  corrected consu

XXXXXXX     ABCD     XYZA     200706     3                                 4                                   5

can you please suggest how to handle this into recording or some other helpfull way to load the records.

Many thanks

Regards,

Shiva Sahu

[Former Member]

Hi, I know this was from a while back but there is a BAPI that can update the material forecast values.

BAPI_MATERIAL_SAVEREPLICA

You just need to use HEADDATA and FORECASTVALUES.

Not sure which release it was available from though.

Regards

Mark.

[Former Member]

Hi Yoolb,

Can you tell us how you are calling the FM and what is happening?

Regards,

Raj

[RichHeilman]

We actually use an LSMW routine to do this, interested?

Regards,

Rich Heilman

[Former Member]

I am trying to do it now with IDOC MATMAS03 via LSMW.

But I wonder why my FM is not working. When I debug everything is fine. Table MVER is filled correctly but the display of the consumption values in MM03 is not changed. Maybe the function is not good for updating the material master view.

Best regards and thx for the answers.

I will search further.

Yoolb

[former_member181962]

Hi Yoeri,

Its quite interesting.. MM03 picks the values from the same table and there is no other source to pick the data.

Did you try to make an Explicit commit on the LUW?

Try doing the commit work after the call to the Function module.

Regards,

Ravi

[Former Member]

That is what I did, because I call the FM in update task.

Now I am trying to do it via LSMW, but I have problems with the field PRIOD (YYYYPPTT). I don't understand what the pp and tt is standing for.

thx for reply, but I was that far already.

[RichHeilman]

I believe that it stands for your periods. Say for example, the forcasting is set up for 52 weeks. Then the periods would be like so.

1/2006

2/2006

3/2006

4/2006

5/2006

6/2006

7/2006

8/2006

9/2006

10/2006

11/2006

12/2006

13/2006

14/2006

15/2006

16/2006

All the way up to 52/2006

Regards,

Rich Heilman

[Former Member]

No, I always get the same error message.

Transaction 0000000001: the consumption period cannot be determined

Best regards,

Yoolb

[Former Member]

Please help me out here.

I am having the same error for 3 days now. I cannot find what the type YYYYPPTT means.

Thx,

Yoolb

[Former Member]

Hi Yoeri/Rich,

Can you please suggest the solution for this. We are facing the same error that Yoeri has faced and we need the forum's suggestions immediately. Please help us out.

Thanks,

Siva

[Former Member]

hello,

PERKZ must be filled in BMMH1 (with M "month" for example) in order to avoid the message, even if the field is already set in the material mastyer record. => check your source data, then the mapping rule for field PERKZ in your LSMW.

[meghanatha_shetty2]

Hi,

Our company has implemented IS retail. I am trying to load  the material historical consumption through LSMW( RMADATIND) into table MVER but not sure  whether  I am using  the correct tran code in field BMM00-TCODE . Itrried with tran code MM42 but getting  error "The activity category is not defined" Message No: MG036 .

We are able to update MVER table through LSMW using IDOC option but it has  performance issue. so we want to use the direct input through LSMW.

I really appreciate any help on this.

Thanks.

Megha

[former_member615637]

i'm interested ? 🙂

[RichHeilman]

LOL, this post is almost 15 years old. I don't even remember doing this routine. 🙂