Creating multiple lines under a header - SAP

[Ankesh]

Please correct me if i have misunderstood your requirement.

All you want to do is pass multiple values in one column and then use it in your script.

Say, datatable has a column named "InputCharacters" which has values as QTW002,QTW003,QTW004

Please note i have separated the values by comma.
Now the code goes as

Code:

strCharacters=Datatable("InputCharacters",dtGlobalSheet)'get the datatable values
'Now you need to split the values
arrCharacters=Split(strCharacters,".")'i am splitting on comma as the values were separated by comma

arrCharacters will have all the values now.

to get the values, you can use the index. Let us consider our example
arrCharacters(0) will give QTW002
arrCharacters(1) will give QTW003
arrCharacters(2) will give QTW004

you can use these values to set in the table as

Code:

For i=0 to Ubound(arrCharacters)
SAPGuiSession("Session").SAPGuiWindow("Characteristics").SAPGuiTable("Allowed Values").SetCellData i+1,"Char. Value",arrCharacters(i)
Next

Note: You can always modify the code to fit in ur requirement.

Regards,
Ankesh