Skip to Content
0
Nov 12, 2020 at 09:09 AM

How to split a single row into multiple rows based upon a number value

450 Views Last edit Nov 12, 2020 at 09:09 AM 2 rev

Hi all,

I am trying to split a single row into multiple rows based upon a specific number value.
For example, having a Document Line with "Quantity"=37 while OITM."SalPackUn"=10 I should obtain 4 SQL rows:
"ItemCode", 10

"ItemCode", 10

"ItemCode", 10

"ItemCode", 7
Is it possible to obtain this in Hana as it could be in Oracle or other dbms?
Thanks in advance.