ABAP Programs: Sample report with selection criteria
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:
- 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 WITH HEADER LINE.* Reading entries from both database...
- ABAP Programs: Selection screen events REPORT ZSOURCE1603 MESSAGE-ID SU. * Worka area TABLES CUSTOMERS. * Selection criteria PARAMETERS PCODE LIKE CUSTOMERS-POSTCODE. SELECT-OPTIONS S_NAME FOR CUSTOMERS-NAME. * Variables DATA: PARAMETER_LENGTH TYPE I, NUMBER_OF_SELECTIONS TYPE I....
- ABAP Programs:Displaying the selection screen REPORT ZSOURCE1803. * Work area TABLES CUSTOMERS. * Selection criteria SELECT-OPTIONS S_NAME FOR CUSTOMERS-NAME. * running chap1801 and displaying the selection screen SUBMIT CHAP1801 VIA SELECTION-SCREEN WITH P_DATE =...
- ABAP Programs: Using select statements REPORT ZSOURCE1501. * Work areas TABLES: CUSTOMERS, BOOKINGS. * Reading data SELECT * FROM CUSTOMERS. WRITE / CUSTOMERS-NAME. SELECT * FROM BOOKINGS WHERE CUSTOMID = CUSTOMERS-ID AND FLDATE >...
- 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 /...
Leave a Reply