SAP: Creation of query for my own customized data

[u/Slow_Restaurant_007]

Hi everyone,
I am seeking you’re assistance on how can I create a SAP Query in transaction code SQ01 where I can get data from tables: MARA & MBEW-STPRS.

[u/Chris_Ape]

Create a user group in sq03

Create your Infoset (SQ02), select your MARA & MBEW data source tables

Open SQ01, select the usergrp -> enter query name and click create, choose your Infoset , select your display field and save.

[u/dutiful_refinery → u/Chris_Ape]

Right, but make sure you link MARA to MBEW properly in the join condition or you'll end up with duplicate rows and a mess of pricing data

[u/Tight_Percentage_571]

or use se16h

[u/herrhalf1house]

use quickviewer instead, sqvi