Need work center & routing data

[former_member301924]

Hi Experts

I have need to extract data from r/3 system

Work center available capacity (Work center name, plant, calendar, available hours per day)

Routing (Material, plant, work center, operation, base unit, setup time and variable time)

i reach most things by using table but cant find available hr per day if i am not wrong it should be available capacity

have any solution

Thanks in advance

[former_member301924 · Accepted solution]

Thanks Experts

i have one more doubt regarding extract routing data.

I have only plant  Input

I want plant- work center- material-routing data combination in one stroke.

because data is to large so need some table.

Thanks

Piyush

[rupesh_brahmankar3 · Accepted solution]

Hello,

Check report CA51 or code CA85N - transaction for mass change of work center, but you can also use this as a report.

Best Regards,

R.Brahmankar

[RahulHanda]

Hi Piyush,

As already stated by expert R Brahmankar use CM01 or the BAPI, but keep in mind while defining this report that capacity in work center or group work centers (depending upon how are you using) would not be individually per material. This means if 5 materials have same work center as operation in their routing's then total would 40hrs per day (example, if 8hrs and 5 capacity maintained) only and it will not split as there is no such information per material (at least planned capacity).

Regards

Rahul

[rupesh_brahmankar3]

Hello,

Checkreport CM01 to get available capacity week wise or day wise

Input screen in the menu click on Settings-->general-->choose the radio button for day.

Else you can get the work center and capacity details through this BAPI

CR_CAPACITIES_OF_WORKCENTER.

Best Regards,

R.Brahmankar

[former_member301924]

Thanks for instant reply. your t code is working but i am little confused with capacity showing in std available capacity in capacity header data of work center.

can u tell me what is diff bet them because

cm01 capacity 95.56 hr

Capacity in work center 23.97 H

[RahulHanda]

Piyush

Check the bucket, you must be seeing in weekly bucket so it must be accumulating per week. For current week it will show for remaining number of days considering calendar maintained in capacity.

Regards

Rahul

[rupesh_brahmankar3]

Hello,

Do you have individual capacity more than one?  Do you have any shift sequence assigned to your workcenter?

If possible please share screen shot of workcenter capacity view and CM01.

Best Regards,

R.Brahmankar

[former_member301924]

[RahulHanda]

As I stated it's in weekly bucket.

So 24hrs * 999 (no. of individual capacities) * 7 (days in a week) = 167832 Hrs per week

For this week = 24 * 999 * 4 (no. of days left) = 95904 Hrs for this left week

Regards

Rahul

[rupesh_brahmankar3]

Hello,

In CM01 Input screen in the menu click on Settings-->general-->choose the radio button for day.

You will get the same results as per your work-center

Best Regards,

R.Brahmankar

[former_member301924]

Hi Rahul

Then what Hrs should I mentioned in list for ' Available Hrs per day'

Regards

Piyush

[rupesh_brahmankar3]

Hello,

You have defined 24 hrs as available every day. and number of individual capacity as 999

So you should maintain actual working hours per day and actual number of individual capacity.

Best Regards,

R.Brahmankar

[RahulHanda]

Hello

Since you are creating a report you can show operating hours 24, no. of individual capacities as 999 and finally total number of hours per day as 24*999. This should be visible in three different columns.

regards

Rahul