Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi,
At first look there maybe two ways to do this.
1- If your database system (let's say ORACLE) and administrator (Basis)
allows you to do it, do an EXTRACT directly from table MSEG (if it is not a
cluster table). You will have MSEG in a text file in one shot. Load it
into an SQL Server DB, you should have no problem. You can give an Access
DB as a front-end to your auditors with linked table to SQL Server or give
them tools to do their own queries.
2- Write an ABAP program that writes down the entire content of MSEG into
a DATASET (using OPEN DATASET / TRANSFER ) and load that file into an SQL
Server DB. This way, you will be able to run this program in Background,
so no timeout.
Regards,
Pierre
| | | ---------------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
| | Most Popular White Papers
In the Spotlight  _.____.__ |
