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

Pre-requisite

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)