Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
1) Sorry about mentioning MSEG. My mind must have been wondering...
Obviously I should have meant BSEG.
2) The auditors don't own SQL Server. They own access. And therefore they
need access only as what they get.
Thanks anyway,
Neal
| | | ---------------Original Message---------------
From: Pierre_Richer
Sent: Tuesday, March 01, 2011 10:18 AM
Subject: Writing MSEG to Access
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 |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  R. N. Wilhite
SAP Development Helper
Posted helpful replies on 50 threads in a group to earn a Silver Achievement Most Popular White Papers
In the Spotlight  _.____.__ |
