topic Re: Decrypt and Encrypt a CHAR Field in Application Development and Automation Discussions

Decrypt and Encrypt a CHAR Field

martin_stampfl3 — Wed, 08 Feb 2012 14:45:47 GMT

Hello everybody,

my issue is that I want to encrypt a Char field with length 12, which is written in a table. It should be possible if necessary to decrypt the char field after encryption. Do you have any suggestions?

Thank you already

Best Regards

Martin

Re: Decrypt and Encrypt a CHAR Field

Former Member — Wed, 08 Feb 2012 17:13:15 GMT

When we had a similar requirement for encrypting salary field what we did was creating a key table(db) with structure

ZCHAR type char.

ZKEY TYPE char(5).

The entries were on lines of

1 @#$fd

2 ^%#NF

....and so on.

Then when we encrypted by reading each and every char and translating to key and appending to string...

EX: 21 -> ^%#NF@#$fd.

and similarly for decrypting. This allowed us to change keys monthly to prevent anyone from being smart and guessing at the salaries too...

Re: Decrypt and Encrypt a CHAR Field

andrs_sarcevic — Thu, 09 Feb 2012 04:12:48 GMT

Have a look [here|http://www.sap-img.com/abap/function-module-for-encryption-and-decryption.htm].

What Ncvajja suggested is a valid approach but... the method used is easily guessed by accessing that table (SAP security should be involved).

Do a search for the common encryption algorithms. They shouldn't be hard to implement in ABAP.

Regards,

Andres.

Re: Decrypt and Encrypt a CHAR Field

Former Member — Thu, 09 Feb 2012 05:09:12 GMT

Hi Martin..

try this code


Data enpwd(32) type c.
parameter pwd like enpwd .

******** Encrypting *******************
CALL FUNCTION 'FIEB_PASSWORD_ENCRYPT'
EXPORTING
IM_DECRYPTED_PASSWORD = pwd
IMPORTING
EX_ENCRYPTED_PASSWORD = enpwd
.
******** Decrypting *******************
CALL FUNCTION 'FIEB_PASSWORD_DECRYPT'
EXPORTING
IM_ENCRYPTED_PASSWORD = enpwd
IMPORTING
EX_DECRYPTED_PASSWORD = pwd
.

********* Output **********************
write:/ 'Encrypt data=', enpwd,
/ 'Decrypt data=', pwd.

also try this forum links

http://forums.sdn.sap.com/thread.jspa?messageID=5077062#5077062

https://forums.sdn.sap.com/thread.jspa?threadID=1196646&tstart=0

Regards .

Shiva

Re: Decrypt and Encrypt a CHAR Field

kesavadas_thekkillath — Thu, 09 Feb 2012 05:39:54 GMT

There is a good blog related to this topic [Encryption & Decryption of data using ABAP|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/5026]. The class cl_hard_wired_encryptor is used for this.

Re: Decrypt and Encrypt a CHAR Field

martin_stampfl3 — Tue, 21 Feb 2012 08:22:22 GMT

Thanks a lot Keshav, this blog helped me to solve my problem

Re: Decrypt and Encrypt a CHAR Field

andrs_sarcevic — Mon, 27 Feb 2012 02:22:35 GMT

Martin, keep in mind that blog does not describe a powerful encryption method like [AES|http://en.wikipedia.org/wiki/Advanced_Encryption_Standard] or [Blowfish|http://en.wikipedia.org/wiki/Blowfish_(cipher)], but common [BASE64 Encoding|http://en.wikipedia.org/wiki/Base64]. Take a look at the comments on the blog.

Regards,

Andres.