Skip to Content
0

HANA Agedebt bucket logic

Jul 28, 2017 at 11:20 AM

33

avatar image
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.

capture.jpg (52.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Prashant Patil Aug 08, 2017 at 10:08 AM
0

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


Share
10 |10000 characters needed characters left characters exceeded