Collect should allow SQL clauses in Where Clause Override field

Any valid source-system SQL that follows the "SELECT FIELDS FROM TABLE" should be able to be used, for example:

Select * 
From "SAPR3"."KONP" --From here onwards is valid for Oracle source systems. 
K INNER JOIN 
"SAPR3"."A017" A 
ON 
A."MANDT" = K."MANDT" AND 
A."KNUMH" = K."KNUMH"

  • Guest
  • May 9 2018
  • Future consideration
  • Attach files
  • Prasad Wadekar commented
    24 May, 2018 02:25pm

    Hello,

    I think, you can still use that in the assemble package and use that within collect. Did you try that as a workaround?

  • Admin
    Jon Green commented
    18 May, 2018 08:58am

    Kevin, thanks for logging this.  We agree that further work is required on the where clause construction within Collect to improve flexibility around this aspect of the product.  We will look to improve this area of Collect in future releases.