about queryviz
SAP data shouldn't be this hard to work with
if you've worked on SAP projects, you know the drill. open SE11, search for a table, get a field list with no context, cross-reference an outdated SAP help article, ask a colleague who might remember the join, find a forum post from 2009 that half-answers your question. repeat.
the problem
SAP's data model is one of the most complex in enterprise software. thousands of tables, cryptic field names, multi-column join keys, and subtle gotchas like MANDT handling, deletion indicators, and document status fields that experienced SAP practitioners eventually learn, but the documentation rarely explains properly.
the knowledge exists. it's scattered across tribal docs, old forum posts, BI team notes, and years of project work. but there's no single place that makes it instantly visible when you're mid-project and need the answer now, not in two hours.
on every project, someone burns half a day writing a query that a more experienced colleague could have put together in five minutes. that's what queryviz fixes.
what queryviz does
queryviz is a reference and productivity tool for SAP data professionals. it maps the relationships between SAP tables (the joins, the key fields, the business context) and turns that into production-ready SQL and ABAP queries.
search for a table by name or description, see how it connects to related tables, check what changed in S/4HANA, and generate a correct multi-table query with MANDT handling, deletion indicator filters, and inline comments explaining every join. takes seconds.
who built this
queryviz was built by a data engineer working in a BI role who ends up meddling with SAP data day to day. it started from a simple need: see SAP table relationships and query paths visually instead of piecing them together from SE11, old documentation, and memory. the tables here are the ones that actually show up in real reporting and extraction work (EKKO, BKPF, VBAK, ACDOCA), not a bulk dump of every SAP table in existence.
the query templates are shaped by hands-on reporting and extraction work. they focus on the filters that matter, the joins that need special handling, and the common mistakes that waste time when you're trying to move from “which table is it?” to “give me the query.”
the S/4HANA mappings reflect the practical questions that come up when you support reporting across ECC and S/4HANA. BSEG moving to ACDOCA, vendor and customer master becoming Business Partner, MSEG becoming MATDOC, VBUP being eliminated. not abstract documentation summaries, but the changes that matter when you're trying to understand what moved where.
if queryviz saved you project time, you can support the build
some people will subscribe, some just want to say thanks. if you want a lightweight way to back the independent work behind queryviz, a coffee helps keep the research and template writing going.
how it compares
we asked the SAP community on Reddit what tools they use to research tables and build queries. queryviz is the only option that's fast, visual, cross-module, and doesn't require SAP system access.
see the full comparison →where it's going
queryviz is early stage and actively developed. the current focus is expanding query templates for the most common SAP reporting scenarios across MM, FI, SD, and PP, and improving the visual query builder. next up is more module coverage and a shareable query library. feedback from SAP professionals directly shapes what gets built next.
changelog
queryviz ships updates frequently. here's what's changed recently.
view full changelog →buy me a coffee
if queryviz saves you time, consider supporting the project