How Data is stored in SAP Database

[Former Member]

Hi Gurus,

When we create a particular record in SAP using different TCodes , and saves the record, how that data is stored in SAP back end (Ex- SQL Server). whether it is in encrypted format of plain text?

For example:- If i create a sales order in SAP and saves it, or create any master record in SAP HR using TCode PA40, how information or details about the sales order and employee is stored in SQL database. Is data is encrypted before saving the same in database??

Any Pointers??

Thanks,

Prashant

[Former Member]

Hi,

Check the link below

http://www.sap-img.com/human/where-the-payroll-data-is-stored.htm

Hope it helps you

Rgds,

Suman

[jurjen_heeck]

> When we create a particular record in SAP using different TCodes , and saves the record, how that data is stored in SAP back end (Ex- SQL Server). whether it is in encrypted format of plain text?

In general, the data in the database is readable, not encrypted, whether it's text or binary data. There will be some exceptions for stuff like passwords, credit card numbers etc.

Protecting your database from access outside the SAP application is a very important part of your overall security design.