on 12-10-2010 12:17 PM
Hi,
For an audit purpose we have an requirement to extract data from BSEG, REGUP tables.
We have an ECC 6 system with MSSQL database.
How can we extract BSEG data from MSSQL.
Regards
Rahul
Hi,
*BSEG : Accounting documents
*REGUP: processed payment detail for items
Since they are FI/CO related data you need to double check what exactly they are looking for and get prior approvals before proceeding.
You need to make Z program/FM in ABAP to extract data and display to auditors rather using MSSQL management studio or any other tools for extraction (extracting financial data from tools other than ABAP program is violation i guess).
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> For an audit purpose we have an requirement to extract data from BSEG, REGUP tables.
> We have an ECC 6 system with MSSQL database.
> How can we extract BSEG data from MSSQL.
I wouldn't extract the data but do the necessary programs in the system itself, those tables are usually very big.
However, there are many methods of doing this:
- write an ABAP that opens a file and writes it into a text file
- use SQL Server Management studio
- use an SQL script
- connect Excel and/or Access via ODBC and extract the data
The latter one is the most dangerous one since there's only one user for the whole system, and that use can even (accidentally) drop full tables.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
72 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.