MC44: material usage value affected by factory calendar

[Former Member]

Hi Gurus,

I've got the following problem: on my 4.6c R3 production instance factory calendar had been setup as 7 working days a week but recently the need was to change it to 5 working days a week due to the introduction of route calculation to determine correct dates for the sales orders.

We changed the factory calendar (which did deliver the correct result for the sales orders) only to discover that the "Usage" value determined for the materials by MC44 got totally wrong (usage with the 5 working days calendar was approximately 30 to 50% LESS than with the 7 days working calendar !!)

As soon as we did restore factory calendar back to 7 working days a week MC44 was again fine (obviously sales orders date got wrong...).

My impression is that everything is based on the way data from table MVER is determined depending on the factory calendar (which is apparently driven by function module DATE_CONVERT_TO_FACTORY_DATE).

I guess I could change from customizing the calendar for the shipping point: in that case my expectation is that sales orders date should be fine as well as results from MC44 but I'm not totally sure about that.

Any idea ? Do you know which is the way table MVER is populated based on the calendar settings ?

Many thanks in advance for your help.

Enrico

[Former Member]

Hi Jurgen,

many thanks for your reply.

Is there anybody with any additional hint/idea ?

Many thanks.

Enrico

[Former Member]

Hi Jurgen,

from the logical point of view sounds reasonable but....

1) even if I didn't fully debug the program (otherwise I guess I would know the answer ) looks like MVER is the only one considered in terms of usage

2) even if you forget point 1 (I could obviously be wrong) you're missing one information that I didn't mention: our usage (or consumption if you prefer) is 98% done from Monday to Friday; sometimes we do something on Saturday but this is kind of an exception.

Based on the above, despite the factory calendar is setup on 7 working days a week, our material usage is basically done on 5 working days a week. Described this way you'll immediately understand that, even if the program reads the data based on the number of working days, changing the calendar from 7 to 5 should cause a decrease of only 2-3%, in our case changing the factory calendar from 7 to 5 working days is causing a decrease of 30% to 50%.

I believe the program is reading the table in a different way based on the factory calendar, I'll try to give you an example:

Day Usage

01 Mon 10

02 Tue 20

03 Wed 30

04 Thu 40

05 Fri 50 ---> total week 1 far 150

06 Sat 2

07 Sun 0 -

---

> total of the weekend 2

08 Mon 100

09 Tue 200

10 Wed 300

11 Thu 400

12 Fri 500 -

---

> total week 2 1500

13 Sat 6

14 Sun 0 -

---

> total of the weekend 6

For the 2 weeks, factory calendar 7 working days a week, total usage would be 1658.

In your case, switching to 5 working days a week, it should deliver usage only for Monday to Friday, which is 1658 - (2+6)=1650 (i.e. difference is peanuts)

As I said, I couldn't get to the end of the debug, but my impression was that, switching to 5 working days a week (based on the above example) the program would read 10 "days" so from Monday 01 to Wednesday 10, in that case the total would be 1658 - (4005006) = 752 (now difference is huge...).

So...... maybe main question could be: which is the way MVER is populated ?

Best regards,

Enrico

[JL23]

A MVER record has fields to capture 12 periods.

this means in case of T consumption that you get one MVER record covers 12 days, on the 13th day a new MVER record with value 2 in field ZAHLR is created, followed by the next MVER record on day 25 with a 3 in field ZAHLR.

[Former Member]

Hi Jurgen,

Indicator is T = daily.

Many thanks.

Enrico

[JL23]

I doubt that SAP is capturing the data in MVER table wrong with a change of working days in a calendar.

But it might be that SAP does not read the MVER records in MC44 transaction that fall onto a non-workingday after the calendar change. (Just an assumption, I have not read the code)

So for the year of this calendar change you would need to set the flag "daily usage" which controls that SAP reads the material documents instead of the MVER records.

[JL23]

what period indicator do you have in your material master MRP view3 ?