Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

SAP SQL Tables for VA05, VF05, ZOA, and UKM_BP

0 Kudos

I am a relatively new data analyst working with SAP. Typically I don't have much reason to leave BSID and BSAD tables, however, I've been asked to pull some OS&D information which requires me to build a model connecting the data found in the transactions FBL5N, VA05, VF05, ZOA, and UKM_BP.

The problem is, I'm not entirely sure where I can find all the base tables from these transactions. I have FBL5N down, but I could really use some help identifying the others. Here is what I've got so far...FBL5N - BSID/BSADVA05 - VBAP/VBAKVF05 - ??? Maybe VBRK. but I do not have this table in our SQL databaseZOA - ??? Can anyone help me out, or at least point me in the correct direction? Also, does anyone have any idea where I can find the Risk Class for a specific customer?
  • SAP Managed Tags:

Community Manager
Community Manager
0 Kudos

Hi, Ashley:

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with, as it provides tips for preparing questions that draw responses from our members. Feel free to take our Q&A tutorial at as well, as that will help you when submitting questions to the community.

For example, you can:

* Outline what steps you took to find answers (and why they weren't helpful).

* Share screenshots of what you've seen/done.

* Make sure you've applied the appropriate tags.

If you don't apply the correct tags, the right experts won't see your question to answer it.

Should you wish, you can revise your question by selecting Actions, then Edit.

The more details you provide, the more likely it is that members will be able to respond.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond:

Kind regards,


Moderation Lead

Make sure to subscribe to What's New!
  • SAP Managed Tags: