HR report from Cummulate results table
-----Original Message-----
Subject: HR report from Cummulate results table
A D V E R T I S E M E N T
Very new to HR-ABAP - need report desperately - I can see the totals I need
when I use the following path but don't know how to get at them for the report.
We are using 4.0 w/4.6 GUI frontend.
Path is: Human Resources->Payroll->key in 10->key in 10->Tools->Payroll
Results->Display--> Dbl click on a week-->select CRT-->dbl click on the name
Cummulated Results Table. All the totals I need for the report are there.
Report column headers are YTD totals for:
reg/hrs...O/T hrs...Prm/Hours...Total YTD/Hrs...Reg/Cost...O/T
Cost...Prm/Cost...Standby/Cost...Misc/Cost...Total YTD Cost
The total hrs & YTD total costs I can sum from the fields shown in this table. I
just can't figure out how to extract them from there or how they got there.
Can somebody please help - time is running out for me - I'm already at my
deadline. Everytime I try something- it's a dead end.
-----Reply Message-----
Subject: RE: HR report from Cummulate results table
A program has to be written to extract the CRT data based on the particular
employee and payroll period you are getting.
Try this.
TABLES: PERNR,
PCL2.
*----------------------------------------------------------------------*
* INCLUDE ZHR_PCL2_CU_DATA - Payroll results. *
*----------------------------------------------------------------------*
* Data declarations for the IMPORT of database PCL2 for cluster RU. *
*----------------------------------------------------------------------*
DATA: CD_NEXT_SEQ TYPE I, "Next available seq number
CD_LAST_PAY TYPE D. "Last payroll run date
DATA: BEGIN OF OCD_VERSION.
INCLUDE STRUCTURE PC201. "Technical Version
*DATA: molga LIKE t001p-molga. "country identifier
DATA: END OF OCD_VERSION.
DATA: BEGIN OF RGDIR OCCURS 100.
INCLUDE STRUCTURE PC261. "(For Export and Import of Payroll Res
DATA: END OF RGDIR.
* Key for database PCL2 cluster RU
DATA BEGIN OF RX_KEY.
INCLUDE STRUCTURE PC200. "Payroll Results Key
DATA: END OF RX_KEY.
* country dependent
DATA: BEGIN OF RU-VERSION.
INCLUDE STRUCTURE PC201. "Technical Version
DATA: END OF RU-VERSION.
DATA: BEGIN OF ORU_VERSION.
INCLUDE STRUCTURE PC201. "Technical Version
DATA: END OF ORU_VERSION.
* Cumulated-result table
DATA: BEGIN OF CRT OCCURS 30.
INCLUDE STRUCTURE PC22Y. "Cumulated result table (USA)
DATA: END OF CRT.
GET PERNR.
IMPORT CD_VERSION TO OCD_VERSION
CD_LAST_PAY
CD_NEXT_SEQ
RGDIR
FROM DATABASE PCL2(CU) ID PERNR-PERNR.
CHECK SY-SUBRC EQ 0.
* This is where you select the particular period you are searching for. The
* selection will change based on what dates you are looking for.
LOOP AT RGDIR WHERE FPPER EQ P_PERIOD
AND INPER EQ P_PERIOD
AND ( RUNDT GT Z_RUNDT
OR ( RUNDT EQ Z_RUNDT
AND RUNTM GT Z_RUNTI ) )
AND SRTZA = 'A'
AND PAYTY = ' '
AND VOID NE 'V'.
CHECK SY-SUBRC = 0.
MOVE PERNR-PERNR TO RX_KEY-PERNR.
MOVE RGDIR-SEQNR TO RX_KEY-SEQNO.
IMPORT RU-VERSION TO ORU-VERSION
CRT
FROM DATABASE PCL2(RU) ID RX_KEY.
CHECK SY_SUBRC = 0.
LOOP AT CRT.
Process crt data.
ENDLOOP.
ENDLOOP.
-----End of Reply Message-----
|
