SAP Database - The Unofficial SAP Knowledge Base

Free Business and Tech Magazines and eBooks

ABAP Programs: Sample report with selection criteria

Print This Post Email This Post Written by admin on Jan 17th, 2008 | Filed under: ABAP Programs

REPORT ZSOURCE1801.
TABLES: CUSTOMERS, BOOKINGS.
PARAMETERS P_DATE TYPE D.
SELECT-OPTIONS S_NAME FOR CUSTOMERS-NAME.
SELECT * FROM CUSTOMERS
WHERE NAME IN S_NAME.
WRITE / CUSTOMERS-NAME.
SELECT * FROM BOOKINGS

WHERE ORDER_DATE = P_DATE
AND CUSTOMID = CUSTOMERS-ID.
WRITE: / BOOKINGS-CARRID,
BOOKINGS-CONNID,
BOOKINGS-FLDATE.
ENDSELECT.
ENDSELECT.

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

  1. ABAP Programs: Using Internal Tables for Selection Criteria REPORT ZSOURCE1112.* Work areasTABLES: CUSTOMERS, BOOKINGS.* Internal tablesDATA: ALL_CUSTOMERS LIKE CUSTOMERS OCCURS 100 WITH HEADER LINE, ALL_BOOKINGS LIKE BOOKINGS OCCURS 500 [...]...
  2. ABAP Programs : Using the events start-of-selection and end-of-selection REPORT ZSOURCE1503. * Work area TABLES BOOKINGS. * Initial processing START-OF-SELECTION. WRITE / ‘Start’. * Reading data GET BOOKINGS. WRITE: AT /3 BOOKINGS-FLDATE. * Final processing END-OF-SELECTION. WRITE / ‘Finished’....
  3. ABAP Programs: Dynamic sort command with several sort criteria REPORT ZSOURCE2302. * Parameters for the sort criterion, can be modified by the end user PARAMETERS: COLUMN1(10)          DEFAULT ‘NAME’, COLUMN2 LIKE COLUMN1 DEFAULT ‘ID’. * Declarations for later use TABLES...
  4. ABAP Programs:Sample dialog program (flight reservation) * This program source contains all modules and subroutines of the * flight reservation program, but screen and GUI status definitions * are not included. *&———————————————————————* *&———————————————————————* *& Include MSABBTOP...
  5. ABAP Programs:Displaying the selection screen 1 2 3 4 5 6 7 8 9 10 REPORT ZSOURCE1803. * Work area TABLES CUSTOMERS. * Selection criteria SELECT-OPTIONS S_NAME FOR CUSTOMERS-NAME. * running chap1801 and displaying...



This website uses IntenseDebate comments, but they are not currently loaded because either your browser doesn't support JavaScript, or they didn't load fast enough.

Leave a Reply

  • Subscribe to RSS

  • Free Ebooks