Q
Problem solve Get help with specific problems with your technologies, process and projects.

Hiding compensation data in SAP BW

Expert Sam Gassem suggests a method by which data might be encrypted in SAP BW to protect it from prying eyes.

I have a scenario in which I need to hide data related to compensation in SAP BW. We are extracting data from R/3; we don't want our support people to view this information at object level (like PSA).

Can we use some function module to encrypt the data and decrypt the data in SAP BEx customer exits?

And is it good practice not to design PSA but to load directly into the data target so that we don't need to worry about security for PSA?

As far as I know there is no function in BW to do what you looking for. What is comes to my mind is that you can write an ABAP to encrypt the data to load to PSA and decode it by another ABAP in Update rules.

PSA is nice to have in case if you need to correct some records and reload failed data. If you do not want to do ABAP, you can delete PSA as soon you confirm the data is loaded correctly into your InfoProvider.

This was last published in February 2007

Dig Deeper on SAP business warehouse

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close