Skip to Content
0
Former Member
May 13, 2008 at 09:31 AM

select upto

20 Views

Hi,

I want to select one row in table vbfa depending on invoice number.

Since invoice number is one of the primary fields, query will return multiple rows.

Now i want to select any one row and depending on another key fields value I want to write logic.

Eg.

Select * from vbfa into ws_vbeln where vbeln = ws_vbeln upto 1 rows.

If vbfa-vbtrp_n = 'A' .......

Is this okay.