topic Re: clear data from infotype in Application Development and Automation Discussions

clear data from infotype

Former Member — Wed, 13 Jun 2007 09:21:39 GMT

i want to clear all the data which is there in infotype 2006 how can i do it

plzzz help

Re: clear data from infotype

Former Member — Wed, 13 Jun 2007 09:33:57 GMT

Use the fun module

HR_INFOTYPE_OPERATION

use the OPERATION = 'DEL'

Reward points for useful Answers

Regards

Anji

Re: clear data from infotype

Former Member — Wed, 13 Jun 2007 09:44:35 GMT

write a program


selection parameters : s_pernr   for  pa2006-pernr  .

TYPES: data  :  begin of itab_wa  occurs  
include structure   pa2006 .
end of  itab_wa .

DATA itab  TYPE TABLE OF itab_wa. 

SELECT *       FROM pa2006
       INTO CORRESPONDING FIELDS OF TABLE itab 
       WHERE  pernr  in  s_pernr .

DELETE pa2006 FROM TABLE itab .

reward points if it is usefull

Girish

Re: clear data from infotype

Former Member — Wed, 13 Jun 2007 09:45:19 GMT

WILL IT DELETE ONLY DATA AS I ONLY WANT TO DELETE ONLY DATA

Re: clear data from infotype

Former Member — Wed, 13 Jun 2007 10:20:55 GMT

surely reward point is pending from my side but please give me clearified code i want to delete all the data which is there in infotype 2006

Re: clear data from infotype

Former Member — Wed, 13 Jun 2007 10:23:29 GMT

can u be some more clear how and where to write code i want to delete all the date which is there in infotype 2006 not based on any condition.

Re: clear data from infotype

Former Member — Wed, 13 Jun 2007 11:13:35 GMT

please use this code .... it was working fine ..

just copy and paste ... inselection screen give all the employee no... if not it will clear all the employess data in it2006

tables  :  pa2006 .
select-options  : s_pernr   for  pa2006-pernr  .

TYPES: begin of itab_wa.
include  structure pa2006 .
types : end of  itab_wa .

DATA itab  TYPE TABLE OF itab_wa.

SELECT *       FROM pa2006
       INTO CORRESPONDING FIELDS OF TABLE itab
       WHERE  pernr  in  s_pernr .

DELETE pa2006 FROM TABLE itab

Girish