Master SAP Query: Extract data without ABAP
20 videos • 32,320 views • by ERP UP SAP Query allows you to create list output from database tables in SAP ERP or SAP S/4HANA without ABAP programming knowledge. SAP Query supports different types of reports: Simple lists, statistics, and ranked lists. Using transaction SQ01, you can execute, create, modify, or delete the outputs (SAP queries). The basis of each SAP Query is an InfoSet. In transaction SQ01, you can manage Infosets via "Environment - InfoSets" or directly via transaction SQ02. Infosets consist of one or more different database tables (joins). To be able to create and use SAP queries, you must first create the appropriate Infoset. But Infosets alone are not enough to create SAP queries. You must also create a user group. These can also be created, changed or even deleted in transaction SQ01 via "Environment - User Groups" or directly in transaction SQ03. A user group separates different application areas and assigns the corresponding data sets. SAP queries can be assigned to a standard or global area. Lists can be created and managed without ABAP knowledge. It is also possible to include ABAP source code in SAP Query to map complex issues that are not possible with pure selections.