Hiding compensation data in SAP BW
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?

    Requires Free Membership to View

    Login

    When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSAP.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

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 first published in February 2007

Back to top