cancel
Showing results for 
Search instead for 
Did you mean: 

0HR_PT_2 Extractor Delta Load

Former Member
0 Kudos
122

We are extracting actual employee times from R/3 to BW using the SAP extractor 0HR_PT_2 in delta mode plus a user exit. It came to our attention a while back that changes made directly in CATS to the debited activity type or debited cost center (transaction CAT2) were not picked up in the delta load for this extractor.

We raised this in an OSS note with SAP, and they told us that we needed to do a config change in R/3 in order for changes to the debited act type or debited cost center to be considered for determination of delta records.

So far, we have been unsuccessful in implementing the right configuration. We have managed to get the changed data picked up via the delta load (which is a step ahead of where we were before), but when it is extracted to BW, it comes across twice: once with time type 9616 (loans and borrows), and once under the correct time type.

Has anyone implemented such a config change, and can you point us in the right direction?

Thanks for any help you can provide.

Rachel McGregor

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Rachel,

We were able to show SAP what the issue was with our time that was entered via CAT2 that wasn't getting picked up with delta. They issued note 890650. After this note was issued there were still some situations which did not update infotype 0439 so they gave me an additional code change:

I would like to ask you to make an additional change in the

coding of function module HR_PA_MODIFY_RETRO_INTERFACE.

Please insert the line marked with <<<<<:

lt_p0439 = i0439[]. "SERN890650

  • Über alle IT-Sätze loopen

LOOP AT IT_RECORD INTO WA_IT_RECORD.

i0439[] = lt_p0439[]. <<<<< insert this

CALL FUNCTION 'HR_TIM_GET_CHANGE_LOG_DATE'

EXPORTING

RECORD_BEFORE = WA_IT_RECORD

RECORD_AFTER = WA_IT_RECORD

TABLES

C_I0439 = I0439

EXCEPTIONS

  • DATE_UNDEFINED = 1

OTHERS = 2.

IF SY-SUBRC <> 0.

RAISE DATE_UNDEFINED.

ENDIF.

I tested this and it picked up type of changes in delta.

I don't believe this last piece of code is in the note yet.

After I made the code changes mentioned above, I had to reload our 0PT_C01 cube which meant reinitializing and I was able to successfully do this, however, I am currently receiving an error on our new delta infopackage where our old infopackage for delta worked successfully with the exception of the intermittent missing data.

Good luck

Ann Bohn