Designer: Display environment one is connected to

Is there an easy way to display and preferably permanently display the environment one is in? To me this is a security feature. I am thinking along colouring like many DB tools allow.

Nope, there is none. I double checked with SAP support. The data store pane displays the repository one is connected to. If you need to know the server you can look in the environment section of Designer in the options. Or start the switch object library dialogue.

Designer: Overview on checked out objects

Like the status command of subversion but graphically? There is none. I double checked with SAP support.

Designer: User defined transformation optiones pane empty

Looks like

Reason is unknown but the workaround (proposed in KBA 2520817) is to run Designer as administrator. I had been talking to SAP support hinting me to the workaround and KBA. They also sayd I should expect problems now and then when running Designer under an unprivileged user.

[Update]
After having run Designer as administrator the option pane is now filled even though I do not run Designer as admin...
Is the need to run Designer as administrator in order to initialise some things? World of wonder...

Push down: Why is there no full push down done?

Following has to be met by the data flow to be able to push down completely.

• Join sources of the same data store (or with database link between them)
• Load operation must not contain triggers
• Only query transforms used, no other transforms
• No use of un-pushable functions and operators in expressions, see SAP Note 2212730:
• ...
• But at least to_date is UN-pushable when thrown against timestamp database column, see Data services: to_date inhibits push down
• No use of un-pushable transforms , see SAP Note 2212730:
• ...

Stored procedure: Why can't I import overloaded stored procedures?

Overloading just not supported.

Stored procedure: How can I call a stored procedure with boolean parameter?

You cannot!!!
@#!"*#!!, you need to create one or more wrapping stored procedures handling the boolean parameter.

Custom functions: Why can't I create recursive function calls?

This is only possible when directly calling the calling function, i. e. the function calls itself. Indirect calls, i. e. over intermediary functions, are inhibited.