208 tables · 110 cds views · 6 modules · live database

the fastest way to understand
SAP data, especially during S/4HANA projects

stop digging through SE11 and outdated forum posts. queryviz gives you table relationships, join logic, and production-ready queries so you can move faster on every project.

start free →view S/4 migration maps

⌘ K

tryekko mara bkpf

what SAP professionals are saying · from r/SAP on Reddit

“This is beautiful. This will help my team significantly as I'm only just beginning to teach them how to query the data in S4.”

u/Skrublord666

“I personally love the idea and would be interested in it. Triple extra points if we could somehow link this to the CDS views.”

u/ExitThruGiftShop

“There used to be something similar forever ago when I started out in 2015. Miss it dearly.”

u/alyssapoppy

“This is a great start! Bookmarking for the future as a SAP data guy. Good work so far!”

u/nemosluckyfin17

“This look really helpful thanks for spending the time on it.”

u/Wilson1981h

“Would like to see the result.”

u/GeRRiT1986

“This is beautiful. This will help my team significantly as I'm only just beginning to teach them how to query the data in S4.”

u/Skrublord666

“I personally love the idea and would be interested in it. Triple extra points if we could somehow link this to the CDS views.”

u/ExitThruGiftShop

“There used to be something similar forever ago when I started out in 2015. Miss it dearly.”

u/alyssapoppy

“This is a great start! Bookmarking for the future as a SAP data guy. Good work so far!”

u/nemosluckyfin17

“This look really helpful thanks for spending the time on it.”

u/Wilson1981h

“Would like to see the result.”

u/GeRRiT1986

“This is beautiful. This will help my team significantly as I'm only just beginning to teach them how to query the data in S4.”

u/Skrublord666

“I personally love the idea and would be interested in it. Triple extra points if we could somehow link this to the CDS views.”

u/ExitThruGiftShop

“There used to be something similar forever ago when I started out in 2015. Miss it dearly.”

u/alyssapoppy

pick a template. fill in parameters. get the query.

20 production-ready query templates covering procurement, sales, finance, and inventory. each one handles MANDT, deletion indicators, and proper joins.

open purchase orders with GR/IR status

free

MMFIEKKO → EKPO → EKBE

SQLABAP

params:company code: 1000date from: 2024-01-01date to: 2024-12-31

SELECT
  EKKO.EBELN,          -- PO Number
  EKKO.BUKRS,          -- Company Code
  EKKO.LIFNR,          -- Vendor
  EKPO.EBELP,          -- PO Item
  EKPO.MATNR,          -- Material
  EKPO.MENGE,          -- Quantity
  EKBE.BEWTP,          -- GR/IR Category
  EKBE.MENGE AS GR_QTY -- GR Quantity
FROM EKKO
INNER JOIN EKPO
  ON EKKO.MANDT = EKPO.MANDT
  AND EKKO.EBELN = EKPO.EBELN
LEFT JOIN EKBE
  ON EKPO.MANDT = EKBE.MANDT
  AND EKPO.EBELN = EKBE.EBELN
  AND EKPO.EBELP = EKBE.EBELP
WHERE EKKO.MANDT = '100'
  AND EKKO.LOEKZ = ''     -- not deleted
  AND EKPO.LOEKZ = ''     -- not deleted
  AND EKKO.BUKRS = '1000'
  AND EKKO.BEDAT BETWEEN '2024-01-01'
                       AND '2024-12-31'
ORDER BY EKKO.EBELN, EKPO.EBELP;

20 templates like this. 4 free, 16 with pro.

explore all templates →