Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

year from date field

hi

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.

regards

sami

Tags:
Former Member
Former Member replied

ok then take a char field

data : yr(5).

concatenate sy-datum+0(4) '%' into yr.

now use

select * from cdhdr into table itab where udate like yr.

regards

shiba dutta

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question