**Somtimes ABAP developer wants to access cross-client data from developement work-space. **In order to access cross-client data we can use below ABAP open SQL statements ...

This cheat sheet summarizes the functions ABAP SQL offers together with ABAP CDS for working with hierarchical data that is stored in database tables. Hierarchical data in database tables means that ...

Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored ...