Skip to main content
Solved

SAP Theobald XtractIS - Subqueries

  • 31 May 2024
  • 2 replies
  • 44 views

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

2 replies

rory.smith
Rank
Userlevel 6
Badge +7

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.

 

KaiMueller
Rank
Badge

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


Terms and ConditionsCookie settings