Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Inner join on four tables

hi all,

i am facing the problem with the inner join in the select query for 4 tables.

can i use the inner join for tables in SAP 6.0 version,

it is going to dump.

here is my code

SELECT DISTINCT apernr abegda aendda awagetype aamount acurrency

altrctry brufnm banred bvorna bnachn cgroupcode d~vdsk1

FROM pa9011 AS a INNER JOIN pa0002 AS b ON bpernr = apernr

INNER JOIN pa9013 AS c ON cpernr = bpernr

inner join pa0001 as d on dpernr = cpernr

INTO CORRESPONDING FIELDS OF TABLE it_bonus

WHERE a~pernr IN s_pernr AND

a~begda IN s_date AND

a~subty EQ s_subty AND

a~wagetype EQ wa_perbonus AND

a~ltrctry = gc_ind AND

a~amount > 0 AND

b~endda = '99991231' AND

c~groupcode IN s_loc AND

c~endda = '99991231' and

d~endda = '99991231'

ORDER BY a~pernr.

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question