Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

Wanted a working example of Desktop Office Integration Pivot Interface

Former Member
0 Kudos

DOI Pivot - see

I find it mysterious that there is not a single example on DOI PIVOT Interfacein SAP examples (DWDM & SE83). I have successfully used spreadsheet interface of DOI(Desktop Office Integration (BC_CI)) in many reports with no problems. Recently I wanted to generate a pivot table directly using the PIVOT INTERFACE of DOI. After struggling 2 days I am giving up.

<b>Kindly send me a working example of Pivot Table creation using "set_source_table" method or kindly give me a reference to any transaction in mySAP ERP where DOI pivot interface has been used. </b>

Regards & Thanks



Former Member
0 Kudos

Message I got from from SAP - "Have you checked the program "SAPRDEMO_PIVOTINTERFACE" you can execute the same with Transaction SE38. This uses the pivot interface.

Also for your information we have many DEMO Programs under the Package SOFFICEINTEGRATION, you can have a look to these for better understanding with the SAP Office Integration."

This has helped me solve my problem. Incidentally the brilliant routine DYN_ANALYSE_SINGLE has 1 bug. It has reused a variable "DATA : N_COMPS TYPE I." before checking a recursion and hence corrupted the same. Possibly the example does not traverse that part of the code and hence bug is undetected.

I and my end users are delighted!