Factory Calendar consumption in SAP HANA

I needed to do some working-days based calculation in a standalone HANA system and struggled quite a bit. Having achieved what I was aiming for, decided to share my solution. Hope it may help somebody in the future, too.   A pre-requisite for any of this is: l Table TFACS loaded/replicated from a SAP system l Your custom table DATA_TRANSFORM (explained below) l Generated Time-data in HANA (optional)   The…