Insert single into DB table by not using structure as data holder

Question

Is there a way to insert single record in db table without using structure as data holder.

I was thinking something like

INSERT INTO table(filed1, field2) VALUES (value1, value2).

Is something like this possible in abap? thx

I think that is possible, check this [link](http://stackoverflow.com/questions/15041871/how-to-import-sql-server-table-to-sap-abap-itab/15165487#15165487) — Nelson Miranda, Oct 14 '15 at 16:37
@NelsonMiranda Rule 1: Never use Native SQL unless you need it. Rule 2: You don't need Native SQL unless you're coding DB management / DDIC stuff. — vwegert, Oct 14 '15 at 17:11

score 2 · Accepted Answer · answered Oct 14 '15 at 17:15

2

No, this is not possible because you can't specify individual target fields with OpenSQL INSERT statements. You might be able to work around the need for a temporary structure on the right-hand side by using a VALUE type( ... ) operator, but I haven't tried that yet.

answered Oct 14 '15 at 17:15

vwegert

18,371
3
37
55

2

I've tried it and it's not possible to specify a temporary structure in the INSERT statement. – Christian Tapia Oct 14 '15 at 17:37

score 0 · Answer 2 · answered Nov 17 '15 at 19:24

You should try to create a structure dynamically.

using CL_ABAP_STRUCTDESCR=>CREATE, specifying a list of components (list of column) and their types, you get dynamically a description of your structure that you can use to create a data reference.

Quick pseudo-code:

DATA coldescr TYPE REF TO cl_abap_structdescr.
DATA cols TYPE REF TO data.
FIELD-SYMBOLS <cols> TYPE any.

coldescr = cl_abap_structdescr=>create(  ).

CREATE DATA cols TYPE HANDLE coldescr.

ASSIGN cols->* TO <cols>.

You can use <cols> in you insert select stmt.

Insert single into DB table by not using structure as data holder

2 Answers2