Date Keyfigures

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

 

data:

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’.

 

 

 

Leave a Reply