SELECT a~belnr
,a~racct AS acct_a
,b~racct AS acct_b
,b~drcrk
,b~budat
,SUM( b~hsl ) AS hsl
,SUM( b~ksl ) AS ksl
FROM acdoca AS a INNER JOIN acdoca AS b ON ( a~belnr = b~belnr )
WHERE a~rldnr = @p_rldnr
AND a~rbukrs = @p_bukrs
AND a~gjahr = @p_gjahr
AND a~poper IN @so_monat
AND a~racct LIKE '0000413%'
AND ( b~racct LIKE '0000011%' OR
b~racct LIKE '0000515%' OR
b~racct LIKE '0000635%' )
GROUP BY a~belnr
,a~racct
,b~racct
,b~drcrk
,b~budat
INTO TABLE @DATA(t_belnrs).
,a~racct AS acct_a
,b~racct AS acct_b
,b~drcrk
,b~budat
,SUM( b~hsl ) AS hsl
,SUM( b~ksl ) AS ksl
FROM acdoca AS a INNER JOIN acdoca AS b ON ( a~belnr = b~belnr )
WHERE a~rldnr = @p_rldnr
AND a~rbukrs = @p_bukrs
AND a~gjahr = @p_gjahr
AND a~poper IN @so_monat
AND a~racct LIKE '0000413%'
AND ( b~racct LIKE '0000011%' OR
b~racct LIKE '0000515%' OR
b~racct LIKE '0000635%' )
GROUP BY a~belnr
,a~racct
,b~racct
,b~drcrk
,b~budat
INTO TABLE @DATA(t_belnrs).
Comments
Post a Comment