Le coloque unos AND q le faltaba y coloqué la S y H entre comillas simple asi:
Código:
SELECT SAP.shkzg, Sum(SAP.wrbtr) - SAP.previews as Monto,
SAP2.shkzg, Sum(SAP2.wrbtr) - SAP2.previews as Monto2
FROM SAP.SAPR3.BSID SAP, SAP.SAPR3.BSID SAP2
WHERE SAP.mandt = '400' AND
SAP.bukrs = 'RICA' AND
SAP.kunnr = '0001298492' AND
SAP.shkzg = 'H' AND
SAP2.mandt = '400' AND
SAP2.bukrs = 'RICA' AND
SAP2.kunnr = '0001298492' AND
SAP2.shkzg = 'S'
GROUP By SAP.shkzg, SAP2.shkzg
Pero me da el siguiente error:
Código:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'SAP.SAPR3.BSID'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'SAP.SAPR3.BSID'.
Me señala la lína: SELECT SAP.shkzg, Sum(SAP.wrbtr) - SAP.previews as Monto,