Please Share your Product Ideas with us!

All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.

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
Stewardship Tier (SST) Framework / Collect
  • Attach files
  • Prasad Wadekar commented
    May 24, 2018 14:25

    Hello,

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

    ×

    Attachments Open full size

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

    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.

    ×

    Attachments Open full size

Related ideas