QUery BSID BSAD

[adrian_pardavila]

Hi Everyone

I create a query follow the next steps:

- I create an infoset and associate it to user group (SQ03)

-I add in the infoset the tables BSID and BSAD and i choose the fields that i need (sQ02)

STCEG

BUKRS

KUNNR

GJAHR

BELNR

- I generate it and also save

-After that i create a Query in SQ01

Actually is working but it doesnt show all information in the tables for example y want run the query with the field STCEG cover and it show me the KUNNR but my query just show some customers and any Vat number..

I check in the tables using the SE16.. and it has information but it isnt the same that i see when i run the query.

Any idea how can i fix it?

thank you

Regards,

[iklovski · Accepted solution]

Hi,

Joining BSID and BSAD makes no sense as these are self-excluding tables, i.e. an entry in BSID won't be existing in BSAD and vice versa.

Regards,

Eli

[Former Member · Accepted solution]

Hi Eli, you're write, but may be there is requirements to build report All items for order, or customer etc

[adrian_pardavila · Accepted solution]

Exacly it is!!

I cant use the bseg and i need use bsid and bsad.. I am changing my conditions but at the moment it isnt working!!

thank you

[Former Member · Accepted solution]

Hi, which table do you maintain as a 'main'? Which fields do you use for link? What are selection fields and from which table (which you maintain before run repost)

[Former Member · Accepted solution]

Hi,

Try SQVI -Quick Viewer which has the same functionality of Joining the tables.

Thanks

Goutam

[adrian_pardavila · Accepted solution]

In each table i use the same fields.

Customer

Year

document

Vat number

company code

accounting document number

And the conexion before was it fields, but actually there are more and continue no working!!

Regards,

[adrian_pardavila · Accepted solution]

I try it. but the same results

Thanks

[Former Member · Accepted solution]

Hi, the issue that one item couldn't be in both tables. So if for example you put in selection customer number from bsid(where bsid 'main' table), which has no value, then in out put you have nothing.

So you need to use Selections options in SQ02

[adrian_pardavila · Accepted solution]

Hi Alex

But i was suppose that a query is a conexion between tables!!! what can i do in selection options in SQ02? Normally i choose a selection screen and the layout in SQ02 where can i customize the selection options? is selection criterion that you are talking about?

thank you for reply

[Former Member · Accepted solution]

Hi, it called 'additional' feature, read here http://help.sap.com/saphelp_47x200/helpdata/en/d2/cb41fb455611d189710000e8322d00/frameset.htm (in Infoset). You need basic knowledge of abap

[Former Member · Accepted solution]

Hi, it called 'additional' feature, read here http://help.sap.com/saphelp_47x200/helpdata/en/d2/cb41fb455611d189710000e8322d00/frameset.htm (in Infoset). You need basic knowledge of abap

And this

Also if you need eg select by customer, you can select LFA1 from BSID and BSAD.

[iklovski · Accepted solution]

Hi,

Base your query on a pre-defined logical database ot build an ABAP report. What you are asking is to unite BSID and BSAD, not to join them, in terms of SQL and that would be impossible (to my knowledge) via SQVI.

Regards,

Eli

[Former Member]

Hi, use in Join left outer join function

[adrian_pardavila]

Hi Alex

thank for reply

What do you mind? In SQ02 Join definition , Join conditions??

Regards,

[adrian_pardavila]

My join conditions are correct ( that said SAP when i check it )

[Former Member]

Hi,

'My join conditions are correct'-may be, but it's correct from Syntaxes point of view.

Try change condition and check

[Former Member]

Hi,

'My join conditions are correct'-may be, but it's correct from Syntaxes point of view.

Try change condition and check