Sample:
SELECT
vbak~vbeln,
vbak~kunnr,
vbak~vdatu,
vbap~matnr,
vbap~wrf_charstc1,
vbap~vstel,
vbap~werks,
vbap~kwmeng,
mara~satnr,
CAST( ‘ ‘ AS CHAR( 70 ) ) AS atwrt
INTO TABLE @DATA(lt_so)
FROM vbap
INNER JOIN vbak ON vbap~vbeln = vbak~vbeln
INNER JOIN mara ON vbap~matnr = mara~matnr
WHERE vbak~auart IN ( ‘ZGW1’,‘ZGW2’ )
AND vbak~autlf = ”
AND vbap~werks IN @lt_r_werks
AND vbap~matnr IN @lt_r_matnr
AND vbap~pstyv IN ( ‘ZGW1’,‘ZGW2’ )
AND vbap~lfgsa <> ‘C’
.