Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from venkateswarlupokuri on Dec 11 at 8:34 AM Go to Tcode fb03 and there see all entries give there from period to to
period after click on execute (f8)
| | | ---------------Original Message---------------
From: Louis Corato
Sent: Monday, December 08, 2014 5:13 PM
Subject: Journal entries
So now we know that you're doing this for audit purposes and that you will have over a million rows in the output. . . . . Thank you.
Unless you're very confident that your system is capable of holding onto over a million complete rows of data at one time in memory, my advice to you in order to avoid memory/paging issues would be to write a custom report that would grab a complete document and write it to a file immediately.
Grabbing all the document numbers for a company and fiscal year would probably not be an issue, even at a million plus rows. The program would then loop through the document numbers getting the header and line item information required and writing them out one doc at a time. The process would continue until all documents for the year had been processed.
Although this will run a long time, it should run to completion. Trying to run a standard query and then trying to download that much data is usually not possible in a standard system.
Of course, you could always run a standard report for a shorter period (perhaps a month at a time?) and download the result 12 times. If your auditor will accept 12 files, that is another way you can go. I think of this as an ongoing requirement and would rather have this process automated, rather than manual.
Lou |
| Reply to this email to post your response. __.____._ |   _.____.__ |
