Export query data to XML-File?

[Former Member]

Hello,

how can I export data out of a BI7-Query into a XML-file (maybe also schedule it into a job)?

I know the rscrm_bapi, but it only can export query data to csv.

Another question: where are the queries inside DDIC located? (That would be an alternative to write a report or FM which exports the query data into a xml-file)

Thanks!

[Former Member · Accepted solution]

you can look at FM:

RRW3_GET_QUERY_VIEW_DATA

for fetching the data and then converting the output into XML for your reference using a program...

[Former Member · Accepted solution]

Thanks for the hint.

I found another FM called "/OSP/SAP_QUERY_DATA_TO_XML"

When I was trying to test this FM, I get a sy-subrc = 1.

Inside the FM there are code-operations that trý to read a table called "iqqcatdb"

The strange thing is that this table is empty (also there is no description found inside the FM).

Any help on this? Thanks!

Edited by: Robert Karlovic on Mar 19, 2009 7:14 PM

[Former Member · Accepted solution]

Hi robert,

I am facing the same problem as well. Have you tried exporting the query data in XML format. if yes please post.

regards,

sree.

[Former Member · Accepted solution]

Hello sree,

check this link:

https://www.sdn.sap.com/irj/scn/wiki?path=/display/bi/expose%2bbi%2bquery%2bas%2brestful%2bservice

[Former Member · Accepted solution]

Hi Robert,

I followed exactly the same steps as mentioned in the Restful Service Wiki Article. However,

1) when I Test this new BSP application from SICF, I get the error Business Server Page (BSP) Error. additionally I get the following as well.

Exception Class CX_FQDN

Error Name

Program CX_FQDN=======================CP

Include CX_FQDN=======================CM002

ABAP Class CX_FQDN

Method CHECK

Line 10

Long text -

2) Even if I get the above problem solved. How will I be able to broadcast query data to XML Pages via Information Broadcaster. Will I get a saperate option that says Output format = "XML".

I am not sure of the above two questions.

If you have please help me.

Regards,

Sree