topic Re: Inserting/modifying into custom Z table in Application Development and Automation Discussions

Inserting/modifying into custom Z table

Former Member — Sat, 24 Nov 2007 05:31:26 GMT

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?

Re: Inserting/modifying into custom Z table

naimesh_patel — Sat, 24 Nov 2007 05:33:30 GMT

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

Regards,

Naimesh Patel

Re: Inserting/modifying into custom Z table

Former Member — Sat, 24 Nov 2007 05:37:29 GMT

Whenever I did so, the timeout error occur.

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

Re: Inserting/modifying into custom Z table

naimesh_patel — Sat, 24 Nov 2007 05:42:18 GMT

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

Re: Inserting/modifying into custom Z table

Former Member — Sat, 24 Nov 2007 05:47:27 GMT

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

Re: Inserting/modifying into custom Z table

naimesh_patel — Sat, 24 Nov 2007 05:49:49 GMT

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

Re: Inserting/modifying into custom Z table

chaouki_akir — Sat, 24 Nov 2007 05:59:16 GMT

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.