Hi folks. I am a newbie to SAP HANA . Previously I ve worked on Oracle DB. We need to migrate our datawarehouse from Oracle to HANA db.I need to create a custom function in HANA DB which accepts the input Material Number which is a varchar field and it should check if the input field contains only numbers. If yes, the leading zeros should be trimmed. Else the material id should be returned as is. Here is the Oracle variant of the function. Please provide an equivalent HANA variant for the same.
CREATE OR REPLACE EDITIONABLE FUNCTION ERPDEV.FN_CONVERTMATNR (MATNR_P IN VARCHAR2) RETURN VARCHAR2 IS MATNR_V VARCHAR2(100); BEGIN matnr_v:=to_number(matnr_p); MATNR_V:=LTRIM(MATNR_P,'0'); RETURN MATNR_V; EXCEPTION when value_error THEN MATNR_V:= MATNR_P; RETURN MATNR_V; END; / GRANT EXECUTE ON ERPDEV.FN_CONVERTMATNR TO MIGDEV / GRANT EXECUTE ON ERPDEV.FN_CONVERTMATNR TO JDEDEV /