Copyright 2020 - BV TallVision IT

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)