error in table entries

[Former Member]

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?

[Former Member]

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к

[Former Member]

yah..i have included the client number..

[Sm1tje]

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

[Former Member]

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

[Former Member]

I didnt use commit work..

How to use commit statement?

[Former Member]

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.

[Former Member]

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

Regards

Vasavi Kotha

[Former Member]

Use conversion exits for the primary key fields like for example

CONVERSION_EXIT_ALPHA_INPUT

CONVERSION_EXIT_ALPHA_OUTPUT

regards,

Jinson.

[Former Member]

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

[Former Member]

Hi,

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

Pooja

[Former Member]

Had you COMMIT after your operation..

[Former Member]

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