SAP Table analysis (TAANA)

During the migration of data sometimes it is good to check the sum of positions in tables. In case of multiple table analysis, transactions SE16 / SE11 are quite uncomfortable because it may not be executed in background and cannot be planned for certain time.
In that case, the transaction TAANA (Table Analysis) may be used.
Click “Start table analysis”

Define the table, click on icon for selection of variant.

Click “Ad Hoc Variant”

Select necessary accumulation level fields:

Click continue to go back to table selection popup and click data selection.

Select there necessary selection parameters and start the analysis in background or online. In my case I use always in the background.
After finishing the job check the results, here is the example from GPLCT:

This analysis is fine, but still for me too complicated… I need do such activities for each table.
The solution is to execute the program and fill required data directly in selection screen.
Start the program ARCH_ANA_PROCESS with SE38/SA38:

Here, fill the table name, variant: AD-HOC and fields for accumulation level and execute / plan the job in background.
The only negative thing is, that I may not strict the selection.
After the finishing of job you may find the result in TAANA under AD-HOC variant.
The positive is that I may prepare variant and plan the jobs for certain time.

Unlock the entry in SAP

Sometimes during tests I try to use (post, or edit) the locked object, which is already processed in parallel by me or another colleague. The message is something like that: “The object xxxxx is being processed by user xxxx”.
In the transaction SM12 delete the locked object:
Then I may test without interruption further.

Posted in SAP

Debug without command field in SAP

Sometimes I need to debug, but the command field for /h is not available.
For example, I need to debug after clicking on OK in Bar code pop-up:

Just drag and drop the shortcut, for example,  “Debug.sap” to the pop-up and debug mode will be activated.

Text of the file:
[Function]
Title=debug
Command=/h
Type=SystemCommand

Or download following file: Debug.zip (unzip it).

Posted in SAP

Edit table with SE16

If the transaction SE16n is locked in the system, or only single line should be edited, then there is an alternative to edit the line of table with transaction SE16.
Diplay the line:

Activate the debug modus (/h).
Then just select one field and click enter, debug modus starts:

Now you may change, add, delete the line.
Change the variable ‘CODE’ to required value (initially ‘SHOW’):

Then execute the code (F8).
Example of  ‘EDIT’:

Bingo!

 

Change status of configurable message

If the message status is customizable, like on screenshot below, the status may be changed in tables T100S and then T100C.

OBMSG (or SM30 on T100S)- Change the status on system level
OBA5 (or SM30 on T100C) – Change the status on user level
Change on system level is cross-client change. Here allowed message status defined and activated:

The change on the user level defines the status  for for all or for specific user:

To check, if message is customizable, normally I set break point on function module READ_CUSTOMIZED_MESSAGE and T100S_READ.
In most cases it works.