10-11-2005 4:41 PM
i created selection screen lik this:-
S_BEGDA FOR P2001-BEGDA,
S_ENDDA FOR P2001-ENDDA,
S_BTRTL FOR P0001-BTRTL.
ZWSOABS is a table having only one field " ABSTYP ".
<u><b>CAN ANYONE SEND THE CODE FOR THIS:-</b></u>
1. Get Date(P2001- BEGDA and P2001- ENDDA) using selection criteria from selection screen
2. Get Personnel sub area from the table PA0001
3. Number of Occurrence is the Total number of Absences, which were recorded, in the specific period.
4. Get all the Absences from the table ZWSOABS which were recorded in the specific period (P2001- BEGDA and P2001- ENDDA).
5. Number of Workers is the Average number of workers who worked in the recording period excluding those persons who were absent from work on paid/unpaid leave for the entire period.
6. Get the Number of Workers from PA0000 using the following:
- Select Count (*) from PA0000 where PA0000-ENDDA = 31/12/9999 and PA0000-STAT2 = 3
7. Perform the report
I WANT TO DISPLAY THIS FIELD (INCIDENT RATE) where
incident rate = Number of Occurrences in the period / Number of Workers * 100
<u><b>YOUR HELP IS APPRECIATED.</b></u>
10-11-2005 4:52 PM
10-11-2005 4:52 PM