year from date field
in cdhdr table udate field is there. i want to retrieve the records belong to 2007
only. when i am using offset on udate field as udate+0(4) in the select statement it is showing error. plz tell me how to retrieve only year form udate field in select stament.
ok then take a char field
data : yr(5).
concatenate sy-datum+0(4) '%' into yr.
select * from cdhdr into table itab where udate like yr.