building ranges for selection

[Former Member]

Lets asume we got 100.000 customer records in databaase table in our system.

We have already a report that

a) selects the customer records and

b) build a IDOC

Our problem is, that we DONT want to select all record at one.

Let's asume we want run the report 10 times.

Is there an automatism to do this.

We don't want the agents to start the report 10 times manually.

The problem is, that when the reports runs the second time, it DONT has to select the records it selected be the first run.

I would be glad to receive any ideas.

Regards Mario

[Former Member]

Lets asume we got 100.000 customer records in databaase table in our system.

We have already a report that

a) selects the customer records and

b) build a IDOC

Our problem is, that we DONT want to select all record at one.

Let's asume we want run the report 10 times.

Is there an automatism to do this.

We don't want the agents to start the report 10 times manually.

The problem is, that when the reports runs the second time, it DONT has to select the records it selected be the first run.

I would be glad to receive any ideas.

Regards Mario

[RichHeilman]

One solution is to have a driver program which first selects all the customers and then breaks the data into separate pieces, which then can be pass thru memory. THe driver program can kick off many background jobs to retrieve the data and process it accordingly.

Regards,

Rich Heilman

[Former Member]

Hi Mario,

I dont know whether this may solve your problem but try as follows.

Write a report program for one customer(ZREPT_CUST_IDOC).

Write another report program as the main program which accepts all customers from the database table and pass each customer data to the ZREPT_CUST_IDOC in a loop by using SUBMIT REPORT.

REPORT ZREPT_MAIN_PROG.

LOOP AT CUSTOMERS.

SUBMIT ZREPT_CUST_IDOC.

ENDLOOP.

Thanks,

Vinay

[Former Member]

another option would be to write a program which will :

- import last number used from database.

- select data up to NNN rows where customer number > saved number

if select successful

- process this data

- export the last number processed (last customer) to database (export to database)

- trigger an event which will start same job again

else.

do not trigger event.

endif.

In this case you'r job will restart itself until all customers are processed.

Just an option 🐵