on 01-20-2016 8:24 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.