Skip to Content
avatar image
Former Member

Scrambling Salary Data in TDMS 4.0 SP07

Dear Mates,

We have installed TDMS 4.0 SP07, now we are in process of Scrambling rules creation

Our few requirements are:

1. Scrambling of Employee salary data while migrating from PRD to QAS and need to change 4 fields in one table.

2. We want to copy whole client data using "Full transfer of Client-Specific Data" with above scrambling rules including.

My queries are:

1. Can I create a rule using scrambling type " Value Range Table" with some min & max value range to scramble the salary field to unknown number?

2. Or I need to select scrambling type " No mapping " and create a custom code to scramble the data?

3. And can I include these rules in " Full Transfer of Client-Specific Data" and Execute?

Please provide your valuable suggestion.

Thanks,

Sandy.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Dec 10, 2014 at 07:28 AM

    Hello Sandy,

    First of all , regarding salary scrambling, SAP does not recommend scrambling the salary field as such, since it might lead to inconsistencies in the cumulative reports generated.

    If you still want to go ahead and do a salary scrambling please find the below response to queries,

    "1. Can I create a rule using scrambling type " Value Range Table" with some min & max value range to scramble the salary field to unknown number?

    2. Or I need to select scrambling type " No mapping " and create a custom code to scramble the data?"

    Ans: Yes, you can create a rule using "Value Range Table" with min and max range and scramble the salary field and You don't have to write any custom code.

    "3. And can I include these rules in " Full Transfer of Client-Specific Data" and Execute?"

    Ans : Yes you can include these rules in "Full Transfer of Client-Specific Data'. There is an activity "Define Scrambling Rules" in the process tree which will let you activate the newly created rules.

    For help in creating Scrambling objects you can refer to scrambling guide or for quick help you can refer to the below link

    http://scn.sap.com/docs/DOC-52263

    Hope this helps.

    Regards,

    Jerrin


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 25, 2014 at 08:17 AM

    Hi Jerrin,

    I need a help in assigning Scrambling rules to project.

    I have created a New Solution Category, Group and subgroup.

    Created a rule and assigned:

    RULE --> Group --> Super Group (all these are under newly created solution category).

    While assigning this rule to project its in inactive. Pls check below screen shot:

    But the rule is showing green in Scrambling Rule Tab.

    Regards,

    San's.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 05, 2015 at 09:59 AM

    Hello Jerrin,

    We have one issue with Scrambling of Data.

    We Ran the TDMS run with Scrambling rules. To Scramble currency, we used keyset of PERNR.

    Now the problem is TDMS scrambling the data based on PERNR. If we have multiple entries with same PERNR. TDMS giving same value to the all same PERNR entries.

    Also tried with Key Set with Start Date and other. Still it's scrambling in same way.

    If the Keyset value exist 10 times. TDMS assigning same new value 10 times.

    Can you pls help if is there any way to get different values for all entries?

    Thanks in Advance,

    San's

    Add comment
    10|10000 characters needed characters exceeded