Reference data definition for sql function

[cornelia_lezoch]

Dear all,

I tried to implement a plannign function on HAN in sql, using a type with reference data and without blocks.

when I created the planning function, there was no second screen on which I could define which data to be used for reference (but it used to be there for exit functions in ABAP).

So where are we expected to define the reference data selection? Shall we do it directly in the sql code?

Thanks and best regards

Cornelia

[gregor_dieckmann]

Hi Cornelia,

what do you mean with 'second screen'? In your planning function type you define the parameters of the planning function and when you set up the planning function instance you get the 'generic' screen where you can maintain the parameter values.

As usual for a planning function the system calls IF_RSPLFA_SRVTYPE_IMP_EXEC_REF, GET_REF_DATA_SEL to determine the reference data and in the PAK case you get reference data IF_RSPLFA_SRVTYPE_TREX_EXEC_R, TREX_EXECUTE in parameter I_VIEW_REF.

Of course, if you just need some DB tables (e.g. you customizing) you can also reed these tables in SQL Script.

There also exist How To papers about this topic, e.g

https://scn.sap.com/docs/DOC-53800

and

https://scn.sap.com/docs/DOC-53376

where you e.g. find information how to read data from an 'external aggregation level'.

Regards,

Gregor

P.S.

The collection of How To papers

https://blogs.sap.com/2016/06/28/sap-how-to-guides-for-bpc-embedded-pakbw-ip-and-analysis-for-office...

might be useful.

[cornelia_lezoch]

Hello Gregor,

thanks for your answer.

with the "second screen" I mean this - it appeared when we used a function type exit with reference data in 7.4.

But this type of screen does not appear when using a function type with reference data on Hana trying to define a sql function.

Thanks

Cornelia