My team has used ACL with DirectLink to pull SAP tables in the past. Now, we want to convert our ACL scripts to Alteryx workflows. One of the issues that we have run across is joining clustered tables such as BSEG and BKPF in Theobald's Xtract Universal. ACL DirectLink was able to join these tables and other clustered tables with no issues, but Xtract Universal throws an error when I try to do the same thing. I was just curious if anyone else has experienced this, and if so, how did you get around it?
You guys seem like a really advanced team, impressive!
One solution might be to extract the BKPF records you want and then pass those documents numbers in chunks as a filter for a separate BSEG tool placed inside a batch macro ;)