Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Inserting/modifying into custom Z table

Former Member
0 Kudos

Hi Gurus,

I am trying to extract a set of data from cdhdr and cdpos into a custom table.

Basically, what I did is the transform/aggregate data from cdpos and cdhdr is stored in an internal tables and later the data is inserted into a custom table. The purpose of doing so is to enable fast retrieval of records when the user view the report.

The program works fine in Development and QAS box. Records were inserted. But in Production, no record was inserted.

Any idea on why this happen? Is is due to the size of the records fetched into internal table? Something to do with buffers and memory?

6 REPLIES 6

naimesh_patel
Active Contributor
0 Kudos

In Production, put the break point and try to debug the program. You will understand what is going wrong.

Regards,

Naimesh Patel

0 Kudos

Whenever I did so, the timeout error occur.

But I know that in Dev, the records were inserted into internal table.

0 Kudos

Oh.. it is because of the lots of the data and you are trying to manipulate and insert the data in Z table.

So, try to schedule the job in the Background.

Like: Run the report .. on the selection screen press F9 to execute the program in background. This will schedule a job in SM37. The TIME_OUT problem doesn't occur in the background job.

Regards,

Naimesh Patel

0 Kudos

You know...this is even stranger because I did exactly that - background job and it showed successful upon completion but...no data is inserted.

0 Kudos

Oh... than it is really a wired.

What you can do it restrict the selection which can provide you only small amount of the data. So, you can run the program online and try to debug it.

Regards,

Naimesh Patel

0 Kudos

Hello,

what kind of program is "Inserting/modifying" the custom Z table ? a standard program ? specific program ? in a user exit ?

Is the DB update of the the custom Z table made using "IN UPDATE TASK" ?

Cordialement.