Skip to Content
avatar image
Former Member

Sensitive Data on Table

Hi All

We are on SP8 - I want to load a table from sap to hana using slt and the table have sensitive data in one column ..I can drop the column but unfortunately the column is a part of key and if i drop i can't maintain the integrity of the records as this would be duplicate the records without the sensitive info column ..

I was thinking of scrambling the data but i was not sure how it works if the record is an update

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 20, 2016 at 09:32 PM

    Hi,

    You can use IUUC_REPL_CONTENT transaction in SLT. Create field based rule for your table. Insert line of code as per your logic. Set the rule status to Released. Load/Replicate the table...

    See example below for field based rule setting.

    Table Name SPFLI

    Assignment Target CITYTO

    Import Parameter 1 'DUMMY'

    Import Parameter 2

    Import Parameter 3

    Insert Include Name

    Insert Line of Code E_CITYTO = 'HONOLULU'.

    Regards,

    Pranav

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 21, 2016 at 01:49 PM

    Hi,

    Well, it will work if you always scramble the data in the same way.

    You can probably have a look to the possible encryption algorithms in ABAP or develop your own.

    There is one described here : http://scn.sap.com/docs/DOC-56728

    Regards,

    Frederic

    Add comment
    10|10000 characters needed characters exceeded