Category Archives: Basis

SQVI – Create quick report

In an earlier post I promised to give a quickguide to creating a query in SAP based in transaction SQVI. I’m going to show you how you can quickly build a custom report for reporting Sales Schedule Lines based on different filter criteria and multiple tables (VBAK, VBAP and VBEP: header, item and schedule line data resp.):

Continue reading


Test standard LIS analyses with different source versions

There are wonderful reports available in standard SAP’s Information Structures (E.g. MCxx reports). It can be so cruel though when data gets corrupted. You usually end up comparing report figures with whatever reasonable value you find elsewhere in SAP. If you want to be sure about the Information Structure’s reliability it is worthwhile to update an infostructure (say S021 – Production Order), store it under a temporary version ‘&(1’, and finally call this test version in a report that default uses version ‘000’.

To call up another version than ‘000’ go to System > User profile > User parameters and enter the parameter ID ‘MCR’ with the value ‘X’.

Parameter MCR

Parameter MCR

Now if you call up a standard analysis like MCP3 – Production Order Analysis a new field is visible for version selection. See picture below.

MCP3 - New version field

MCP3 - New version field

The major benefit of this procedure is that you don’t have to backup/delete current production data in version ‘000’.

It is also possible to compare the current version ‘000’ with the new test version going to Menu > Edit > Comparisons > Planned/Actual…

Printing barcode labels in SAP R/3

Last week I spent some time finding out how to implement barcode printing in SAP. As usual I googled the internet and a couple of alternatives were flung at me: middleware, hardware vendor applications, installing fonts, etc.

Interestingly enough there is one very simple solution: using the standard barcode font that SAP standard offers for SmartForms.  You wonder why there are so many alternatives while SAP already includes the easiest one. The main requirements for printing barcodes this way are:

Continue reading

Change log SE16N

In SE16N you can change SAP tables directly. I explained how to in a previous post. I also warned for the risks involved in doing this. Luckily direct changes in SAP tables are also logged, so you can trace back to the culprit who messed things up. You can query the following SAP tables to report on hacks:
SE16N_CD_KEY : Change Documents – Header
SE16N_CD_DATA : Change Documents – Data

Decimal separator

Aaaaargh! This can be frustrating in reporting out of SAP into Excel: decimals are considered thousands separator or numbers are not recognized at all as a number. There are three settings involved. To properly solve this issue:

  1. first check what is the standard decimal figure used in your company. Then check if this is also used in SAP (System > User profile > Own data ).
  2. then check the regional settings of Windows (in XP look in Control Panel). The regional settings also determine the decimal settings. Make sure this is also in sync.
  3. finally check Excel options (Tools > Options ). Either use system settings or enter the figures manually.

Now you are set to avoid frustration.

XP control panel

XP control panel

Transaction variant

Lots of clients who wish to make their SAP transactions dummy-proof by making fields mandatory, closing fields for editing or craving for default values. Different paths to Rome here, but one powerful solution being offered through transaction SHD0 in conjunction with SE93. The first transaction allows you to create a transaction variant where it is possible to hide fields, make them mandatory, add default values, add voice recognition, opt for world peace, etc. OK so the last two maybe not, but the message is: “you can do a lot of modifying here.” The second transaction SE93 allows you to link the variant to a new home made transaction code. Your customer will love you till the end of times because of this.