Hi,

In Baan IVc2 (other IV versions too), there is a "Work Center Utilization by Week" session (tipcs6420m000) which prints Weekly breakdown of data for each workcenter and this is PRP generated data. This data is primarily read off the table tipcs610. (A different format data is present in tipcs611).

We've migrated to Baan Vc and are looking for similar Weekly breakdown by Workcenter. The data generated by EP is not segregating it by Weeks.. but instead does it by a "start date" and a "end date". This data is stored in cprrp200 table. Session is cprrp2400m000 (Print Planned Capacity Use).

I'm looking for cprrp200 data to be segregated in weekly buckets. Is there any such data present in weekly buckets ? (I do not want the data from tisfc011 table).
Has anyone customized data in such a format ?

(Its strange that Baan decided to remove such a good feature. If I have to segregate the data in weekly buckets myself, I'll more or less have to rewrite the EP code to calculate capacity, resources, calender days, availability etc etc).

All help is appreciated. Thanks

Little John

O Guru .. where art thou :)

Look at cprmp3501m000 - Resource Master Plan. This will show you demand and capacity by the periods you have set up for your planning scenarios.
This uses table cprmp101 Capacity Use by Period

Periods set up in cprpd4120m000. Set periods as weekly buckets for as far out as you need. I use weekly (7 days) out about 18 months and then switch to 4 week.

Can see the same information in a chart via cprmp3701m000. Personally I find I do better charting by taking data from cprmp1001 to Excel and do my charts there.

You do, of course, have the Work Center Utilization by Week - tisfc1402m000, but I find that not real useful in doing longer range planning since it only shows active work orders. That's why for my regular capacity analysis i use reports I generate using data from cprmp101. I also use multiple planning scenarios to allow for doing "what if's".

Hi jcorwine,
thnks for your reply.
The period you mentioned in the "rmp" table is not a what I'm looking for.
If the period is split across weeks, the actual breakup is not done according to the capacity/availability etc.
What I'm looking for, is a literal weekly breakdown of the cprrp200 data.

This does work for me. It might depend on how you have set up your periods and the rolling frequency of your planning scenario. have been doing this for over three years with weekly periods. You do have to play a little at the beginning with the reference date you set for a scenario and the rolling frequency. Then be sure to roll the scenario on a regular basis. I set up to roll the scenario along with the weekend full ERP run.