Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

zbd1t zbd2t

FROM bsid


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

Not what you were looking for? View more on this topic or Ask a question