cancel
Showing results for 
Search instead for 
Did you mean: 

Update in table.

ronaldo_aparecido
Contributor
0 Kudos

Hi masters.

I am a ABAP programmer and in ecc6.0  we use the oracle in SAP.

I have a question:

I have a program works in Job .

This program has update of datafield of table , i use the command modify.

But in some cases dont´t work and the data is not updated to table.

I think :its the time of response of database?

I use one :

   CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

         EXPORTING

           wait = 'X'.

In this command it does even work.

But the performance is bad.

What i can do?

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

jimguo
Advisor
Advisor
0 Kudos

Hi,

I recommend you generate SQL trace via ST05 to see which SQL takes long time and do performance tunning accordingly.

Thanks.

Jim

Answers (1)

Answers (1)

Reagan
Advisor
Advisor
0 Kudos

Hello

Unfortunately the amount of information you have provided is not sufficient.

I suggest you to perform a runtime analysis of the program using Tx SE30 and also an SQL trace using the Tx ST05 to identify where exactly the problem is.

Regards

RB