Skip to Content
Feb 09, 2022 at 12:20 AM

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


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?