Wanted a working example of Desktop Office Integration Pivot Interface

[Former Member]

DOI Pivot - see

http://help.sap.com/saphelp_erp2004/helpdata/en/11/d92054a98411d3a6e50000e83dd863/frameset.htm

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

-jnc

[Former Member]

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!

-jnc