Check out our OnlineHelp for further information.

Data from SAP HCM tables PCL1 and PCL2 can only be extracted using the Xtract BAPI component. Data extraction via Xtract Table component is not supported.

First you need to create a remote enabled custom function module in SAP transaction SE37. Please see below.

This function module is then used in the Xtract BAPI component.

The function module requires the following Import Parameters:

PERNR            TYPE=PC2B0-PERNR;
ACTIONID         TYPE=CHAR2; DEFAULT = 'P1'
STARTDATE        TYPE=DATS;
ENDDATE          TYPE=DATS;

Next we need the following Table Parameters:

ERT        LIKE=PC2B8
ST         LIKE=PC2B5
CRT        LIKE=PC208

Below you can find the ABAP source code of the function module. Please copy and paste this code in the source code area of the function module.

 ```FUNCTION Z_HR_CLUSTER_READ.

 *"----------------------------------------------------------------------

 *"*"Local Interface:
 *"  IMPORTING
 "     VALUE(PERNR) TYPE  PC2B0-PERNR OPTIONAL
 *"     VALUE(ACTIONID) TYPE  CHAR2 DEFAULT 'P1'
 *"     VALUE(STARTDATE) TYPE  DATS OPTIONAL
 *"     VALUE(ENDDATE) TYPE  DATS OPTIONAL
 *"  TABLES
 *"      ERT STRUCTURE  PC2B8 OPTIONAL
 *"      ST STRUCTURE  PC2B5 OPTIONAL
 *"      CRT STRUCTURE  PC208 OPTIONAL
 *"----------------------------------------------------------------------
 DATA : BEGIN OF it_pcl1 OCCURS 0,
 srtfd TYPE pcl1-srtfd,
 END OF it_pcl1.

 DATA BEGIN OF b1_key.
      INCLUDE STRUCTURE pdc10.
 DATA END OF b1_key.

 IF actionid = 'P1'.

 SELECT srtfd
 FROM pcl1
 INTO TABLE it_pcl1
 WHERE relid EQ 'B1'
 AND srtfd EQ pernr
 AND srtf2 EQ 0.

LOOP AT it_pcl1.
  MOVE it_pcl1-srtfd TO b1_key.
  IMPORT st ert FROM DATABASE pcl1(b1) ID b1_key.
  IF sy-subrc EQ 0.
  ENDIF.
ENDLOOP.

 ENDIF.

 IF actionid = 'P2'.
 DATA : it_rgdir TYPE TABLE OF pc261 INITIAL SIZE 0,
       wa_rgdir LIKE LINE OF it_rgdir,
       it_crt TYPE pay99_result-inter-crt,
       wa_crt LIKE LINE OF it_crt,
       wa_payrollresult TYPE pay99_result,
       v_molga TYPE molga.

DATA : BEGIN OF wa_out,
        pernr TYPE pernr-pernr,
        gross TYPE pc207-betrg, "Amount
        net TYPE pc207-betrg,
       END OF wa_out,
       it_outtab LIKE TABLE OF wa_out.

 wa_out-pernr = PERNR.
 CALL FUNCTION 'CU_READ_RGDIR'
 EXPORTING
 persnr          = PERNR
 IMPORTING
 molga           = v_molga
 TABLES
 in_rgdir        = it_rgdir
 EXCEPTIONS
 no_record_found = 1
 OTHERS          = 2.
 IF sy-subrc = 0.



LOOP AT it_rgdir INTO wa_rgdir
                   WHERE fpbeg GE startdate AND
                         fpend LE enddate AND
                         srtza EQ 'A'.  "Current result
    CALL FUNCTION 'PYXX_READ_PAYROLL_RESULT'
      EXPORTING
        clusterid                    = 'RD'
        employeenumber               = PERNR
        sequencenumber               = wa_rgdir-seqnr
        READ_ONLY_INTERNATIONAL      = 'X'
      CHANGING

        payroll_result               = wa_payrollresult
      EXCEPTIONS
        illegal_isocode_or_clusterid = 1
        error_generating_import      = 2
        import_mismatch_error        = 3
        subpool_dir_full             = 4
        no_read_authority            = 5
        no_record_found              = 6
        versions_do_not_match        = 7
        error_reading_archive        = 8
        error_reading_relid          = 9
        OTHERS                       = 10.

    IF sy-subrc = 0.
      LOOP AT wa_payrollresult-inter-crt INTO wa_crt.
        CASE wa_crt-lgart.
          WHEN '/101'.  " Gross
            APPEND wa_crt TO crt.
        ENDCASE.
        CLEAR wa_out.
      ENDLOOP.
    ENDIF.
  ENDLOOP.
ENDIF.   ENDIF. ENDFUNCTION. ```

• If you populate Import Parameter “ACTIONID” with value P1, then you also need to populate field PERNR with a value for Personnel Number. No additional parameters are needed. You get the result in the table parameter ST.
• If you need the payroll results of cluster table PCL2, you need to populate Import Parameter “ACTIONID” with value P2 and have to fill in a start date and end date for parameters STARTDATE and ENDDATE. You get the result in the table parameter CRT.

This is a sample for our Product Xtract IS:

Please note: The personnel number has to be entered with leading zeroes. The date fields have the format yyyymmdd.