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.