How to find User Exits or BADIs for a particular program?

Refer to the link below:
Methods to find customer user exit or badi for a program

How to debug SAP Standard Table

1. Go to SE16
2. Enter the Table
3. Enter the Selection Screen
4. Execute
5. Select the row that you would like to edit and click display
6. Once you are displaying the particular row, enter /h
7. Press Enter
8. In debug mode, double click on if code = 'SHOW'.
9. Change the value from show to EDIT
10. Click F8
11. You can also perform other activities like INSR, DELE

Excel Functions

=COUNTIF(J2:J2,"<"&TODAY()-7)
Where J2 is the Created Date. From the example above:

• If the Created Date is later than 7 days, then the Excel function will return as a Red column and with value 1. 
• If the Created Date is less than 7 days, then the Excel function will return as a Green column and with value 0.

MM Opening previous period

SAP Steps for Opening previous period in MM

If you want to open previous period for reversal entry or additional entry
The following are steps for Opening previous period in MM :

1. Go to TCode SU01 (see OSS NOTES 487381)
2. Choose "change" tab with your loging Name
3. Choose "Parameter" tab
give Parameters MMPI_READ_NOTE with date format as YYYYMMDD
(say today 20071201)
4. SAVE.
5. Go to T-code MMPI
6. open the old periods which you want to post into,