Hello,
Refer this code.
SELECT DISTINCT avbeln afkart avkorg avtweg afkdat bnetwr aknumv bwerks bmwsbp afksto
ckunnr akunag dname1 dstras dort01 dregio e~spart
ftrntyp fexgrp fexnum fexdat bvgbel baubel bmatnr bposnr bfkimg bgsber berdat blgort bkursk_dat akdgrp arfbsk abukrs
INTO CORRESPONDING FIELDS OF TABLE vvk
FROM ( vbrk AS a
INNER JOIN vbrp AS b
ON avbeln = bvbeln
JOIN likp AS c
ON bvgbel = cvbeln LEFT OUTER JOIN j_1iexchdr AS f
JOIN kna1 AS d
ON ckunnr = dkunnr
JOIN tspa AS e
ON bspara = espart
ON avbeln = frdoc )
WHERE ( a~vbeln IN s_bill )
AND a~fkart IN s_fkart
AND a~vkorg IN s_vkorg
AND a~vtweg IN s_vtweg
AND ( a~fkdat IN s_bdate )
AND a~kdgrp IN s_kdgrp
AND ( a~kunag IN s_kunag )
AND b~gsber IN s_gsber
AND b~matnr IN s_matnr
AND ( b~spara IN s_spart )
AND b~werks IN s_werks
AND ( b~lgort IN s_lgort )
AND ( c~kunnr IN s_kunnr ).
Performance wise no issue.
Aastha
Bluesky
