Skip to Content

I want to have a list of all queries in my SAP B1 and where are they deployed

Dear Gurus

Please guide me how to have a list of all queries in my SAP B1 and where are they deployed?

Your prompt reply needed

Regards

Ghufran

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 02, 2015 at 01:53 PM

    Hi Ghufran,

    You may check this:

    Select T2.FormID, T2.ItemID, T2.ColID,

    T1.CatName,T0.Qname FROM [dbo].[OUQR] T0

    INNER JOIN [dbo].[OQCN] T1 ON T0.QCategory = T1.CategoryId

    INNER JOIN [dbo].[CSHS] T2 ON T2.QueryId = T0.IntrnalKey

    ORDER BY T2.FormID

    Form id is the document and item id is where the fms is applied.

    Also, for ease of access, while creating fms's, manage categories accordingly, for. ex. FMS- BP, FMS- SO, FMS- AR Inv etc. So, if you are on any document and you see any fms, you know where to look for it.

    Hope this helps.

    Thanks,

    Joseph

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 02, 2015 at 05:50 AM

    Hi,

    Go to Tools > Queries > Query Manager . All your queries will be shown there. You may export it to excel if you want.

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 02, 2015 at 06:46 AM

    HI

    Ghufran Moin

    Bellow Three Query's

    1) Select * from OUQR(For ALL Querys)

    2) Select * from RDOC ( for Print Lay OUT Details )

    3) Select * from OQCN ( Query manager labels)

    if got the Solution Close the Thread

    Thanks&regards

    Andakondaramudu

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.