on 03-24-2006 2:22 PM
Hi
I need to collect values X associated with their ID and the value of DATETO out of the EMPLOYEE table. I am only interested in the values that lie between a specific timeperiod from y to z.
How can I do that? I have seen that there is a provide function but does it also work with dates?
Further I have read something like that an FM exists, anybody got an idea about where I can find it or how it was called?
Thanks a lot,
Greetings,
Nana
Hi,
if you want to read the employee data then you can use this FM <b>HR_READ_INFOTYPE</b> , infotype PA0001, pass begda and endda. and get the data.
CALL FUNCTION 'HR_READ_INFOTYPE'
EXPORTING
TCLAS = 'A'
PERNR = PERNR-PERNR
INFTY = '0001'
BEGDA = '18000101'
ENDDA = '99991231'
* BYPASS_BUFFER = ' '
* IMPORTING
* SUBRC =
TABLES
INFTY_TAB = INFTY_0000
EXCEPTIONS
INFTY_NOT_FOUND = 1
OTHERS = 2.
IF SY-SUBRC <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
* WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
Regards
Vijay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi nana,
1. simple
there is a standard fm for it.
2.
DATA : p0001 LIKE TABLE OF p0001 WITH HEADER LINE.
*----
Read Info Type 1
CALL FUNCTION 'HR_READ_INFOTYPE'
EXPORTING
tclas = 'A'
pernr = mypernr
infty = '0001'
begda = begda
endda = endda
BYPASS_BUFFER = ' '
LEGACY_MODE = ' '
IMPORTING
SUBRC =
TABLES
infty_tab = p0001
EXCEPTIONS
infty_not_found = 1
OTHERS = 2
3. just provide the start and enddate
in begda and endda respectively
regards,
amit m.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.