Is there any possibility to append one field to other in SAP HANA?

[former_member339062]

Hello Guys,

Is there any possibility to append one field to other in SAP HANA, SQL Script based or Graphical? As in ABAP we have APPEND statement to do the same.

Please suggest a way in HANA too.

[pfefferf]

It is not really clear what you wanna reach. An ABAP Append adds a row to an internal table, but does not append one field to another.

Please add more details about your requirement (base data + what you expect).

[former_member339062]

Dear Florian,

My requirement is :

I have a Column in my Calculation view, i.e. Material Number and second column in its BOM Components. Requirement is if 'A' is the Material Number and 1,2,3 are its components, then the final report/CV will show result in only one column i.e. User prompt of Material Number "A" gives

A

1

2

3

[former_member339062]

Any Comments here Florian?

[pfefferf]

And the 'A' value is also a row value (and not a column header)? What result would you expected if you have more than one material (e.g. Material A and Material B)?

[former_member339062]

I am expecting that Material B also, I will get components, as I need to bind this Material as User prompt selection (will pass as input parameter)