Wednesday, October 28, 2009

HR:table HRP1001 deletion

Deletion of table hrp1001 must be done fo r both relations p-q and q-p.
Eg:

select * from hrp1001 into table itab_1001a
where otype = 'P'
and plvar = '01'
and rsign = 'A'
and relat = '032'
and istat = '1'
and begda = p_begda
and endda = p_endda
and infty = '1001'
and subty = 'A032'
and aedtm in s_aedtm
and uname = p_uname
and sclas = 'Q'.

select * from hrp1001 into table itab_1001b
where otype = 'Q'
and plvar = '01'
and rsign = 'B'
and relat = '032'
and istat = '1'
and begda = p_begda
and endda = p_endda
and infty = '1001'
and subty = 'B032'
and aedtm in s_aedtm
and uname = p_uname
and sclas = 'P'.

No comments:

Post a Comment