Need logic for WHERE-clause
I have a selet statement where i need to write below logic .
SELECT bldat xblnr kunnr rstgr xref1 xref2
bukrs belnr blart wrbtr waers shkzg
buzei zfbdt dmbe2 sgtxt augbl augdt
INTO CORRESPONDING FIELDS OF TABLE int_output
WHERE bldat IN so_bldat AND
shkzg IN so_shkzg AND
wrbtr IN so_wrbtr.
Range needs to be entered where from value (for wrbtr field) is
-ve negative and to value is +ve positive e.g., -1000 to +200 -:in this case go to BSID with value from 0 to 1000 with debit/credit indicator H and again 0 to 200 with debit/credit indicator S..
can somebody tell me how to set range for the above requirement.
Really need help.
Edited by: Thomas Zloch on May 25, 2011 3:27 PM