topic Re: error in table entries in Application Development and Automation Discussions

error in table entries

Former Member — Mon, 05 Jan 2009 13:05:43 GMT

I have deleted my table entries and again uploaded by using insert statement..

now if i give a value and want to check in the table it says no entry exist with that value,,but the values r there...

what happend when i again inserted the records in the table?

Re: error in table entries

Former Member — Mon, 05 Jan 2009 13:08:05 GMT

R u checking the correct client, if ur table is client dependant then u must include ur client number in the record that u insert.

кu03B1ятu03B9к

Re: error in table entries

Former Member — Mon, 05 Jan 2009 13:19:07 GMT

yah..i have included the client number..

Re: error in table entries

Sm1tje — Mon, 05 Jan 2009 13:23:19 GMT

do you check the return code (SY-SUBRC) after doing INSERT? Did you also do a COMMIT?

Re: error in table entries

Former Member — Mon, 05 Jan 2009 13:50:52 GMT

Check if the issue is with the Leading zeros .

Check if the key fileds you are using does not have a issue related to LEading zeros becaue of which it is not able to find the table entries. you might not be giving leading zero in i.p but table fileds may have converison exits attched which stores the value with leading zeros.

Please check.

Re: error in table entries

Former Member — Mon, 05 Jan 2009 13:52:56 GMT

Alyways use a COMMIT Statement when you try to perform any database updates..

Regards

Vasavi Kotha

Re: error in table entries

Former Member — Mon, 05 Jan 2009 14:08:24 GMT

Use conversion exits for the primary key fields like for example

CONVERSION_EXIT_ALPHA_INPUT

CONVERSION_EXIT_ALPHA_OUTPUT

regards,

Jinson.

Re: error in table entries

Former Member — Mon, 05 Jan 2009 21:05:49 GMT

Hi,

If there are records in the internal table same structure as database table:

if using Insert command and at least one entry already exist in the table, it will give you dump.

But if you use Accepting duplicate keys with Insert command, it will insert only the rows that doesnot exist in the database table and rest will be ignore.

And if you want to add the entries which are not in the database table and modify if the entry exist -> you should use the modify command.

Hope this helps.

Regards,

Bharati

Re: error in table entries

Former Member — Tue, 06 Jan 2009 06:09:54 GMT

I didnt use commit work..

How to use commit statement?

Re: error in table entries

Former Member — Tue, 06 Jan 2009 06:33:59 GMT

Hi,

After insert are you checking SY-SUBRC and also do COMMIT WORK while performing the database table.

COMMIT WORK AND WAIT.

Regards,

Jyothi CH.

Edited by: Jyothi Chinnabathuni on Jan 6, 2009 12:13 PM

Re: error in table entries

Former Member — Tue, 06 Jan 2009 10:26:46 GMT

Hi,

Simply write COMMIT WORK after INSERT/MODIFY/UPDATE/DELETE.

Pooja

Re: error in table entries

Former Member — Mon, 12 Jan 2009 06:55:12 GMT

Had you COMMIT after your operation..

Re: error in table entries

Former Member — Tue, 13 Jan 2009 05:50:24 GMT

Hi ,

Please check for the Primary key values which you have inserted.

Check for the doamain and if some Conversion exit is present for them .

Click on the domain for the specific field and in teh Definition tab check for the Output characteristics

tehre is a filed Conversion Routine . If some name is specified then it mena that there is some conversion routine assocaiated with this filed.

On double clicking on the name of Conversion Routine name there is a list of function module names provided .

So u need to pass the values you are inserting to to the Fucntion Module before actually inserting the data into the tables using the Insert / Update statements.

Then you will be able to get the values appropriately.

Regards,

Radhika