A date Key figure will display in a BEx Query in date format (ex: 13/4/2013), but is stored in the info provider as a number.
The smallest value possible seems to be 01/01/1900 which is stored as 693597.
To convert a date KF value to a date data type do the following
l_date type /bi0/oidate,
l_date_kf type /bic/oizkfdate. ” zkfdate is a date key figure
l_date_kf = 693597.
move l_date_kf to l_date. => l_date now contains ‘19000101’.