cancel
Showing results for 
Search instead for 
Did you mean: 

SAP HANA default value variable

Former Member
0 Kudos

Dear all.

I am using SAP HANA Studio Version: 2.2.14. I need to set a default value in a variable for a calculation view. For example, variable Z_DATE to have the last day of the current month as default value when the selection screen pops-up.

In BW it can be done using customer exit variables but no idea how to implement it in HANA.

Has anyone faced the same situation?

Thanks for the support,

Fran.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Fran,

You can have a 'Default Value' with Expression where you can write your expression using different type of functions based on your requirement.

Best Regards,
Shireesha

Former Member
0 Kudos

Hi Shireesha.

The Expresion functions are useful for simple logic requirement but in case of complex requirements it will need other approach. For example, "Set as default value in a variable the oldest date value of column DATE in table TABLE". It will require to apply a selection to the table and deliver the result somehow.

Any clue how to do it?

Best regards,

Fran.

0 Kudos

Hi Francisco Diaz,

I don't know about how to do this in variables.

As per my knowledge you can achieve this kind of scenario using input parameters, by making that parameter type as Derive From Procedure, and you can write your complex logic inside that procedure.

If anyone knows how to do this in variables, please share here.

Regards,

HarikrishnanS

Answers (1)

Answers (1)

0 Kudos

This message was moderated.