can we collect virtual table in sap hana in transport request

[naveenreddy]

we have created virtual table using SDA ...can we collect and transport virtual table across all the landscape...?

if so how ?

[former_member302041]

I see that you have put a tag "SAP HANA BW (SAP Business Warehouse)".

So was virtual table created in BW on HANA?

For further uses in BW?

[pfefferf · Accepted solution]

How did you create the virtual table?

If you are using XS Classic and have created the virtual table as catalog object (aka via a SQL command) than the answer is no.

If you are working with XS Advanced and have created the virtual table via the the .hdbvirtualtable artifact than it is possible.

[naveenreddy · Accepted solution]

we used SDA to bring structure from one hana DB to this hana DB...and added that view as Virtual table ...in this case can we collect Virtual table in TR...this Virtual table is added under catlog schema's

[naveenreddy · Accepted solution]

thanks folrian...got your point ...can you please let us know how to create virtual table using .hdbvirtualtable in hana studio ....any PDF document

[ssurampally]

As Florian said., .hbdvirttualtable is a design time artifact in XS advanced, you can’t do that in studio., xsa runtime and web ide are separate install