지금 BKPF 테이블과 BSEG테이블을 INNER JOIN 할려구 합니다.
구문은 SELECT * INTO CORRESPONDING FIELDS OF TABLE IT_MERGE
FROM BKPF AS A INNER JOIN
BSEG AS B ON A~MANDT = B~MANDT
AND A~BELNR = B~BELNR
WHERE B~BUKRS = P_BUKRS
AND B~GJAHR = P_GJAHR
AND B~BELNR = S_BELNR.
이렇게 작성하였는데 체크해보면
For pooled tables, cluster tables and projection views, JOIN is not allowed: "BSEG".
이런 에러 메세지가 뜨는데 BSEG는 조인이 안되는건가요?
Cluster Table
Database table defined in the ABAP Dictionary, whose version on the database is not only assigned to one table defined in the ABAP Dictionary. Several cluster tables are assigned to a table cluster in the database. The intersection of the key fields of the cluster tables forms the primary key of the table cluster. The other columns of the cluster tables are stored in compressed form in a single column VARDATA of the table cluster. You can access cluster tables only via Open SQL, and only without using joins.