The SAP HR RapidMart we provide (a pre-built DWH for SAP HR data) does use Custom ABAP Transforms to decode the PCL2 varchar fields into something meaningful.
But there are also BAPIs to do that.
And if you have a function that suits you, I would simply write an RFC enabled function which just calls your function and us that in the DataFlow.