Viewing data in authorization tables

[Former Member]

Dear all,

my client currently wants a table dump of all authorization tables as of a certain date in the SAP production system. Is there a way to restore these tables in a specific client, for examples, tables:

AGR_DEFINE

AGR_1251

AGR_AGRS

CD1251

CD1252

we are live since February 2009 and do not want to track the changes since then, however, wanted to see what the authorization tables looked like as of go-live.

Thanks.

[former_member204746 · Accepted solution]

I would use R3trans (similar as per SAP note 130906) or Oracle's EXP program to export these table contents.

[Former Member · Accepted solution]

Thanks Eric, this solved our requirement.

[Former Member]

Have you thought of client copy?

[http://help.sap.com/saphelp_sm32/helpdata/en/99/0a2a887e2511d2a6250000e82deaaa/content.htm]

[Former Member]

does that mean we can restore a specific client in QA for example with the production profiles as of a certain date?