Change Table layout from Row perspective to a Columnar perspective

[preston_freeland]

I have a request from our users to change the layout from a Row type display to a columnar type display. The column may contain values of different types like floating point, character, dates, strings etc. Examples are shown below. My first thought was to use MS Office Integration with Excel. Using Excel to display the values and use ABAP when processing needs to take place.

Can the values of the Excel spreadsheet be loaded, retrieved and manipulated using methods in the view? High level process below.

[code]

1. load a blank excel spreadsheet into the view

2. read an SAP table

3. load values read from the SAP table to the blank spreadsheet.

4. manipulate the data

5. save data in the spreadsheet back to sap table

[/code]

Are there other ways to switch from a row type layout to a columnar type layout that I'm not familar with?

Any help would be greatly appreciated.

Thanks

Preston

[code]

Example # 1 - Current State

Deal Deal Cost Sales # of Gross

Name Type of Sales Price Units Profit

-

---

Deal 1 Everyday $6 $8 10 $20

Deal 2 Feature $6 $7.50 20 $30

Deal 3 Discount $6 $7 50 $50

[/code]

[code]

Example # 2 - Desired State

Deal Name Deal 1 Deal 2 Deal 3

Deal Type Everyday Feature Discount

cost of Sales $6 $6 $6

Sales Price $8 $7.50 $7

1. of Units 10 20 50

Gross Profit $20 $30 $50

[/code]

[preston_freeland]

Thanks for the quick reply. I am going to leave this question open in case someone else knows of a way to accomplish this.

Thanks Again

Preston

[Former Member]

Afaik, I dont think this is possible with the table element or even ALV. Since lead selection and context binding are all dependent on rows, I doubt if such a columnar layout is feasible.

If you dont want any action to be performed and only the display needs to be changed, this can be achieved by creating and aligning UI elements dynamically in a Matrix Layout. However, if you want such a display combined with selection or some other event handling, I dont think it will work.

Other experts please correct me if my understanding is wrong.

Regards,

Nithya

[mohammed_anzys]

Hi

Even i have the same opinion as that of nithya , i dont think its possible ...

@sascha @swetha ...Please correct if i am wrong.

Thanks

Anzy

[Former Member]

Hi all.

I guess this would be possible if you export the table to Excel and process it

before you bind it to the OFFICE_CONTROL. In the OFFICE_CONTROL you can

write an action for the on_save event and try to get the entered data back from the

excel document bound to the control and write the data into the data base.

But I never processed excel sheets with ABAP so you have to ask this question in the ABAP Forum I guess.

WebDynpro offers only the above emntioned things for working on office documents.

Hope this helps a bit,

Sascha