Advertisement
Kenzuke

Lineselection

Jan 26th, 2020
758
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
ABAP 1.43 KB | None | 0 0
  1. DATA:
  2.   count TYPE i VALUE 0,
  3.   sc    TYPE scustom,
  4.   sb    TYPE sbook,
  5.   sr    TYPE scarr,
  6.   sp    TYPE spfli.
  7.  
  8. TOP-OF-PAGE.
  9.   ULINE (140).
  10.   WRITE: / '|', (10)'Kunden ID', '|', (15)'Kunde', '|', (14)'Strasse', '|', (12)'Postleitzahl', '|', (14)'Ort',
  11.            '|', (12)'Buchungs-Nr.', '|', (16)'Fluggeselschaft', '|', (10)'FLugnummer', '|', (9)'Flugdatum', '|'.
  12.   ULINE /(140).
  13.  
  14. START-OF-SELECTION.
  15.   SELECT * FROM  scustom INTO sc.
  16.     SELECT * FROM sbook INTO sb
  17.              WHERE customid = sc-id.
  18.       WRITE: / '|', (10)sc-id, '|', (15)sc-name, '|', (14)sc-street, '|', (12)sc-postcode, '|', (14)sc-city,
  19.                '|', (12)sb-bookid, '|', (16)sb-carrid, '|', (10)sb-connid, '|', (9)sb-fldate, '|'.
  20.       HIDE: sb-carrid, sb-connid.
  21.     ENDSELECT.
  22.     IF sy-dbcnt > 0.
  23.       count = count + 1.
  24.     ENDIF.
  25.  
  26.   ENDSELECT.
  27.  
  28.   ULINE /(140).
  29.   WRITE: / '|', 'Anzahl der Kunden: ', count, (104)' ', '|'.
  30.   ULINE /(140).
  31.  
  32. END-OF-SELECTION.
  33.  
  34. TOP-OF-PAGE DURING LINE-SELECTION.
  35.   WRITE:  'Flugdetails:'.
  36.   ULINE /.
  37.  
  38. AT LINE-SELECTION.
  39.   IF sy-lsind = 1.
  40.     SELECT * FROM spfli INTO sp
  41.              WHERE carrid = sb-carrid AND
  42.                    connid = sb-connid.
  43.       SELECT * FROM scarr INTO sr
  44.                WHERE carrid = sb-carrid.
  45.         WRITE: /'Fluggesellschaft:', sr-carrname,
  46.                /'Abflugort:', sp-cityfrom,
  47.                /'Zielort:', sp-cityto.
  48.       ENDSELECT.
  49.     ENDSELECT.
  50.   ENDIF.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement