Skip to Content
avatar image
Former Member

Ageing analysis in ISU

Hi ,

  I need to display the report in the below format in report :

 

 

  Customer

  180 Days

  180 Days

  150 Days

   120 Days

  90 Days

  60 Days

30 Days

Current

  Balance

  I have got the document date in the extract.

could you please let me know how to design this logic.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 21, 2015 at 02:19 AM

    Hi Raju,

    you can create a Restricted key figure / Selection to achieve the buckets (days)

    Restricted key figure -- drag and drop key figure (ex: total) ->then document date, now restrict the document date with variable range using offset values . you can use the standard variable 0DAT (current date) when applying offsets.

    ex: 0Dat-30 to 0dat . this give the the value of last 30 days. similarly you can apply it for other days.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2015 at 02:36 AM

    Hi,

    it was easy to do at BEx designer.

    you can create the calcualated key figure below like this.

    > 30 days, 30 =<60 days,

    use the document date as the objet.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2015 at 11:47 AM

    Hi Guys,

    I was able to deliver this , but customer changed requirement.

    Now customer want to see the report on the date , which they enter and not on current date.

    For current date I implemented the logic in DSO for each record and displayed in query by using restricted key figures.

    Current scenario : user enter the date value and we should calculate ageing from there.

      for eg. user inputs end of august and report should show ageing based o that date.

    so logic is document date - to date.  This has changed the logic , now I cant calculate the ageing at DSO leve l as I dont know what date user will input.

    Can somebody help with the new logic.

    I am just worried all abap code will go away and all will be handled in query.

    Kindly suggest some logic if possible.

    Thanks !

    Add comment
    10|10000 characters needed characters exceeded