topic Re: Inserting data into ZTABLE created in data dictionary in Application Development and Automation Discussions

Inserting data into ZTABLE created in data dictionary

stefan_kolev4 — Tue, 17 Mar 2009 10:30:52 GMT

Hi,

I've created ztable in data dictionary via se11 called zzcalc.

I am able to insert only one record using code, which you could see below.

When I try to insert second record sy-subrc = 4.

Why ? How can I insert more than one record ?

My code:

zzcalc-zzmeins = rv45a-zzmeins.

zzcalc-zzfield1 = rv45a-zzfield1.

zzcalc-zzfield2 = rv45a-zzfield2.

zzcalc-zzfield3 = rv45a-zzfield3.

zzcalc-ZZQTYAUM = rv45a-ZZQTYAUM.

insert zzcalc.

Thanks,

Stefan

Edited by: Stefan Kolev on Mar 17, 2009 11:31 AM

Re: Inserting data into ZTABLE created in data dictionary

kesavadas_thekkillath — Tue, 17 Mar 2009 10:32:34 GMT

I think u may b inserting a duplicate record where the key already exists... check it

Re: Inserting data into ZTABLE created in data dictionary

Former Member — Tue, 17 Mar 2009 10:33:06 GMT

hi.

Ist paste ur code

and use * append zztable* not insert

Edited by: tahir naqqash on Mar 17, 2009 3:33 PM

Re: Inserting data into ZTABLE created in data dictionary

former_member585060 — Tue, 17 Mar 2009 10:35:24 GMT

HI,

Use MODIFY statement, as it performs both operations as INSERT and UPDATE

Regards

Bala Krishna

Re: Inserting data into ZTABLE created in data dictionary

Former Member — Tue, 17 Mar 2009 10:35:46 GMT

it will not allow to enter values for a particular set of primary keys if a value already exists.

it will simply overwrite with new value.

plz check that u are not inserting values for the same set of primary keys which already has a value.

Re: Inserting data into ZTABLE created in data dictionary

matt — Tue, 17 Mar 2009 10:37:16 GMT


> and use * append zztable* not insert

This is a database table, NOT an internal table. And even if it was, your answer would still be incorrect.

Re: Inserting data into ZTABLE created in data dictionary

Former Member — Tue, 17 Mar 2009 10:59:47 GMT

Hi,

There is nothing wrong in your code

1.If you want to insert the data using INSERT statement then make sure you are

not enetring the duplicate records

2.Better to use the MODIFY statement that checks if the record is already presetn in the tbale it

simply update the record, if record not prersent then it will insert the new into table.

Hope this might help you.

Pooja

Re: Inserting data into ZTABLE created in data dictionary

stefan_kolev4 — Tue, 17 Mar 2009 11:14:42 GMT

I have field MANDT which I set to be 'Key' and 'Initial values'. This is my primary key.

Is this correct or I have to change ?

Stefan

Re: Inserting data into ZTABLE created in data dictionary

kesavadas_thekkillath — Tue, 17 Mar 2009 11:17:17 GMT

go for this

INSERT dbtab FROM TABLE itab

Inserts all lines of the internal table itab in a single operation.

When the command has been executed, the system field SYDBCNT contains the number of inserted lines.

If the internal table itab is empty, SY-SUBRC and SY-DBCNT are set to 0 after the call.

Re: Inserting data into ZTABLE created in data dictionary

kesavadas_thekkillath — Tue, 17 Mar 2009 11:19:17 GMT

link:[http://members.tripod.com/sap_abap/insert_d.htm]

Re: Inserting data into ZTABLE created in data dictionary

Former Member — Tue, 17 Mar 2009 11:23:56 GMT

Hi,

If Mandt is same for all records,how can u distinguish records.

So,better declare one field as primary key,then mandt and the field(primary key) together will be unique to identify record.

In this case ,u can insert any number of records,by changing primary key.

Re: Inserting data into ZTABLE created in data dictionary

Former Member — Tue, 17 Mar 2009 11:24:26 GMT

Hi Stefan,

YOu need not to fill in MANDT fields value...its value will be filled automatically but rest all the field values you need to supply.

And I am sure MANDT is not only the key field in the table (if its value is constant in the table),if it is so then please make some other field along with the MANDT filed as key fields or every time you need to insert new value for this field.

Pooja

Edited by: Pooja Gupta on Mar 17, 2009 12:24 PM

Re: Inserting data into ZTABLE created in data dictionary

Former Member — Tue, 17 Mar 2009 11:36:41 GMT

Hi ,

May be entering same key alues .

so try modify or check roeply thee is no othe reason.

Regards

Re: Inserting data into ZTABLE created in data dictionary

stefan_kolev4 — Wed, 18 Mar 2009 07:19:31 GMT

We solved the problem.

Thanks.