Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Problem in select query

former_member508729
Active Participant

‎06-08-2009 4:04 AM

0 Kudos

Hi Gurus,

I am selecting from EKBE table for all entries from table LIPS where I am passing VGBEL as selection parameter to EKBE and BEWTP as E. here case is for one delivery one line item is partially GRed hence generated 2 records in EKBE for line item say 50, and EBELN as 12345. Now when I select from this EKBE where ebeln as 12345 and bewtp as E I am only getting 5 records for not 6, where there are 2 records for line item 50

what could be the possible reason for not selecting both records of quantity 2 each but selecting 1 record of quantity 4.

2 REPLIES 2

Former Member

‎06-08-2009 4:13 AM

0 Kudos

Hi,

Since you're using for all entries sytanx, pls add one more unique key while selecting from EKBE that differentiate between the 2 records quantity 2.


Duplicate lines are automatically removed from the resulting set. If the internal table itab is empty, the whole WHERE statement is ignored and all lines in the database are put in the resulting set.

Best Regards,

Victor.

Former Member

‎06-08-2009 4:28 AM

0 Kudos

Hi,

Have you used all the primary keys when using for all entries.

Else unexpected errors will come.

Thanks,

Krishna..