Stack Overflow
Stack Overflow

Questions tagged [opensql]

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

Presentation

ABAP SQL (named Open SQL before version 7.53), is a set of ABAP statements that performs operations like reads, modifies or deletes data in the SAP database. ABAP SQL is independent of the database system, so the syntax of the ABAP SQL is uniform for all the databases supported by SAP.

All ABAP SQL statements are passed to the database interface. The DB interface converts the ABAP SQL into native SQL and passes it on to the database.

ABAP SQL Description

  • SELECT : Reads data from database
  • INSERT : Inserts lines to database
  • UPDATE : Changes the contents of lines in database
  • MODIFY : Inserts lines into database or changes the contents of existing lines
  • DELETE : Deletes lines from database

Links

ABAP SQL (ABAP documentation)

A complete guide to OpenSQL statements (SAP Community Blog Post)

Related Tags

288 questions
-2
votes
1 answer

Why left outer join works like inner join on ABAP CDS view and a custom table?

I have created an ABAP CDS view using ACDOCA, BSID, MARA, MAKT and such tables. Now my CDS view contains list of customers along with their outstanding (FI) documents. Against these customers, FI documents and certain more parameters, I am…
user2997767
  • 25
  • 1
  • 5
-2
votes
5 answers

how to get the num of records from a table?

SELECT COUNT(*) AS NumberOfRecords FROM tableX; how do I convert this to sap ABAP
your friend
  • 11
  • 1
  • 1
  • 2
-3
votes
2 answers

Select statement with inner join is taking forever

(....) DATA: BEGIN OF g00 OCCURS 100, werks LIKE lqua-werks, lgort LIKE lqua-lgort, matnr LIKE lqua-matnr, charg LIKE lqua-charg, maktx LIKE makt-maktx, verme LIKE lqua-verme, …
mkilic2006
  • 11
  • 1
1 2 3
…
19
20