SAP ABAP 提供了一个表 ,随意找另一个表进行JION 。 我是初学者 如何编写。 谢谢 ~~

来源:百度知道 编辑:UC知道 时间:2024/09/21 00:49:15

SELECT mara~matnr marc~werks marc~lvorm
marc~werks mara~meins makt~maktx
marc~xchpf
INTO TABLE it_data1
FROM mara
INNER JOIN marc
ON mara~matnr = marc~matnr
INNER JOIN makt
ON marc~matnr = makt~matnr
WHERE mara~matnr IN p_matnr
AND marc~werks IN p_werks
AND marc~prctr IN p_prctr
AND mara~mtart IN p_mtart
AND marc~lvorm IN p_lvorm
AND makt~spras = sy-langu .