Skip to Content
Oct 30, 2018 at 09:41 PM

Calculations before parameter mapping in ABAP CDS


Hi All,

I have a fiscal period parameter (Ex. 03) and a fiscal year (Ex. 2018) parameter flowing in from a layer of views below. So the select statement now is:

select from <view>

(P_FiscalPeriod: $parameters.P_FiscalPeriod ,P_FiscalYear: $parameters.P_FiscalYear).

Now the user wants to enter a single parameter 03.2018.

To accomodate this change, I would want to separate out the fiscal period and year from this string before the parameter mapping is done - maybe use one of the substring functions.

The problem is that I can't do this within the parameter mapping code. I cant write P_FiscalPeriod: LEFT($parameters.P_FiscalPeriod,2) . It starts giving syntax errors.

I can't figure out the right syntax or other ways to do this. Am not able to find an example either.

Any help would be greatly appreciated.