Skip to Content
0
Former Member
Aug 05, 2008 at 10:58 AM

provide endprovide

11 Views

hi all,

i just need to modify the select query by using provide and endprovide.

please tell me how can i change this statement from select to provide and endprovide.

SELECT sobid

FROM hrp1001

INTO lwa_hrp1001-sobid

WHERE otype = c_person AND

objid = pernr-pernr AND

rsign = c_topdown AND

relat = c_holder.

APPEND lwa_hrp1001 TO li_hrp1001.

CLEAR lwa_hrp1001.

ENDSELECT.

where CONSTANTS : c_person TYPE hrp1001-otype VALUE 'P',

c_position TYPE hrp1001-otype VALUE 'S',

c_topdown TYPE hrp1001-rsign VALUE 'B',

c_bottomup TYPE hrp1001-rsign VALUE 'A'