Sorry in advance for what is probably a very basic question. Our company's conversion to SAP is still brand new, so my experience with SAP is still quite limited. I'm an analyst accustomed to being able to run SQL queries on our master data for auditing and reporting purposes. It seems like it's not that simple in SAP. I discovered the SQVI tcode which allows me to build very basic queries, but what if I would like something more robust? Would SQ01 and SQ02 be what I need? I don't have access to them currently so I can't play around, but I can look into gaining access if needed.
Here is an example of something I would like to be able to do. I would like to run a query on customers to find out which customers aren't tied to a sales representative. If I were able to write a simple SQL query for this, it would look like:
select a.*
from KNA1 a
left outer join KNVP b on a.KUNNR = b.KUNNR and b.PARVW = 'PE'
where b.KUNNR is null
I can't figure out how to do this in SQVI for anything. I can create outer joins but not complicated selection criteria. Would this be easy to do in SQ01? In my perfect world, there would be a transaction in which I could write my own SQL query like this, but I'm rather sure no such screen exits. Thanks in advance for any advice.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.