topic Re: insert into ztable in Application Development and Automation Discussions

insert into ztable

Former Member — Thu, 20 Jul 2006 07:32:39 GMT

i have 5 rows with matnr lgort........

i create ztable that matnr lgort ---key

but only 1 row is entered why?????

Re: insert into ztable

Former Member — Thu, 20 Jul 2006 07:34:28 GMT

Hello Rani,

You cannot have entries with duplicate keys in the database table. can you specify the values you are trying to enter into your Z-Table?

Regards,

Anand Mandalika.

Re: insert into ztable

Former Member — Thu, 20 Jul 2006 07:35:54 GMT

look at this

INSERT INTO ztab VALUES ztab.

<b>data:itab like table of ztab</b> . (an internal table of the type of the Z table into which we want to insert.

Now we have to populate required data into this internal table. For inserting these values into the table ZTAB we can go by 2 different syntax.

1)insert ZTAB from table ITAB or

2)modify ZTAB from tabel ITAB.

Re: insert into ztable

Former Member — Thu, 20 Jul 2006 07:37:40 GMT

Hello RANI.

Before using the insert statement add

SORT ITAB BY MATNR.

DELETE ADJACENT DULPICATES FROM ITAB COMPARING MATNR.

INSERT INTO ZTABL FROM ITAB.

If useful reward.

Vasanth

Re: insert into ztable

Former Member — Thu, 20 Jul 2006 07:37:40 GMT

Hi,

If the entries are duplicate it wont enter in DB table with primary keys.

Rgds,

Prakash

Re: insert into ztable

Former Member — Thu, 20 Jul 2006 07:40:00 GMT

i have matnr

1111111111 lgort 20

1111111111 lgort 10

1111111111 lgort 30

Re: insert into ztable

Former Member — Thu, 20 Jul 2006 07:41:07 GMT

i think in ur ztable matnr is primary key.

Re: insert into ztable

Former Member — Thu, 20 Jul 2006 07:44:29 GMT

matnr and lgort is key and mandt

Re: insert into ztable

Former Member — Thu, 20 Jul 2006 07:47:40 GMT

Inserting or Changing Lines

To insert lines into a database table regardless of whether there is already a line in the table with the same primary key, use the following:

MODIFY <target> <lines>.

If the database table contains no line with the same primary key as the line to be inserted, MODIFY works like INSERT, that is, the line is added.

If the database already contains a line with the same primary key as the line to be inserted, MODIFY works like UPDATE, that is, the line is changed.

The first syntax inserts the values into the table and if there occurs some duplication you will end in error.

The second syntax inserts into the table the values in ITAB if it is not already present or if already present the existing value is modified with the new value.

Instead of internal table you can also use a workarea where the syntax will be

data: WA type ZTAB.

insert into ZTAB values WA.

hope this helps

Re: insert into ztable

Former Member — Thu, 20 Jul 2006 07:51:52 GMT

i use this

loop at zins.

INSERT zml FROM zins.

endloop.

Re: insert into ztable

aris_hidalgo — Thu, 20 Jul 2006 07:52:53 GMT

Hi,

As others have said, using INSERT statement when there's an existing record will result in error. You can use the MODIFY statement. To know more about the said commands, press F1 while it is highlighted on the command.

Regards!

P.S. Please award points for useful answers

Re: insert into ztable

Former Member — Thu, 20 Jul 2006 07:56:55 GMT

Hi Rani,

U can do it making the third entry of ztable as a key field.

Not Sure but atleast u can have a try.

Thanks

Sachin Dhingra

Re: insert into ztable

Former Member — Thu, 20 Jul 2006 08:01:03 GMT

Hi Rani,

Can this way help you.


LOOP AT zins.

  UPDATE ztable SET    <fields to be updated> = <values>
                   WHERE matnr = zins-matnr AND
                         lgort = zins-lgort.

ENDLOOP.

Regards,

Arun Sambargi.

Re: insert into ztable

Former Member — Thu, 20 Jul 2006 08:04:34 GMT

You have to use standard table.

Re: insert into ztable

Former Member — Thu, 20 Jul 2006 08:15:04 GMT

icant do it i need my ztable because i need to download the data

Re: insert into ztable

Former Member — Thu, 20 Jul 2006 08:17:03 GMT

Hi rani,

1. along with mandt,

matnr,

lgort,

<b>u will have to add one more field

as a part of primary key.</b>

(for the values 10,20,30 etc)

2. u can keep this as

ZEILE (like MBLPO Item in Material Document)

( see table MSEG)

3. Then things would get allright.

regards,

amit m.

Re: insert into ztable

Former Member — Thu, 20 Jul 2006 08:17:28 GMT

another problem maybe ir's the solution

i create the key of lgort and the lgort was the no 6 in se11

now it's no 3 mandt,matnr,lgort

if i make se16 i still see it no 6

Re: insert into ztable

hymavathi_oruganti — Thu, 20 Jul 2006 08:19:03 GMT

send ur code, so that we can check where its going wrng