I have a select similar to the one below: SELECT DISTINCT SCARR~CARRID, SCARR~CARRNAME, MIN( SPFLI~DISTANCE ) AS MIN_DISTANCE FROM SCARR JOIN SPFLI ON SPFLI~CARRid = SCARR~CARRid GROUP BY SCA...

Are there general ABAP-specific tips related to performance of big SELECT queries? In particular, is it possible to close once and for all the question of FOR ALL ENTRIES IN vs JOIN?

In ABAP SQL can I ignore the case when comparing fields in the WHERE clause of a SELECT? SELECT * FROM some_table WHERE field1 = variable1. How can I compare field1 to variable1 ignoring differe...

Is it possible to retrieve the old or original values for a table when it has been changed, but not yet committed, in the current LUW? I'm implementing a BAdI that's supposed to be used to raise m...

in SQL it is usually possible to use literals in a select statement, e.g. like this SELECT 'I', 'EQ', table.alev_uuid FROM table Is there any chance to do this in an ABAP SQL query? what I tr...

Is there a way in ABAP's OpenSQL to simplify the select columns in a JOIN when I want to grab all the fields of one table but only selected fields from the other table(s)? For instance, in mysql w...

Suppose I have a database table representing a hierachical structure, with the following columns: id predecessor_id name Starting from a given ID, I have to be able to retrieve all child nodes ...

I'm trying to use this SELECT statement in ABAP: SELECT DISTINCT * FROM dbtab INTO CORRESPONDING FIELDS OF TABLE itab WHERE field1+7(16) IN s_field1 AND field2 IN s_field2. but I can't use o...

I want to fetch the a field say excep_point from a transparent table z_accounts for the combination of company_code and account_number. How can I do this in ABAP SQL? Assume that table structure i...