The select B.A UFNR, A.K TEXT, B.M ATNR, c. AKTX, B.S AKNR, which XT20, B.Z SL, B.Z FYJE,
The sum (f. may ENGE), sum (f.D MBTR * decode (f.s HKZG, 'S', '1', '1'))
The from
Z_AFPO_RFC_ZZAUFK a
Left the JOIN Z_ZZFIT013_RFC b ON A.A UFNR=B.A UFNR
Left the JOIN Z_MAKT_RFC c ON B.M ATNR=c. ATNR
Left the JOIN Z_SKAT_RFC d ON B.S AKNR=D.S AKNR
Left the JOIN Z_ZMARA_RFC e ON B.M ATNR=E.M ATNR
Left the JOIN Z_ZMSEG_RFC f ON B.A UFNR=F.A UFNR
Where A.A UART in (' Z600 ', 'Z500', 'Z600)
AND D.K TOPL='1000'
AND group by f. may ATNR

CodePudding user response:

Too little aggregate function or the group by too little

CodePudding user response:

The select B.A UFNR,
A.K TEXT,
B.M ATNR, c. AKTX,
- should be half Angle comma (in English)
B.S AKNR,
Which XT20,
B.Z SL,
B.Z FYJE,
The sum (f. may ENGE),
The sum (f.D MBTR * decode (f.s HKZG, 'S', '1', '1'))
The from Z_AFPO_RFC_ZZAUFK a
Left the JOIN Z_ZZFIT013_RFC b
ON A.A UFNR=B.A UFNR
Left the JOIN Z_MAKT_RFC c
ON B.M ATNR=c. ATNR
Left the JOIN Z_SKAT_RFC d
ON B.S AKNR=D.S AKNR
Left the JOIN Z_ZMARA_RFC e
ON B.M ATNR=E.M ATNR
Left the JOIN Z_ZMSEG_RFC f
ON B.A UFNR=F.A UFNR
Where A.A UART in (' Z600 ', 'Z500', 'Z600)
AND D.K TOPL='1000' AND lack of condition
Group by f. may ATNR, put the non-cohesive column up