0WFM_CAPACITY Extractor

[Former Member]

Hi gurus,

I have a requirement in which I need to get Resource's Date and Time Allocations from Resource Planning on CRM7. I've found the 0WFMxxx extractors but I wasn't able to make those datasources work. What would be the basic steps to work with those datasources?

I'd appreciate if you guys could shed a light on this.

Regards,

-LF

[pradeep_penmesta2 · Accepted solution]

Hi LF,

          If the Resource's Date and Time Allocations are available in the datasource you mentioned above then Activate the data source in CRM System using RSA5 T code,Once its activated then you can see the data source in RSA6,If the fields are not available then you need to enhance the datasource then Replicate the Data source in BW System.

Hope you got it?

Regards,

Pradeep P.

[Former Member · Accepted solution]

Hi Pradeep,

Thanks for your reply, but the datasource is already active. The problem is that when I execute it in RSA3, it returns several rows, but all of them are zeroed.

Also I have been trying to use 0WFM_WORKTIME and it also behaves oddly. A Full load filtered by Date returns one single row (one resource) with 0 duration. When I filter by Date AND several resources, it returns several rows with respective durations.

Another issue is that my requirement is to report the resources availabilities in date / time but using 0WFM extractors it returns duration in seconds (key figure), but what I need is begin time and end time.

Any idea of where I get Resource's availability in that format ?

Thanks.

Regards

-LF

[Former Member · Accepted solution]

I realized that 0WFM_WORKTIME has an issue: If you don't filter by Resource, it extracts only internal resources (RES_TYPE = 00), due to a flaw in the extractors design (same happens to 0WFM_CAPACITY and 0WFM_ASSIGNMENTS).

I'm not going to bother with opening a ticket in SAP because the datasources do not fulfill my requirements. I need more detail than Resource, Date and Capacity in Secs, so I'm going with a custom solution:

- ZWFM_AVAILABILITY - Extractor that returns the resources availability by using WFD_RES_GET_AVAIL FM for all resources by Date, Start Time, End Time, Time Period (returns Morning or Afternoon, a custom field) and Capacity in Secs.

- ZWFM_ASSIGNMENTS - Extractor that returns Assignment Time, Assignment Key, Resource Key, Demand Key, Start Time, End Time, Time Period and all fields from /SAPAPO/LRPASSIG table, so I have all demands assigned to resources at the level of detail I need (start time, end time, time period).

- ZWFM_AVAIL_DETAIL - Extrator that uses WFD_RES_GET_TIMESPEC_IR FM to get the Service Arrangement's availability (Resource, Time Alloc. Type, Recurrence, Start Time, End Time, etc).

I'm leaving those FM's here as reference.

Regards,

-LF