SQVI using FBL5N, VBAK, VBAP & VBRP data

[Former Member]

I am trying to build a SQVI report using the FBL5N data (BSID and BSAD tables) and the VBAK data.  However I cannot find a way to line the tables. I would like to add the data from the VBELN, AUART and VGBEL fields, along with a custom field, from the VBAK data to the BSID and BSAD tables. The end result is that I would like the data from FBL5N to include these fields from the VBAK table. Ideally I would like to link, BSID, BSAD and VBAK together.  I feel I may need another table or 2 to complete the circuit, is there a way to do this?  If I can get this link down I can probably add the info from VBAP and VBRP.  Thanks.

[former_member188493 · Accepted solution]

Does your question have anything to do with SQL Anywhere?

[Former Member · Accepted solution]

No, I am just trying to build a query in quickviewer (SQVI).  I don't work in SQL at all. I am basically an end user with quickviewer access.  Thanks.

[former_member188493 · Accepted solution]

OK, then... you will have better luck in some other forum. This forum is dedicated to the SAP product called "SQL Anywhere".

[Former Member · Accepted solution]

Thank you, will look elsewhere. I apologize, new to this forum.