Joinning BSID BSAD

[Former Member]

Hi everyone!

I am working on some reports (SAP Query) and I have unsuccessefully tried to obtsin a report from BSID and BSAD. I included BKPF in the join but I still receive the message (No results selected).

I even tried BSEG, but I got it may no be used on joins (not even alone);

I also tried a standard DB (GLU4), but got the same message (No results selected).

All those tables have values.

Has anyone done something like that? Any suggestions beside an ABAP

program?

Naej

[Former Member]

No results selected is probably the result of the evaluation of your WHERE clause...what you have coded or values you supplied do not exist in table contents.

[Former Member]

Hi BreakPoint!

The"where clause" you refer to is a field? (Sorrry I am not ABAPer). I got the message even when I inform nothing as selecetion criteria (so maybe the problem coul be in he where clause, as you said)...

[Former Member]

Since you're doing SAP Query...WHERE clause would be generated for you and applies your mentioned selection criteria. Check data content of BSID, etc., with SE11or SE16. You're developing this in an instance that actually has data in the tables, right?

[Former Member]

Yes, no doubt.

I had checked all the tables in se16.

Each time I got that message I changed my infoset, then the Query.

[brad_bohn]

Is your title correct? Why would you join BSID and BSAD together? It makes sense that there aren't any entries found in that case.

[Former Member]

Hi Brad Bohn.

I need to develop a report with all line items (I need to show their statuses - open or closed) of clients that is why I am traying to join them.

Have you got any other idea?

[RaymondGiuseppi]

You cannot join BSID and BSAD, a "debitor" line is cleared or it is not, so it is never in both tables. You should not use a JOIN but an UNION (alas not in OPEN SQL). So read from BSID and then from BSAD appending results of first select.

In a SQ01 query, try to build an Infoset from logical database DDF (like transaction FBL5N) or VDF.

Regards,

Raymond

[Former Member]

Thank you very much.