Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

User based query

Hi,

How do we write a query for last 3 quotation for a particular item and a particular customer created by a particular user.

I want to create a single for all users and assign it as formatted search.

Rgds

Former Member
Former Member replied

Type parameter has options

Number, Date, Currency

Example: If you notice the Unit Price column you have the Currrency symbol also included in the value. To extract just the number part exluding the currency symbol you will use the .Number type

$\[$38.14.Number]

Please go this document on defining Formatted Searches which explains it all

https://websmp102.sap-ag.de/~form/sapnet?_FRAME=CONTAINER&_OBJECT=011000358700000709722007E

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question