link between template and query (or template and infocube)

[Former Member]

Boa tarde,

I need to find link between template (bex) and query. I know tables Web Templates, but this tables don´t work ... follows list of the tables:

Web templates tables:

RSZWOBJ Storage of the Web Objects

RSZWOBJTXT Texts for Templates/Items/Views

RSZWOBJXREF Structure of the BW Objects in a Template

RSZWTEMPLATE Header Table for BW HTML Templates

...

I have a query and this query is used and the Template, but I can´t find the link, I already seen the tables:

RSRREPDIR

RSRWBINDEX

RSRWORKBOOK

RSZCOMPDIR

RSRWBINDEXT

SMEN_BUFFC

...

Only the tables that contains information about (my) template are:

RSZWBTMPHEADTXT

RSZWBTMPHEAD

But I have only the description ...

....

thank you very much .... for yous help ...

Obrigado,

Márcio

[sven_mader2 · Accepted solution]

Hi,

Now, I don't have a BW system.

In a table there is saved the definition of the WebTemplate in one table field. It's saved as XML.

You must looking for <dataprovider>. There you see the query.

Sven