on 10-11-2005 5:37 AM
In my selection screen ...i wrote like this:
SELECTION-SCREEN : BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.
SELECT-OPTIONS : S_BEGDA FOR P2001-BEGDA,
S_ENDDA FOR P2001-ENDDA,
S_BTRTL FOR P0001-BTRTL.
SELECTION-SCREEN : END OF BLOCK B1.
Flow of the Report:-
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
Further Information:- The Incidence rate is the number of occurrences of injury/disease for each one hundred workers employed. The following formula should be applied:
Number of Occurrences in the period /Number of Workers * 100
The number of occurrences in the period refers to all cases of lost time injury/disease, which were recorded in the specific period. The number of workers is defined as the average number of workers who worked in the recording period. Persons who were absent from work on paid or unpaid leave for the entire period should be excluded from this calculation.
CAN ANYONE PLEASE SEND ME THE CODE?
YOUR HELP IS DEFINITELY REWARDED BY POINTS
SELECTION-SCREEN : BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.
SELECT-OPTIONS : S_BEGDA FOR P2001-BEGDA,
S_ENDDA FOR P2001-ENDDA,
S_BTRTL FOR PA0001-BTRTL.
SELECTION-SCREEN : END OF BLOCK B1.
START-OF-SELECTION.
perform get_data.
END-OF-SELCTION.
CALL SCREEN 100.
form get_data.
Select ABSTYP from zwsoabs into i_zwsoabs.
................
endform.
Similarly u can code the rest.
U r going to display as a report or ALV if ALV then refer this link
http://www.sapdevelopment.co.uk/reporting/alv/alvgrid.htm
http://www.sapdevelopment.co.uk/reporting/alv/alvlist_code.htm
Message was edited by: Judith Jessie Selvi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Hari,
Call Screen 100, means you are calling a screen with screen numbr 100. if you double click on that '100', it will take you to that screen, where you will have the PBO and PAI modules for that screen, You also can see the screen by clicking the Layout buton on the toolbar.
IF you famliar with module pool programming it will easy for you to use the call screen concept.
U r going to display as a report or ALV if ALV then refer this link
http://www.sapdevelopment.co.uk/reporting/alv/alvgrid.htm
http://www.sapdevelopment.co.uk/reporting/alv/alvlist_code.htm
If u r going to call a screen after pressing F8 in the selection screen then u have to use
<b>CALL Screen scrnno.</b>
Or else u can use simple write statements and display the output.
Example:
LOOP AT i_output.
write: / i_output-field1, ...
ENDLOOP.
Hope this helps.
>>what is this CALL SCREEN 100?
from the report you want to navigate to screen then the above statement is used
suppose user select the particulare emp number then you want to display the emp details in the separate screen then use CALL SCREEN 100 ( in that screen 100 we write flow logic )
cheers,
sasi
In my selection screen ...i wrote like this:
SELECTION-SCREEN : BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.
SELECT-OPTIONS : S_BEGDA FOR P2001-BEGDA,
S_ENDDA FOR P2001-ENDDA,
S_BTRTL FOR P0001-BTRTL.
SELECTION-SCREEN : END OF BLOCK B1.
PLEASE SEND THE CODE FOR THIS:-
Flow of the Report:-
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
Further Information:- The Incidence rate is the number of occurrences of injury/disease for each one hundred workers employed. The following formula should be applied:
Number of Occurrences in the period /Number of Workers * 100
The number of occurrences in the period refers to all cases of lost time injury/disease, which were recorded in the specific period. The number of workers is defined as the average number of workers who worked in the recording period. Persons who were absent from work on paid or unpaid leave for the entire period should be excluded from this calculation.
ZWSOABS contain only one field AWART(SAP FIELD).
CAN ANYONE PLEASE SEND ME THE CODE?
YOUR HELP IS DEFINITELY REWARDED BY POINTS
Hari Krishna;
Regards.
CALL SCREEN 100 is the way by which we can call the screen made for ALV Grid.
Siddarth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Can you tell me the column names of the table ZWSOABS.. you can run T code se11, and copy the column names, and wha they stands for, may be then i will b able to send you some code.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In my selection screen ...i wrote like this:
SELECTION-SCREEN : BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.
SELECT-OPTIONS : S_BEGDA FOR P2001-BEGDA,
S_ENDDA FOR P2001-ENDDA,
S_BTRTL FOR P0001-BTRTL.
SELECTION-SCREEN : END OF BLOCK B1.
Flow of the Report:-
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
Further Information:- The Incidence rate is the number of occurrences of injury/disease for each one hundred workers employed. The following formula should be applied:
Number of Occurrences in the period /Number of Workers * 100
The number of occurrences in the period refers to all cases of lost time injury/disease, which were recorded in the specific period. The number of workers is defined as the average number of workers who worked in the recording period. Persons who were absent from work on paid or unpaid leave for the entire period should be excluded from this calculation.
hi,
first define one internal table and find out the links between PA0001,P2001 and ZWSOABS.
for ex Pernr is the link for PA0001 and P2001
write a select query for retrive the data
select adddd ayyyy b~xxxx from Pa0001 as a
inner join p2001 as b on
apernr = bpernr
into table itab
where b~begda in s_enda.
then using the internal table process all your operations
cheers,
sasi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
104 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.