05-19-2009 1:03 PM
Hi
I have created one temporary table and added data manuely
there is so many rows contains tmststats as 'Approved'
After executing these statement also it is not deleting.
DELETE i_output WHERE tmststats EQ u2018Approvedu2019.
the declaration of tmststats is like
tmststats(30) type c
Regards
Sebastian
05-19-2009 1:05 PM
05-19-2009 1:05 PM
05-19-2009 1:06 PM
Hi,
It is not clear that, whether you want to delete record from Standard Table or Internal table.
Please clarify.
Rgds.,
RamaniN
05-19-2009 1:07 PM
Hi John,
ur checking with table field,
please give EQ 'APPROVED' insted of 'Approved'.
05-19-2009 1:08 PM
HI,
The syntax seems to be correct. check with 'APPROVED' ...it may work. Check for sy-subrc after the delete statement .
05-19-2009 1:11 PM
Hi,
DATA: L_DATA(20) TYPE C VALUE 'Approved'.
condense l_data.
DELETE i_output WHERE tmststats EQ l_data.
Thanks & Regards,
Vallamuthu.M
05-19-2009 1:29 PM
I am using Internal table, I have stored data as 'Approved' not capital
if checking with upper case also it is not working
Regards
Sebastian John
05-19-2009 1:32 PM
Thanks for everybody, its woking fine.
it is my mistake, inside the data having some mismatching.
Regards
Sebastian John
05-19-2009 1:15 PM
Hi,
DELETE i_output WHERE tmststats EQ u2018APPROVEDu2019. "Check with all Caps
05-19-2009 1:45 PM
Hi,
Check with.
DELETE i_output WHERE tmststats EQ u2018APPROVEDu2019.
if sy-subrc = 0.
endif.
Hrere u check wgt is the vale of sy-subrc whether it is 0 or 4, if it is 0 then it will delete.
Regards