Skip to Content
-6
Jun 26, 2018 at 06:41 AM

Report run in background but unable to to extract all records : zsales report

2264 Views

Dear All,

I cannot run a zsales_report in the foreground due to large number of records .It is showing a dump .


So I have to run this report in the background so that I can get the output for a period of 1 year .


Here I am facing an issue in running the report in the background .

To run a report in the background :-

(1) We can either create a background job with Tcode : SM36 ( Create Background Job )

with a variant .

(2) Execute in Background .

So I am adopting the (2) option that is Execute in Background .

For Output Device I am giving " print_123 " .When I schedule it further it is showing that " Formatting set to 'X_6 5_80 " .Then I saved this job .


So I run the report in the background so zsales_report is successfully executed in background . Background job successfully finished .


When I try to extract the output from the background job which was finished it is displaying the output but showing a message that only page 1 to page 10 of

82 are displayed .


I have attached the message which I am getting . Moreover when I save the output to a local file i.e excel file (spreadsheet) then also the output which is extracted in excel is not having all the records . I checked the records in excel file and the count comes to only 441 records .


So it was an incomplete output because it is showing records passed : 3952 .


I have attached the screenshots . Please check .


So please guide how to extract the whole output of the report because I am running for all plants , division , distribution channel and Invoice date is almost an year .

( 01.04.2014 to 31.03.2015 ) .I am not getting complete output of the report while running the report in the background .


records-passed.jpg

report-run-in-background.jpg

Regards

Deep

Attachments

records-passed.jpg (23.0 kB)