Question Re: SAP Export to CSV in Enterprise Resource Planning Q&A

SAP Export to CSV

Former Member — Fri, 08 Jan 2021 08:31:54 GMT

Hi All Experts,

I am being thrown in an situation that there is a old SAP Server in the environment, our users is using this server for reference into past years data, they have migrated to another ERP Platform. As we have a policy from government that we need to keep data for 7 years. So to me this is critical, but unfortunately i know nuts about SAP and cant do much about it.

So coming into this community, in hoping that someone can point me into some methods of exporting SAP data to CSV file for backup, in case the SAP has a hardware failure.

Regards

Re: SAP Export to CSV

lenastodal — Fri, 08 Jan 2021 08:32:09 GMT

Hi and welcome to the SAP Community!

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful) and share screenshots of what you've seen/done. The more details you provide, the more likely it is that members will be able to assist you.
Should you wish, you can still edit your question.
Finally, if you're hoping to connect with readers, please consider adding a picture to your profile as it encourages readers to respond to you. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS.

Best,
Lena
SAP Community Moderator

Re: SAP Export to CSV

TammyPowlas — Fri, 08 Jan 2021 10:08:02 GMT

I would work with the business to identify key data to keep - for example, perhaps you can download 7 years of trial balances and export those to CSV, but perhaps not download all records from the FI table BSEG

You can go to SE16 or SE16N transaction and download all data to CSV, and do that for all tables, but that would be very cumbersome.

Re: SAP Export to CSV

Former Member — Fri, 08 Jan 2021 13:51:27 GMT

if it's an older server, running '%pc' in the transaction box for the 'older-looking' tabular displays usually does the trick.

just be aware of the environment that you run it in and don't paste the 'data' where it does not belong.

Re: SAP Export to CSV

Former Member — Mon, 11 Jan 2021 02:35:33 GMT

Thanks for replying, having difficulties to comprehend the SAP in such a short timeframe.

Will try it out, i have few more question.

1. FOR SAP, i believe we are using SQL Databases together with the SAP System, is there anyway we can do a backup from there? to backup the SQL ECP Database.

2. Is there anyway, we can call out information for the SQL and export from there?

Regards