on 10-21-2018 2:45 PM
Dear experts,
I need to create a query for formatted search.
https://www.youtube.com/watch?v=x2wbdJ2rlnQ
I'm trying to replicate this.
I have a user defined table (UDT) with user defined fields (UDF)
Case Scenario: User chooses Item (from formatted search #1), then chooses the warehouse (formatted search #2), and then chooses "On Hand in Warehouse" this should be based on Item Code (W2222) and Warehouse (W000)
Please help me out with this query,
Thank you in advance,
Shak
Hi Shak,
You haven't mentioned anything about SAP version you use, so I assume it's version for hana since you tagged your question like hana related.
Try the following query:
SELECT "OnHand"
FROM "OITW"
WHERE "ItemCode" = $[@TEST.U_ItemCode]
AND "WhsCode" = $[@TEST.U_WhsCode]
Where in parameters you might need to change the UDT and UDF name parts.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.