topic Re: Problem in select query in Application Development and Automation Discussions

Problem in select query

former_member508729 — Mon, 08 Jun 2009 03:04:30 GMT

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.

Re: Problem in select query

Former Member — Mon, 08 Jun 2009 03:13:01 GMT

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.

Re: Problem in select query

Former Member — Mon, 08 Jun 2009 03:28:43 GMT

Hi,

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

Else unexpected errors will come.

Thanks,

Krishna..