Getting started with SAP Query: Select data without ABAP programming

Опубликовано: 27 Июнь 2023
на канале: ERP UP
6,778
61

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_...


Смотрите видео Getting started with SAP Query: Select data without ABAP programming онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь ERP UP 27 Июнь 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 6,778 раз и оно понравилось 61 людям.