Top "Opensql" questions

Open SQL is used for SAP database access in the ABAP programming language.

Most efficient way to select data set conditional upon each other from multiple tables

I have an internal table like: TYPES: BEGIN OF gty_min_jobs, orgeh TYPE zgerpt_rnk_min-orgeh1, mnsty TYPE zgerpt_…

inner-join abap opensql
SELECT FOR ALL ENTRIES vs LOOP SELECT SINGLE in ABAP

I am comparing the SELECT FOR ALL ENTRIES vs LOOP SELECT SINGLE and I am having a big difference between …

loops select abap opensql
Multiple conditions in a SELECT statement?

First off, I have no experience with ABAP, I'm operating on guesswork here. I want to add a condition to …

abap opensql
GROUP by aggregation does not calculate SUM

I have to aggregate in my query SUM of AMUNT field according to WERKS, DATUM and UZEIT I try to …

abap opensql
How to get row count of database table

I am just new in abap language and I am trying to practice an inner join statement but I don't …

abap opensql
sy-datum low and high definitions

I have an ABAP program with below sample code which should select data from an SAP table based on a …

abap opensql
Selecting MAX over multiple dependent fields

Here's a sample of the data I wish to select from in the AFRU table. +----------------------+-----------------+-------------------------+ | Confirmation (RUECK) | …

abap opensql
How to include multiple conditions in a SELECT?

I am using 5 Parameters to fetch the details from DB table (mara, makt, marc, mard). PARAMETERS :number TYPE matnr MATCHCODE …

where-clause abap opensql sap-selection-screens
Setting SELECT-OPTIONS manually?

I have a program that, among other things, retrieves data from table RESB based on the bdter field, a DATS …

abap opensql sap-selection-screens
Case-insensitive comparison in SELECT condition

In ABAP SQL can I ignore the case when comparing fields in the WHERE clause of a SELECT? SELECT * FROM …

abap opensql