Skip to Content
author's profile photo Former Member
Former Member

BSID Query

Hi guys

I am an FI guy and I need your opinion on a query that I want to run for the table BSID, customer open items, as you know.

I want all to capture all the entries, where the assignment numbers (BSID-ZUONR) match.

I tried using SQVI but the query doesn't work. I created an alias table and created a join for ZUONR but it returns everything in BSID. Is there a workaround?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2007 at 01:28 AM

    Hi Kishan,

    I tried on my system using sqvi, it returns all entries that match with assignment number.

    could you be more specific about the error or anything else that make the your query doesn't work?

    thanks.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Kishan,

      I put assignment number in selection screen , so everytime i execute the query then i need to input the assignment number. But according to your last message, I am truly sure that this is not your requirement.

      As far as i know, you cannot do it (check double entry ) by SQVI. I suggest to create a small program using ABAP to handle it.

      Hope it can help.

      Thanks.

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.