cancel
Showing results for 
Search instead for 
Did you mean: 

Formatted Search in SAP Business One

shak9828
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member390407
Contributor
0 Kudos

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.

shak9828
Participant
0 Kudos

Dear Sergei,

Thank you very much. Yes, it’s SAP Business One 9.3 HANA.

Your query worked. I’m grateful.

Best Regards,

Shak

Answers (0)