Getting started with SAP Query: Select data without ABAP programming
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, modified 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 records.
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.
Like, comment and subscribe. Thank you for your support :)
▬ Content ▬▬▬▬▬▬▬▬▬▬▬▬
00:00 - Intro
00:13 - Create User Group
01:37 - Create InfoSet
06:44 - Create SAP Query
10:02 - Outro
▬ Music Intro/Outro ▬▬▬▬▬▬▬▬▬▬▬▬
Depth Fuse - French Fuse
Feels - Patrick Patrikios
▬ Useful links ▬▬▬▬▬▬▬▬▬▬▬▬
German Blog: https://erp-up.de/blog/
My book recommendations: https://erp-up.de/book-recommendation...
100 Tips and Tricks in SAP ERP: https://www.udemy.com/course/100-tips...
Support ERP UP: https://erp-up.de/support-erp-up/
Support ERP UP over Amazon: https://amzn.to/3f40uSG
PayPal-Donation: https://www.paypal.com/paypalme/andre...
Linkedin: / andreas-geiger
Xing: https://www.xing.com/profile/Andreas_...
Watch video Getting started with SAP Query: Select data without ABAP programming online without registration, duration hours minute second in high quality. This video was added by user ERP UP 27 June 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6,778 once and liked it 61 people.