Skip to Content
-1
May 14, 2018 at 11:31 AM

question on hana db type casting

103 Views Last edit May 14, 2018 at 01:11 PM 2 rev

Hi ,

generally we do a lot of type casting when joining two tables for example if we want get data from iflo view based on entries in equi table ( which we are using for all entries )

like for example

if lt_equi is not initial

select tplnr tplma from iflo into table lt_iflo for all entries in lt_equi where tplnr eq = lt_equi-equnnr.

here we need to type cast as equnnr is char 18 and tplnr is equal to char 30 . how to achieve this cast in hdb.

thanks