Copy a BI Query from one system to other

[Former Member]

HI All,

I have to copy a BI query from one system to the other BI system with the help of ABAP. I am trying to download the BI query, and then will upload the query to the other BI system. Two systems might be on different versions and might not be connected.

Need inputs on how i can acheive this.

Regards,

Sanyam Kataria

[former_member199945 · Accepted solution]

This F.M  : RSZ_DB_COMP_LIST_GET  might be helpful .

& also Refer this   Translate BEx Query Element Technical IDs in SAP Transport Requests to Readable Format | SAPBWBW

[Former Member · Accepted solution]

RSZ_DB_COMP_LIST_GET returns E_TH_COMPLIST with the component list. Can you please elaborate how i can use the E_TH_COMPLIST?

[former_member199945 · Accepted solution]

I am also not aware  of that F.M, Press F1 help it will give you an Idea.

[KodandaPani_KV]

Hi,

you can achieve the transporting the bex queries form one system to another system.

generate the bex transport request in dev then move to target system.

collect the transport request under transport management system.

import the queries in STMS.

Thanks,

Phani.

[Former Member]

Here the two systems might not be connected and could be on different versions.

I am trying out a way where i can download BEx query with the help of ABAP and then can be uploaded to the other system.

[KodandaPani_KV]

Hi,

your are working on which system dev or qas?

Have you developed the queries in dev system?

please make the connection with help of basis team.

downloading and uploading one system to another system not good.

can explain more what you want achieve.

Thanks,

Phani,

[Former Member]

I have to move the queries from one DEV system to other DEV system, but these systems will be on different versions, so i can't use basis to transport the TR. The only option left is to download the BEx query(if possible) and upload it to the other system with the help of ABAP.