Skip to main content
To homepage To homepage
Solved

SAP Theobald XtractIS - Subqueries

KaiMueller
TimeXtender Xpert
Forum|alt.badge.img+1

Hi all,

I need to extract data from a huge table in SAP (KONV) based on a subquery from another extracted table (VBRK). Any ideas on how to solve this using the XtractIS? 

I can’t use quey tables on this type of connector and I tried to put the subquery in the filter rows filter for “in list” which also didn’t work either.

 

Any more ideas how to solve this?

 

Many thanks

Kai

Best answer by rory.smith

Hi @KaiMueller ,

 

you cannot directly do that in TimeXtender's SAP Table connector. I think you have three options:

  • limit the extract from KONV based on a fixed list of filters that reduces the size of the table enough to transfer it and then do the final filter afterwards
  • use an available view or have one developed in SAP to imlement the query you need
  • take the SSIS package generated by TimeXtender as a template and implement what you need in a new SSIS package, calling that from TimeXtender

You could do this in Xtract Universal, but that has a much higher pricepoint.

 

View original
Did this topic help you find an answer to your question?

2 replies

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • rory.smith
  • TimeXtender Xpert
  • 649 replies
  • Answer
  • May 31, 2024

Hi @KaiMueller ,

 

you cannot directly do that in TimeXtender's SAP Table connector. I think you have three options:

  • limit the extract from KONV based on a fixed list of filters that reduces the size of the table enough to transfer it and then do the final filter afterwards
  • use an available view or have one developed in SAP to imlement the query you need
  • take the SSIS package generated by TimeXtender as a template and implement what you need in a new SSIS package, calling that from TimeXtender

You could do this in Xtract Universal, but that has a much higher pricepoint.

 

Christian Hauggaard
Thomas Lind
2 people like this
  • Christian Hauggaard
    Christian Hauggaard
  • Thomas Lind
    Thomas Lind
KaiMueller
TimeXtender Xpert
Forum|alt.badge.img+1
  • KaiMueller
  • Author
  • TimeXtender Xpert
  • 6 replies
  • June 4, 2024

Thanks @rory.smith,

I thought so as well. 

I tried to put the subquery into the Extract IS Component in Visual Studio, but that also generates an error (Subqueries only allowed on transparent tables).

I’ll try to filter the data as much as possible in the ODX but this makes it also really hard to implement an incremental load.

I will have a look into the SSIS package TX generates. Thats a good tip.

 

Thanks!

Kai

 

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings