on 09-18-2014 7:04 AM
Hello expert,
I've tried provide statement and macro both work fine. Now i want to do a select statement using bedga and endda entered on screen.
"getting all employee personal number & normal hours employee only
SELECT pernr
FROM pa0007
INTO TABLE gt_007
WHERE begda <= p_begda AND endda > p_endda.
Is this the right way? Because here we are dealing with with period interval not just comparing date, please let me know if this is correct
Hi hassim,
Your code is correct if your are not using LDB, Just a little change for endda
SELECT pernr
FROM pa0007
INTO TABLE gt_007
WHERE begda <= p_begda AND endda >= p_endda.
cheers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Hassim,
Did you manage to resolve the issue? If so please post the code here so that others can also learn. Thank u.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
try with:
DATA: GT_007 LIKE PA0007 OCCURS 0 WITH HEADER LINE.
SELECT * FROM PA0007 INTO TABLE GT_007
WHERE ( PERNR = PERNR-PERNR AND BEGDA <= PN-BEGDA
AND ENDDA >= PN-ENDDA.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
102 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
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.