HANA Agedebt bucket logic

[Former Member]

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.

[former_member492332]

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.

net-due-days-logic.jpg