Category Archives: Basis

SQVI – Create quick report

By Kowboy | Published: January 23, 2009
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 [...]
Posted in Basis | Tagged , | 8 Comments

Test standard LIS analyses with different source versions

By Kowboy | Published: January 14, 2009
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 [...]
Posted in Basis | Tagged , | Leave a comment

Printing barcode labels in SAP R/3

By Kowboy | Published: November 13, 2008
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 [...]
Posted in Basis | Tagged , , , | 6 Comments

Change log SE16N

By Kowboy | Published: November 11, 2008
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 [...]
Posted in Basis | Tagged | 1 Comment

Decimal separator

By Kowboy | Published: October 28, 2008
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: first check what is the standard decimal figure used in your company. Then check if this is also [...]
Posted in Basis | Tagged | Leave a comment

Customizing Change Log

By Kowboy | Published: October 28, 2008
To review changes in customizing / IMG use transaction code SCU3. Make sure that logging is activated for the client. The system will ask you to do so and give instructions if it isn’t.
Posted in Basis | Tagged | Leave a comment

Transaction variant

By Kowboy | Published: October 26, 2008
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 [...]
Posted in Basis | Tagged , | Leave a comment

Edit SAP tables

By Kowboy | Published: October 26, 2008
No matter security on table editing. When in transaction SE16N use the command &SAP_EDIT in the command field in SAP and off you go: edit table content directly. Know what you are doing cause this is far from a best practice way of changing data and can screw up things pretty bad if you don’t [...]
Posted in Basis | Tagged , | 9 Comments

Transaction usage history

By Kowboy | Published: October 26, 2008
A very useful tool to track usage of transaction: ST03N and STAD. This transaction can report on different levels how often a specific transaction is used and by which users. This can be handy in determining authorization profiles after Golive. It can also be used by Big Brother to check whether end user testing has [...]
Posted in Basis | Tagged , | Leave a comment