Skip to Content
avatar image
Former Member

Input Parameter F4 help Date format Change in SAP HANA

Hello All,

I am working on creating the Input parameter for Start and End Date, and I want to have date format while we do F4 Help in HANA (Semantic type) , we should get format of YYYYMMDD.

In current scenario when we do F4 help in date and select any date we get the format as YYYY-MM-DD.

Do  we have any setting in HANA from where we can change the default layout of date to YYYYMMDD for F4 help.

Appreciate the help.

Message was edited by: Tom Flanagan

1.png (4.9 kB)
2.png (9.6 kB)
3.png (7.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 22, 2016 at 09:17 PM

    Hi Hemang,

    There is a new feature in SP11 that does exactly this: conversion functions.

    see slide 16 What's New in SAP HANA View Modeling

    But you can achieve something similar by creating an extra Input Parameter Derived From procedure/scalar function and pass the Input Parameter into it.

    see Dynamic filter / User Exit Variable for HANA Views

    Add comment
    10|10000 characters needed characters exceeded