NAVAPAT_T

ABAP : Iner join

Jul 24th, 2017
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
ABAP 0.46 KB | None | 0 0
  1. TABLES: ZPAT_STUDENT,ZPAT_SUBJECT.
  2. DATA it_student type zpat_student OCCURS 0 WITH HEADER LINE.
  3. DATA: st_name type zpat_student-name,
  4.       st_grade type zpat_student-grade,
  5.       st_subject type zpat_subject-subject.
  6. write: 'name',20 'grade',30 'subject'.
  7. SELECT a~name a~grade b~subject
  8.   into (st_name, st_grade, st_subject)
  9.   from ZPAT_STUDENT as a INNER JOIN zpat_subject as b
  10.   on a~grade = b~grade.
  11.   WRITE: / st_name, 20 st_grade, 30 st_subject.
  12. ENDSELECT.
Advertisement
Add Comment
Please, Sign In to add comment