ABAP Programs: A simple query

1
2
3
4
5
6
7

REPORT ZSOURCE1101.
* Work area for a database table
TABLES CUSTOMERS.
* Reading all entries of the database table
SELECT * FROM CUSTOMERS.
WRITE: / CUSTOMERS-NAME.
ENDSELECT.

If you like this post, you may as well like these too:

1. ABAP Programs: Ordering query results 1 2 3 4 5 6 7 8 9 REPORT ZSOURCE1108. * Work area TABLES CUSTOMERS. * Reading table entries in a specified order SELECT * FROM CUSTOMERS ORDER BY...
2. ABAP Programs: Simple Form REPORT ZSOURCE1001. * Global field of the programDATA FLAG VALUE ‘G’.* Displaying the global fieldWRITE FLAG.* Calling a formPERFORM SET_FLAG.* Displaying the global field againWRITE FLAG.* Defining a formFORM SET_FLAG.*...
3. ABAP Programs: A simple internal table REPORT ZSOURCE1201.* Work area for a database tableTABLES CUSTOMERS.* Defining an internal tableDATA ALL_CUSTOMERS LIKE CUSTOMERS OCCURS 100.* Reading all entries of the database table into the internal tableSELECT *...
4. ABAP Programs: Simple examples of field conversion REPORT ZSOURCE0702. * Converting to numbers during computationsDATA: NUMBER_1(4) VALUE ’1771′, NUMBER_2(3), RESULT TYPE I. NUMBER_2 = ’005′.RESULT = NUMBER_1 + NUMBER_2.WRITE / RESULT. NUMBER_2 = ‘ 5′.RESULT = NUMBER_1...
5. What is SAP Query or ABAP Query? ABAP Query (also known as an SAP Query or Query) is a powerful tool used to generate simple reports without any coding. Typically, an ABAP query is  created first by...
6. ABAP Source Code: Syntax of ABAP/4 Programs 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 * Declaration...
7. SAP Query Reporting Download Here...
8. Convert Quick View into a Query The Quick View reports can easily be converted into SAP Queries. To do this, choose first the query group that you are assigned to and that you will want to...
9. Query Based Taxonomies It is impossible to centralize all the information in a single repository so the Knowledge management provides A unified view, taxonomies and set of common services. on top of heterogeneous...
10. Source Code: Few simple examples 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30...
11. ABAP Programs: Exporting to the ABAP/4 Memory REPORT ZSOURCE1401. * Work areas TABLES: CUSTOMERS, BOOKINGS. * Internal tables which will be exported DATA: ALL_CUSTOMERS LIKE CUSTOMERS OCCURS 100 WITH HEADER LINE, ALL_BOOKINGS LIKE BOOKINGS OCCURS 10 WITH...
12. ABAP Programs: Importing from the ABAP/4 Memory REPORT ZSOURCE1402. * Internal tables which will be imported DATA: ALL_CUSTOMERS LIKE CUSTOMERS OCCURS 100 WITH HEADER LINE, ALL_BOOKINGS LIKE BOOKINGS OCCURS 10 WITH HEADER LINE, NEW_BOOKINGS LIKE BOOKINGS OCCURS...
13. Simple ALV Report – Details of Y or Z Objects 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30...
14. List of Infotypes configured in the SAP system – Simple ALV report 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30...
15. Some Cool Programs in ABAP and the link is :- http://www.kabai.com/abaps/q.htm...