How to check the last logon date and time of some user accounts ?

Use USR02-TRDAT and USR02-LTIME

How to search for multiple object or table entries in transport orders ?

Use E071 (PGMID, OBJECT, OBJ_NAME) and E071K (VIEWNAME, OBJNAME, TABKEY).

You want to replace some characters with a space using REPLACE instruction

Use the syntax ` ` (with backquote)

Manage server groups

Use SMLG, RZ12, SM61

You have released a transport order and need to modify it ?

Use RDDIT076 to unlock it and then, for a transport order, delete the timestamps attributes.

How to quickly copy layout variant from a report to another (assuming their are compatible) ?

See the attached program.

How to save and restore the workbench versioning ?

See SAP note 130906

How to process again an IDoc ?

Try BD87, then BD83 (for outbound IDocs) and in desperate case, use with caution the report RC1_IDOC_SET_STATUS.

How to manage some failed transports for FIN-FB-TR or BW components ?

For FIN-FB-TR, use the Wizard Transaction FINB_TR_WZ. See note 912369 For BW, create a user and a RFC detsination and then use transaction RSTPRFC. See note 659160

How to mass generate queries ?

Use SQ02 -> Goto -> Query director and then the Generate-button

How to get HANA database port (for example in the cloud) ?

SELECT DISTINCT(sql_port) FROM SYS.M_SERVICES WHERE SQL_PORT > 0

Error when trying to use the MSMP

SE16 on table WDY_CONF_USER Delete entry with key CONFIG_ID = GRFN_MSMP_CONFIG_APP and USER_ID = the user with the error

How to correct the source system type ?

On the source system, delete the self-reference withe the function module RSAP_BIW_DISCONNECT. On the BW system, restore the source system.