Skip to Content
avatar image
Former Member

HANA Agedebt bucket logic

Hi All,

I'm trying to replicate the below BW Agedebt report logic in HANA agedbet reports. The issue I'm facing here is, how can I do the below offset calculation in HANA views ?

As per my understanding I need to create a Calculated column as Net due days, and the logic should be the difference between the netduedate and the Keydate (which is nothing but an input parameter) entered by the user. Once I have netduedays column ready then I can apply the below restriction in the HANA restricted columns.

We have now "NetDueDate" (a date field) and "Key_Date" (an input varaible), could you anyone please help me in writing the logic for Netduedays using the above two fields ?

I'm new to HANA and trying to learn but there isn't much help on creating these sort of calculation any where on the web.

Thanks very much.

capture.jpg (52.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Aug 08, 2017 at 10:08 AM

    Hi Supra

    You can use 'daysbetween()' string function in HANA calculation view to calculate the Net due days.

    Note: Key date input parameter needs to be converted to date format for the string function to work.


    Add comment
    10|10000 characters needed characters exceeded