#Sos online backup slow upload code

If the file is locked in Excel you might run into trouble.

If you enter wrong, duplicate data you might get a dump.

Garbage in – garbage out: There exist some input checks on the data but you should only use correct files to avoid trouble.

USCRAUTH (details about critical authorizations) USCRAUIDT (short texts of critical authorizations) USCRAUTHID (definition of critical authorizations) USRVARID (assignments of critical authorizations to variants)

If you want to create your own source file, this file has to follow this structure to get correct results:.

It’s recommended to use the attached file as template for your own file you can also export some data to another file and edit this one.

If the file is opened in Excel during executing the report, an error message will appear: “Excel file … cannot be processed”.

(This report repairs wrong data in case of the activity field, ACTVT, automatically.) Example: Enter ’02 instead of 2

Have a close look to numeric data: To enter leading zeros use ‘ to avoid that Excel removes the leading zero.

#Sos online backup slow upload code

If you omit the color code it will be replaced by 6.

If you omit the language it will be replaced by the logon language.The TEXT field in USRVARID and USCRAUTHID is optional.The entries for table USRVAR and USCRAUTHID are optional.The sort order of the file does not matter.The first column (TABLENAME) defines the table.The attached File contains the main part of the authorization data out of the SOS document, but it’s possible that there are some small mistakes.(Error Message) Tips concerning the Excel file If the data in the sheet is obviously incorrect, the changes won’t be performed and an error message will be displayed. In Addition the report shows a change log of the data on the screen. Imports data selected at (2) from the Excel sheet selected at (4), writes it to the database and shows it on the screen as in Show Data. (Preview of the Excel-Sheet inside of the report) If the file already exists, it will be overwritten else a new file with the pathname selected at (4) will be created. Only shows data selected in (2) and (3) on the screen in the form of 6 tables.Įxports data selected at (2) and (3) to the XLS selected at (4), generates a preview inside of the report and shows the same screen as Show Data. In (4) you have to choose an XLS-sheet file name whose data you want to be imported or where you want to export your data to. In (2) and (3) you can define criteria of selections for the data you want to get. In (1) you choose the action to be performed. There are three actions that can be performed by the report. This is much more convenient than defining it in the UI of the report. This report is used do export/import the definition data which are used by the report RSUSR008_009_NEW about critical authorization and variant of the user information system, transaction SUIM that you usually maintain within that report or using transaction SU_VCUSRVAR_CHANGE to/from an Excel-sheet.

You find the source code on the corresponding wiki page. Julius Daub and Frank Buchholz ABAP Source Code

Furthermore it gives a clearer overview of the authorization data in the form of some tables.įinally we’ve published a file representing the checks of the SOS: → Media Library → Security Optimization Service – ABAP Checks Using this program you can import an XLS sheet including the needed data or export the content of the database to an XLS sheet. The purpose of this new program Z_USCRAUTH is to simplify the maintenance of critical authorization definitions used by Report RSUSR008_009_NEW. We like to introduce a new Code Exchange project which was the result of a student practicum during the last weeks. See Note 2785076 – SUIM | New functions in RSUSR008_009_NEW News: As of SAP_BASIS 7.52 (with a support package as of October 2019) you can use the standard report RSUSR_UP_AND_DOWNLOAD_FOR_CA instead: