topic Re: Query help needed for BSID in Application Development and Automation Discussions

Query help needed for BSID

Former Member — Tue, 20 Nov 2007 00:22:57 GMT

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

Re: Query help needed for BSID

Former Member — Tue, 20 Nov 2007 00:27:24 GMT

Hi Kishan,

What do you mean by Assignment numbers match?

Can you explain in more details.

Regards,

Atish

Re: Query help needed for BSID

Former Member — Tue, 20 Nov 2007 01:08:51 GMT

Atish

I want all the records from the BSID table where the assignment numbers are the same. The field name for the assignment number is ZUONR.

For example : Here is a simple BSID table entries list

Entry 1: BELNR=100, XREF=101, ZUONR=102

Entry 2: BELNR=200, XREF=201, ZUONR=102

Entry 3: BELNR=300, XREF=301, ZUONR=302

For the above table , I want BELNR numbers for entries 1 and 2, as the ZUONRs are same.

Re: Query help needed for BSID

Former Member — Tue, 20 Nov 2007 01:21:13 GMT

Hi Kishan,

This details you can only get in SE16. You can pass any ZUONR number and it will return all the values for the same.

Regards,

Atish

Re: Query help needed for BSID

Former Member — Tue, 20 Nov 2007 01:27:26 GMT

Atish

I know SE16 will return all the values when I input the zuonr numbers? But out of every 100 entries in BSID, only 5 to 10 entries have the same numbers for zuonr. How do I identify them??

I can download the entire table and run a query in MS access. But I was wondering, if there was something that I could do within SAP , like executing a query to avoid that extra step..

Re: Query help needed for BSID

Former Member — Tue, 20 Nov 2007 01:34:57 GMT

Hi Kishan,

No we don't have anyting like this.

Just to explain this I can give you a brief explaintaion may help.

Just tell me on what basis SAP will restrict entries..by comapring two ZUONR and will show the one which are same..now in Access of Excel also you need to put a filter on the specific ZUONR..This is nothing but the same as giving the value of the ZUONR in SE16 itself in the selection screen..

Hope I was clear enough to explain this.

Regards,

Atish

Re: Query help needed for BSID

Former Member — Tue, 20 Nov 2007 04:11:13 GMT

I've never tried this, but you could JOIN bsid to itself where the ZUONRs match, but the documents don't. If it works, don't expect it to be quick, though.

Rob

Re: Query help needed for BSID

Former Member — Tue, 17 May 2011 18:13:30 GMT

This was a stupid question on my part. Can't believe I posted this. 4 years ago though.

We created a custom program and got this resolved.