Posted: Tue Oct 21, 2008 4:14 pm Post subject: Непонятки с SELECT SUM
Здравствуйте, почему первый селект возвращает sy-subrc = 0, а второй sy-subrc = 4 ?
Code:
DATA: l_netwr TYPE vbap-netwr.
SELECT SUM( p~netwr ) INTO l_netwr
FROM lips AS l
JOIN likp AS k ON k~vbeln = l~vbeln
JOIN vbuk AS u ON u~vbeln = l~vgbel
JOIN vbap AS p ON p~vbeln = l~vgbel
AND p~posnr = l~vgpos
WHERE k~fkdat LE pdate
AND k~kunnr EQ itab_ua-kunnr
AND u~wbstk EQ 'C'
AND u~fkstk NE 'C'.
Code:
DATA: l_netwr TYPE vbap-netwr,
sum TYPE vbap-netwr.
SELECT p~netwr INTO l_netwr
FROM lips AS l
JOIN likp AS k ON k~vbeln = l~vbeln
JOIN vbuk AS u ON u~vbeln = l~vgbel
JOIN vbap AS p ON p~vbeln = l~vgbel
AND p~posnr = l~vgpos
WHERE k~fkdat LE pdate
AND k~kunnr EQ itab_ua-kunnr
AND u~wbstk EQ 'C'
AND u~fkstk NE 'C'.
Age: 48 Joined: 25 Jan 2008 Posts: 580 Location: Москва
Posted: Wed Oct 22, 2008 2:43 pm Post subject:
Для функций агрегации SY-SUBRC всегда 0 вне зависимости, есть в таблице данные, удовлетворяющие условиям, или нет. В этом случае нужно смотреть значение переменной, в которую происходит суммирование.
Для SELECT .. ENDSELECT SY-SUBRC = 4, потому что не нашлось ни одной записи по заданным условиям. _________________ С уважением,
Удав.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
All product names are trademarks of their respective companies. SAPNET.RU websites are in no way affiliated with SAP AG. SAP, SAP R/3, R/3 software, mySAP, ABAP, BAPI, xApps, SAP NetWeaver and any other are registered trademarks of SAP AG. Every effort is made to ensure content integrity. Use information on this site at your own risk.
