SAP Query – SQ01, SQ02, SQ03

Objective – able to create simple SAP query
Why do we need SAP query
Pre requisitie
Transaction – Codes

Why we need SAP query

  1. No need of technical consultants
  2. User can create report as per his/her requirement
  3. Offers flexibility


  1. SAP Tables
  2. Material master – MARA, MARC, MBEW
  3. Vendor master – LFA1, LFB1, LFM1
  4. Purchase order tables – EKKO, EKPO, EKBE

Transaction codes:

  1. SQ03 – create/change/display user group
  2. SQ02 – create/change/display infoset
  3. SQ02 – assign infoset to user group
  4. SQ01 – create/change/display query
  5. SQVI – quick view for own use (no use of SQ01, SQ02, SQ03)

Leave a Reply

Your email address will not be published. Required fields are marked *