Does anyone see any issues with the following select statements?
I'm trying to retrieve All the current employee records for a specific company code in infotypes: 0000, 0001, 0002, 0006, 0009, 0017, 0105.
With best regards...
p_endda is 12/31/9999
sy-datum is current date
SELECT * FROM pa0001 INTO TABLE gt_0001
WHERE begda <= p_endda
AND endda >= sy-datum
AND bukrs = company_code.
SELECT * FROM pa0000 INTO TABLE gt_0000 FOR ALL ENTRIES IN gt_0001
WHERE pernr = gt_0001-pernr
AND begda <= p_endda
AND endda >= sy-datum.
SELECT * FROM pa0002 INTO TABLE gt_0002 FOR ALL ENTRIES IN gt_0001
WHERE pernr = gt_0001-pernr
AND begda <= p_endda
AND endda >= sy-datum.
SELECT * FROM pa0006 INTO TABLE gt_0006 FOR ALL ENTRIES IN gt_0001
WHERE pernr = gt_0001-pernr
AND begda <= p_endda
AND endda >= sy-datum.
SELECT * FROM pa0009 INTO TABLE gt_0009 FOR ALL ENTRIES IN gt_0001
WHERE pernr = gt_0001-pernr
AND begda <= p_endda
AND endda >= sy-datum.
SELECT * FROM pa0017 INTO TABLE gt_0017 FOR ALL ENTRIES IN gt_0001
WHERE pernr = gt_0001-pernr
AND begda <= p_endda
AND endda >= sy-datum.
SELECT * FROM pa0105 INTO TABLE gt_0105 FOR ALL ENTRIES IN gt_0001
WHERE pernr = gt_0001-pernr
AND begda <= p_endda
AND endda >= sy-datum.
Bluesky
