Typically, SAP Netweaver BW Systems, the date and time fields are modeled using standard Info Objects 0DATE and 0TIME, those infoObjects are treated as characteristics, but some reporting scenarios require calculations based on date and time fields, but the problem is 0DATE and 0TIME characteristics do not provide that kind of functionality.

You can implement thats scenario based on this guideline, Let’s assume that we have 4 date and time fields available in DSO, We’ll show you how to store them as key figures, which can be used to created restricted key figures using date and time fields stored as key figures.

To implement the date and time fields as key figures, you need to log in to the SAP Netweaver BW System and follow these steps :

  1. Go to RSA1 transaction code and create 2 new key figures, Event actual start date from as decimal key fig and event actual end date as decimal key figure with TYPE/DATA TYPE as Date and DATA Type as DEC – Counter or Amount Field With Comma And Sign.

sap_bw_infoobjects

  1. Create 2 new key figures, Actual start time from as Decimal Key Fig and Actual End Time to as Decimal Key Fig with TYPE/DATA TYPE as TIME and DATA TYPE as DEC Counter Or Amount Field With Comma and Sign.
  2. Include those new key figures in the source DSO in this scenario.

sap_bw_infoobjects_key_figures

  1. In the transformations for the source DSO, map the following :
  • Event Actual Start Date from As Decimal Key Fig to Actual Start Date From.
  • Actual Start Time From As Decimal Key Fig to Actual Start Time From.
  • Event Actual End Date to As Decimal Key Fig to Actual End Date To.
  • Event Actual End Time to As Decimal Key Fig to Actual End Time To.

The Date and time will be stored in DSO as numeric value format.

sap_bw_transformation_date_time_keyfigures

And you can get the result like this.

result_sap_bw_time_date_as_keyfigures

Leave a Reply

Your email address will not be published. Required fields are marked *