Ansicht
Dokumentation
ABENOO_OBS_SQL_WA_2 - OO OBS SQL WA 2
ABAP Short Reference PERFORM Short ReferenceThis documentation is copyright by SAP AG.
Cannot Use Short Forms
-
In ABAP Objects, you must declare work areas explicitly in each SQL statement. You can create data
objects with the appropriate type with reference to the definition of the database in the ABAP Dictionary for this purpose.
In ABAP Objects, the following statements cause an error message:
SELECT ... FROM dbtab
INSERT dbtab.
UPDATE dbtab.
DELETE dbtab.
MODIFY dbtab.
Correct syntax:
DATA wa TYPE dbtab.
SELECT ... FROM dbtab INTO wa.
INSERT dbtab FROM wa.
or
INSERT INTO dbtab VALUES wa.
UPDATE dbtab FROM wa.
or
UPDATE dbtab SET ... .
DELETE dbtab FROM wa.
or
DELETE FROM dbtab WHERE ...
MODIFY dbtab FROM wa.
Cause:
Separating database names and ABAP work areas makes programs easier to read. To work with short forms, you need to declare table work areas using the TABLES, which is not allowed in ABAP objects.
Note:
This does not apply to SELECT statements in sub-queries. You cannot use the INTO
clause with a sub-query. See the EXISTS construction of the WHERE and HAVING clauses of the SELECT, UPDATE, DELETE, and OPEN CURSOR statements.
TXBHW - Original Tax Base Amount in Local Currency Fill RESBD Structure from EBP Component Structure
This documentation is copyright by SAP AG.
Length: 1621 Date: 20240328 Time: 104016 sap01-206 ( 37 ms )