select Year value from badat field

[Former Member]

I want to display year value only from EBAN- badat fields. in select query, what coding is use here .

[Former Member]

Answer rec own...

[raymond_giuseppi]

- For selection, try to convert your year parameter into a date [range|http://help.sap.com/abapdocu_70/en/ABAPRANGES.htm] that will be used in your [where in seltab|http://help.sap.com/abapdocu_70/en/ABENWHERE_LOGEXP_SELTAB.htm] clause.

- For display just extract four first characters.

Regards,

Raymond

[arul_murugan]

Hi,

You can declare as badat+0(4) in select query or while moving to any variables. but while using in select query check the format of the variable is same or not.

Thanks

Arul