如何在SAP ABAP中基于两列联接两个表

Question

我有两个表ACDOCA和BKPF。这两列分别是GJAHR和BUKRS。我想基于这两列来连接这两个表。select语句的代码是什么？

我做到了：

FROM acdoca AS a
LEFT OUTER JOIN bkpf AS b
ON a~rbukrs = b~bukrs
ON a~gjahr = b~gjahr

在激活时，它显示错误"ON"；是此处无效(由于语法原因(">

请帮忙。

Answer 1

第二个"ON"；必须用"；AND"：

FROM acdoca AS a 
LEFT OUTER JOIN bkpf AS b 
ON a~rbukrs = b~bukrs AND " => here
a~gjahr = b~gjahr

https://help.sap.com/doc/abapdocu_751_index_htm/7.51/de-DE/abapselect_join.htm#！ABAP_ONE_ADD@1@