HR is a module that has done things differently since day 1. Cluster data is no exception and when you are asked to bring it on, you may want to remember reading this article.
There's a good summary of this functionality on wiki.scn.sap on this. transaction PC00_M08_CLSTR is used to navigate to the payroll cluster or Display payroll results screen.
HR cluster data is an elaborate setup if Personnel data that with a strong date/time relation. Before you try anything else, try function module HR_FORMS_TIM_GET_B2_RESULTS (even as function module test in SE37). This is a function module that was designed to hand any potentially relevant cluster data to a Smartform for processing. Effectively it is a serious attempt to cover all there is to cover. Check it out to see whether the information you need is made available:
data: gw_TIM_B2 type HRF_TIM_B2.
CALL FUNCTION 'HR_FORMS_TIM_GET_B2_RESULTS'
EXPORTING
pernr = 1234 "<=Personnel number
begda = '20140101' "<= Startdate of selection
endda = '20141231' "<= Enddate of selection
* PERIODS =
IMPORTING
TIM_B2 = gw_TIM_B2
EXCEPTIONS
OTHERS = 4.
IF sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
* WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
The result parameter, gw_TIM_B2 (DDIC structure HRF_TIM_B2) holds an elaborate suite of information in a set of internal tables.
Standard report on the cluster data
You may find that the internal tables that are made available through the function module interface are quite meaningless - but this is in fact not entirely true. Use report RPCLSTB2 Show timeevaluation results (cluster B2) or transaction PT66 to report on the available results of a certain employee. The report shows table names, such as WPBP which is available in the function module output as FT_WPBP. Very handy !
Output summary
Just to get a glimpse of what is made available through this module (each line is in fact a table):
FT_DATERANGES |
Time Statement Periods | SELBEGDA, SELENDDA, EVALBEGDA, EVALENDDA, BEGIN_DATE, END_DATE |
FT_WPBP |
WPBP Time Statement Form | BEGDA, ENDDA, MASSN, MASSG, ... (37 fields) |
FT_PSP |
PSP Time Statement Form | DATUM, MOTPR, TPROG, TAGTY, ... (12 fields) |
FT_ZES |
ZES Time Statement Form | DATUM, ZTART (time type), ANZHL |
FT_SALDO |
SALDO Time Statement Form | BEGDA, ENDDA, ZTART, ANZHL |
FT_ZL |
ZL Time Statement Form | DATUM, BEGUZ, ENDUZ, ALZNR, C1ZNR, ABZNR, LGART, IFTYP, ANZHL, START_BEF_ZERO |
FT_ALP |
KNTAG for Time Statement Form | ALZNR, BEGDA, ENDDA, BEGUZ, ENDUZ (20 fields) |
FT_C1 |
C1 for Time Statement Form | C1ZNR, BUKRS, GSBER, KOKRS, KOSTL, ... (40 fields) |
FT_VS |
VS Time Statement Form | DATUM, VARIA, ANZHL, IDENT |
FT_CVS |
CVS for Time Statement Form | BEGDA, ENDDA, VARIA, ANZHL, IDENT |
FT_FEHLER |
FEHLER Time Statement Form - error messages | DATUM, LTIME, ERRTY, ERROR, MESTY, UTEXT, STATUS, AEDTM, UNAME, OPERNR, STDNZ |
FT_QTACC |
QTACC Time Statement Form | DATUM, QTYPE, ACCAC, ACCCU, TRANS, ... (22 fields) |
FT_QTTRANS |
QTTRANS Time Statement Form | GDATE, QTYPE, ACCOP, LVPER, ... (16 fields) |
FT_TP |
TP Time Statement Form | DATUM, BEGTM, ENDTM, ANZHL, PTYPE, SUBTY, ORIGS, TPZNR, START_BEF_ZERO |
FT_PT |
PT Time Statement Form | TPZNR, DATUM, BEGTM, ENDTM, BGCOD, EGCOD, ... (17 fields) |
FT_AB |
for AB Form | TPZNR, ABZNR, ENDDA, BEGDA, VTKEN, ... (22 fields) |
FT_ANWES |
ANWES for Form | TPZNR, ENDDA, BEGDA, BEGUZ, ENDUZ, ... (32 fields) |
FT_VERT |
VERT Time Statement Form | BEGDA, ENDDA, VTKEN, BEGUZ, ENDUZ, VTART, TPKLA, ... (27 fields) |
FT_RUFB |
RUFB Time Statement Form | TPZNR, BEGDA, ENDDA, ... (14 fields) |
FT_MEHR |
MEHR Time Statement Form | TPZNR, ENDDA, BEGDA, VTKEN, ... (23 fields) |
FT_ABWKONTI |
KNTAG for Time Statement Form | ENDDA, BEGDA, VTKEN, BEGUZ, ENDUZ, ... (18 fields) |
FT_ANWKONTI |
ANWKONTI for Time Statement Form | ENDDA, BEGDA, BEGUZ, ENDUZ, KTART, ... (12 fields) |
FT_SKO |
SKO Time Statement Form | BEGDA, ENDDA, ZTART, ANZHL, ATIME, OBJPS, SEQNR |
FT_KNTAG |
KNTAG for Time Statement Form | DATUM, FLAG |
FT_C_TYP_ABWKO |
Accrued Absence Quota Values for Time Statement | BEGDA, ENDDA, KTART, ENTITLE, ... (19 fields) |
FT_C_TYP_ANWKO |
Accrued Att. Quota Values for Time Statement | BEGDA, ENDDA, KTART, ENTITLE, ... (10 fields) |
FT_C_UNIT_ABWKO |
Unit of Accrued Abs.Quota Values: Time Statement | BEGDA, ENDDA, UNIT, ENTITLE, ... (18 fields) |
FT_C_UNIT_ANWKO |
Unit of Accrued Att.Quota Values: Time Statement | BEGDA, ENDDA, UNIT, ENTITLE, ... (9 fields) |
FT_D_ABWKO |
Absence Quotas Values for Key Date Time Statement | BEGDA, ENDDA, KTART, VALBEGIN, VALEND, ... (23 fields) |
FT_DNEVA |
DNEVA in Form | DNEVA |
FT_BEZUG |
BEZUG in Form | DATUM |
FT_D_ANWKO |
Att. Quotas Values for Key Date Time Statement | BEGDA, ENDDA, KTART, VALBEGIN, VALEND, ... (16 fields) |