NAVAPAT_T

ABAP : Iner join with Internal table

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