Filtering Large Theobald Reports for Sales Order Data in Alteryx

[Ryanz3653]

Hi community,

I need help with obtaining information from a list of sales orders using a Theobald report connected from SAP. My initial plan was to join this list with the whole-ran report(left side of screenshot), but the report is too large to load. In SAP, there are variants to set and filter to make it smaller, but unfortunately, this one can't be filtered and needs to be run whole.

Is there a way to filter the data BEFORE running the Theobald report(right side of screenshot)? Or what would be the best approach to handle this?

Please see the attached screenshot for a clearer explanation of the logic. Any guidance on the workflow would be greatly appreciated.

Thank you

[griffinwelsh]

Your Theobald connector looks different than what the version we use at my company, but generally I skip reports entirely and just pull data in from the table level. This takes longer to build but is more efficient when running and *should* avoid the report size errors. You can use t-code ST05 to find the underlying tables if you want to take that approach.

[Shoeby]

Sorry for the late reply, not sure if you figured this out or not, but I also try to build from the table level.  

A couple thoughts.  When I do build from reports, I've gotten around this 2 different ways.

1.  Pull smaller chunks in SAP...   I've needed 3 years of data, and created 6 Variants for 6 month time periods, and then used 6 Xtract Reports, unioned the results, and wrote that to a yxdb file because it was massive.

2.  I have also had luck with setting the report to background processing (and upping the background job time out.).  This does normally require you to do some formatting to clean up SAP's hideous background output.  In most of my reports I have to skip 4 rows from the top as a start to the formatting.

Hope this helps.

[Ryanz3653]

thank you for your reply,

1, unfortunately the specific SAP report i am using does not have a date range option for me to set, i am trying to find a way to filter before the theobald tool, not sure if that is doable

2, sounds like that needs to be done in SAP level by the specialist, right?