Adapt Flexible Search to Impex Export

[former_member909007]

Hi everyone, first time post.

I'm having trouble adapting a Flexible Search I'm using into an Impex Export (purposes being I'd like to get the results in a .csv file rather than displayed on screen.)

Flexible Search:

select {variant.code}, {product.code} from {SizeVariantProduct AS variant}, {Product AS product}, {CatalogVersion AS cv}, {Catalog as c} where {variant.baseProduct} = {product.pk} and {variant.catalogVersion} = {cv.pk} and {cv.catalog} = {c.pk} and {cv.version} = 'Staged' and {c.id} = 'MainProductCatalog'

Could anyone assist me in adapting this into an Impex Export?

Thank you in advance for any assistance.

[former_member751591]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with Community Q&A , as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line.

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial Q&A tutorial

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.