Kenzuke

Lineselection

Jan 26th, 2020
399
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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.
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×