module pool regarding how to use insert statement

[Former Member]

hi all,

i have a requirement like i have to create a z table and need to insert the values into the z table from my program. i have created the table but i dont know how to insert the values into table. and also the syntax for insert statement can anyone please help me.

thanks in advance.

anupama.

[valter_oliveira]

Hello.

Check this short program to insert lines into your table.

Declaration:

DATA: wa type ZTABLE.

Insertion:

wa-field1 = ...
INSERT ztable FROM wa.

Update:

UPDATE ztable
SET field1 = 'abc'
WHERE field2 = 'X'

Best regards

Valter Oliveira.

[Former Member]

Anupama,

The following are the ways to insert the records to the table.

INSERT INTO dbtab [CLIENT SPECIFIED] VALUES wa.

INSERT INTO (dbtabname) [CLIENT SPECIFIED] VALUES wa.

- INSERT dbtab [CLIENT SPECIFIED].

INSERT *dbtab [CLIENT SPECIFIED].

INSERT (dbtabname) [CLIENT SPECIFIED] ... .

- INSERT dbtab [CLIENT SPECIFIED] FROM TABLE itab.

INSERT (dbtabname) [CLIENT SPECIFIED] FROM TABLE itab.

Kind regards,

Sujith

[Former Member]

Hi,

You can use these statements...

insert into DBTAB values WORKAREA.

modify DBTAB from WORKAREA .

update DBTAB set bedat = WORKAREA-bedat

bukrs = WORKAREA-bukrs

lifnr = WORKAREA-lifnr

netpr = WORKAREA-netpr

waers = WORKAREA-waers

WHERE ebeln = WORKAREA-ebeln.

*******************************

Reward if helpful.

Regards,

Syed

[Former Member]

Hi,

Inserts the content of a structure into an internal table.

In the case of a standard table, this content is appended, in a sorted table it is inserted in the right place according to the key, and in a hashed table it is inserted according to the hash algorithm.

Syntax: INSERT wa into table itab <condition>

Plz check this sample program.

data: it_ztable type ztable,

wa_ztable like line of it_ztable.

• fill structure with values

wa_ztable-field1 = ..........

wa_ztable-field2 = ........

wa_ztable-field3 = ........

insert wa_ztable into table it_ztable.

Please reward points if helpful.

[Former Member]

solved

[Former Member]

the bellow statement is used to store the values in data base table,

insert table dbtable from WA