Advertisement
NAVAPAT_T

ABAP : innerjoin with HIDE(find subject)

Jul 21st, 2017
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
ABAP 0.69 KB | None | 0 0
  1. TABLES: ZPAT_SUBJECT,ZPAT_STUDENT.
  2. TOP-OF-PAGE.
  3. WRITE: / 'NAME', 20 'SCORE', 40 'SUBJECT'.
  4. START-OF-SELECTION.
  5. SELECT * FROM ZPAT_student.
  6.   WRITE: / ZPAT_STUDENT-NAME,
  7.          20 ZPAT_STUDENT-SCORE.
  8.   HIDE : ZPAT_STUDENT-NAME, ZPAT_STUDENT-SCORE,zpat_student-grade.
  9.   ENDSELECT.
  10. AT LINE-SELECTION.
  11.   SELECT * FROM ZPAT_SUBJECT
  12.   WHERE grade  = zpat_student-grade.
  13.     WRITE: / 'NAME', 20 'SCORE', 40 'SUBJECT'.
  14.     WRITE: / zpat_student-NAME,
  15.            20 zpat_student-score,
  16. *           40 zpat_subject-grade.
  17.            40 zpat_subject-subject.
  18.     ENDSELECT.
  19.    CLEAR: zpat_student-NAME,
  20.           zpat_student-score,
  21.           zpat_student-grade,
  22.           zpat_subject-subject.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement