RE:[sap-dev] Problem with SELECT statement and JOIN into internal table
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by pursegad (Technical Consultant) on Aug 25 at 8:26 PM |  Mark as helpful |
Hi.
The problem maybe in the where clause of your select statement. ..AND B~STAT = 'E*' probably should be ..AND B~STAT LIKE 'E%'. As this will retrieve details where JEST-STAT is equal to anything starting with E instead of where JEST-STAT is exactly equal to E*.
Hope this helps.
Cheers,
Alan Purseglove
__.____._ The problem maybe in the where clause of your select statement. ..AND B~STAT = 'E*' probably should be ..AND B~STAT LIKE 'E%'. As this will retrieve details where JEST-STAT is equal to anything starting with E instead of where JEST-STAT is exactly equal to E*.
Hope this helps.
Cheers,
Alan Purseglove
Copyright © 2009 CEB Toolbox, Inc. and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
White Papers
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
