Objective – able to create simple SAP query
Why do we need SAP query
Pre requisitie
Transaction – Codes
Why we need SAP query
- No need of technical consultants
- User can create report as per his/her requirement
- Offers flexibility
Pre-requisite
- SAP Tables
- Material master – MARA, MARC, MBEW
- Vendor master – LFA1, LFB1, LFM1
- Purchase order tables – EKKO, EKPO, EKBE
Transaction codes:
- SQ03 – create/change/display user group
- SQ02 – create/change/display infoset
- SQ02 – assign infoset to user group
- SQ01 – create/change/display query
- SQVI – quick view for own use (no use of SQ01, SQ02, SQ03)