0ca_ts_is_1 filters records of attendance/absense type = ABS

[former_member532683]

Hi,

We are using standard extractor 0ca_ts_is_1 to load approved timesheet data. There was a business requirement in which users wanted to see attendance/absense type in the report. This field is available in CATSDB and we extracted in BW using CMOD code.There is a simple select statement based on CATS document number which gets this field in the extractor.

But we see that standard extractor itself filters out records of attendance/absense type = ABS.

Is there a already available solution on it?

Shital

[Former Member]

Hi,

In SDN forum blogs I found you have already worked on SAP BI u2013 CATS requirement.

In my project, I have requirement to design SAP- BI dataflow and Time utilization report based on the data of the CATS (Cross-Application Time Sheet) module timesheet records.

Could you please share me below requested details?

1. In my project I have requirement to generate Time utilization report

2. In your project requirement, which are fields you have enhanced data source 0CA_TS_IS_1 apart from AWART field (Attendance or Absence Type)?

3. In your BI model you have used data source 0CA_TS_IS_2? If yes please let me know in which scenarios we can use it?

4. You have any idea about Contracted hours and actual hours?

5. You have used any other standard BI content data sources OR created any custom data sources based on tables OR any other CATS report requirement. Please share me..

Please share your experience or any design you have worked on to implement SAP BI-CATS.

If you have any document on SAP BI-CATS, please send document to this mail id: amit.biw@gmail

It will be very helpful.

Warm Regards,

Amit

[Former Member]

Hi

I think you should have a look to the customization for Actual Employee Times OHR_PT_02 - defining time types.

http://wiki.sdn.sap.com/wiki/display/BI/BW-BCT-HCM

Mike