Actually i got requirement like i have to transpose the Row data into Column for Dynamically.

Material materiral_type value 20 x1 10 20 x2 20 20 x3 70 20 x4 80 30 x1 10 30 x5 20

Result required in SAP HANA : material x1 x2 x3 x4 x5 ...etc., 20 10 20 70 80 0 30 10 0 0 0 20