cancel
Showing results for 
Search instead for 
Did you mean: 

Sensitive Data on Table

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

FCI
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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