Exporting data from Template table to flat file in BOBJ data services.

[Former Member]

Hi all,

I have extracted 27,000 records from MARA table in SAP system to a template table in BOBJ data services. When i use the 'save as' option in the view data window, it saves in a text file in my local system with only 5,000 records which is the view data limit in BOBJ data services. How do i export the entire data volume which is 27,000 records from the template table to a flat file in my local system??

Thanks,

OMAR

[Former Member · Accepted solution]

Using your view data, DS gives you only 5000 records / rows at a time as this is the maximum view data sampling size.

1) You will have to go to the database and run a command to see the entire records.

2) Else, you can write the entire data into a flat file of your choice by creating a Flat File Format and using the same as a target in your ETL. You can find the option to create a new flat file format in Local Object Library inside Designer.

Regards,

Suneer Mehmood.

[Former Member · Accepted solution]

Hi suneer,

Thanks for you reply. The second option is fine. But Could you explain in detail regarding the first option as i don't want to create flat files at every phase in my project as template tables will automatically bring all the columns when mapped.

Thanks,

OMAR

[Former Member · Accepted solution]

Option 1 is to view throw a query and view the result from your database.

Suppose you load MARA table from SAP ECC to a table called MARA_TARGET in database MS SQL server.

The option would be logging into SQL Server Management Studio, running a query against the target database like

Eg:

SELECT * FROM MARA_TARGET

which will show you the result. You can right click at the result area and save target as .txt or .csv file.

Just an option that came into my mind. Depends on your database server as well.

Regards,

Suneer Mehmood.