Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Yeesh.. What about loading them into an SQL DB? Give them some query tools or a developer to write it for them and spit out reports.
| | | ---------------Original Message--------------- From: R. N. Wilhite Sent: Tuesday, March 01, 2011 9:31 AM Subject: Writing MSEG to Access Hi All, I know that the title of this question has already sent all of the thinking individuals out there into hives... Here's the background: Our auditors (explanation enough do you suppose) want a complete set of financial data to analyze. Since it is the auditors, that makes it non-negotiable. Now, I've already done this for this year but it took well over 60 hours of my time. I need a better solution for next year. We have a report (ZFB03) that creates an alv with a flat view of many of the fields from FB03. The auditors accept this format, but want it in an access DB. Sounds simple accept there are over 17,000,000 records for last year. I broke it into pieces period wise and downloaded them as DAT (ie tab delimited or .tab). A period was about all I could get without timing out. Then I uploaded these into access one at at time. Access started hanging after I had past about 10,000,000 records, so i eventually had to give it to the auditors in 2 access BD's. So, for next year, I need a method that will streamline the process. Anyone got any ideas? (Oh and please don't say find different auditors...) Neal | | __.____._ Copyright © 2011 Toolbox.com and message author. Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251 | | robphelan SAP Development Enthusiast
Contributed 500 posts in a group to earn a Silver Achievement Most Popular White Papers In the Spotlight _.____.__ |