WF to query a material from Excel into SAP and retrieve/transform data

[xadamasx]

Hello community!

I have a use case where we need to read a material number off of an Excel sheet and have Alteryx then query and pull back MARA and MARC table data back into the workflow. I assumed this would be fairly straightforward with the SAP table tool, but as a newbie I am struggling to understand how that could work and I'm also struggling to find many examples or tutorials on how to make something like this work. I've scoured the forums and youtube and nothing seems to address this specifically. I don't have an example workflow to share since this is quite literally the first node that would be built. But I've attached a screenshot of the excel file template

If anyone can point to any resources or have an example WF I can mimic for a similar use case, that would be amazing. 

Thanks!

[apathetichell]

dynamic input overwrites what's on your sheet - so Name would be Reference Material. Selection would be I (include), Operator would be EQ (equals) or BT (between) and Low Key/High Key would be the values. If it it's a range you would want an operator of BT and a Low Key/High Key there. If it's a classification you would need a discrete value - low key and high key could be  the same and operator would be EQ.

Not sure if there is another name for Reference Material... Can you click on the parameters toggle next to dynamic input and see if there is a Key field? (also make sure you have no nulls in dynamic input).