Skip to Content
avatar image
Former Member

End time calculation based on date SAP BEx


Hi gurus,

I have a scenario where I have an info object 'End Time' which has to be calculated as the maximum value based on a date and another field which is unique. End time is already set to Aggregation 'Maximum' in rsa1 in the backend.

Please see the sample data below:

Steps Unique ID End time End date

S1 UID1 00:07:32 29-Dec-2014

S2 UID1 00:12:45 29-Dec-2014

S3 UID1 00:05:06 29-Dec-2014

S4 UID1 00:09:10 29-Dec-2014

I require the output to be :

Steps Unique ID End time End date

S2 UID1 00:12:45 29-Dec-2014

Constraint:

Unique ID and End date cannot be obtained from a variable.

Can you please help me calculate this value in SAP BEx Query Designer?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jan 02, 2015 at 04:34 AM

    Hi Aparajitha,

    There can be two options,

    1)Can you try the Top N Condition with N=1 for both Date and Time .- Query Designer

    2)Look Up in CMOD by passing the input variable - Backend Look UP.

    rgds

    SVU

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      write a customer exit on date using below logic.

      lv_snpdate TYPE /bic/ date infobject

      SELECT MAX( date) FROM /bic/ZDSONAME INTO TABLE itab.

      ' .

      LOOP AT itab INTO work area

      lv_snpdate = workarea -/bic/odate info object

      EXIT.

      ENDLOOP.

      l_s_range-low = lv_snpdate.

      l_s_range-sign = 'I'.

      l_s_range-opt = 'EQ'.

      APPEND l_s_range TO e_t_range.

      Regards,

      Rahul S

  • avatar image
    Former Member
    Jan 02, 2015 at 04:27 PM

    Hi Aparajitha,

    My advice how say SVU, is:

    1) Apply a condition query allowing only display your records
    2) Create another cube, when you only loads this records, you can add in your MP and your query only show values needed.

    You can use a exit var, but the result may not be as expected.

    Can share more about your requierement?.

    I hope helps.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded