1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

Tips

SO36 Auto Forwarding

Friday, 20 April 2018 00:45

it is an interesting tip, have you guys ever thought of auto forwarding the emails coming into your SAPOffice Inbox?

Use SO36 transaction to achieve the same, input values are self-explanatory, I guess, I need not spend time in explaining each and every input field.

 

{fcomment} {flike}

Share

SO36 Auto Forwarding

ICONS in SM02

Friday, 20 April 2018 00:45

 

Do you want to use ICONs while posting a system message? Here is the tip to make it work.

Having an icon like warning/alarm will make the system message more attractive, for example, the same can be done by having the icon code inside the message.

To get to know the icon codes, go to SE16 - ICON -> Download the list into an excel sheet to get the code that you may want to use it in the system message.

Once you have the code with you, post the message text with the code attached to it, for example, @1D@ System will be down in another few minutes time, please log off.

 

{fcomment} {flike}

Share

ICONS in SM02

Datafile Table Relation

Friday, 20 April 2018 00:45

Which datafile contains my table in Oracle? How do I find it out

You can use the below query to find out the datafile in which a particular table is stored, this is an interesting topic when you get into issues like block corruption.

SQL> select a.segment_name, a.tablespace_name, b.file_name from dba_extents a, dba_data_files b where a.file_id = b.file_id and a.segment_name='VBAK';

{fcomment} {flike}

Share

Datafile Table Relation

Tips and Tricks