SAP export data to local file

Sometimes, you need to export data to local file. Even if you need to export as a txt file (to import it somewhere else), or as a spreadsheet (for further data manipulation or reporting), you need it to export it. So, let’s see how we may do that. The simple way it is to export from ALV reports. Those reports are builded more or less as a spreadsheet. Most (if not all) of these reports have available a button, “local file” . Just click it and a popup with available export formats appear…Read more …

SAP report data manipulation

Let’s talk a little bit about data from SAP report manipulation. First of all, you need to run a report. For exemplification, I run MB51 for a certain period of time. We will see a list of data (materials document in our case) and we need some basic data manipulation. First of all, we may use “filter” button witch can be use to filter certain data. Just click into header, onto one column we need to refine, click into “filter” and a new box, with available filter values appear. In our case, I…Read more …

SAP multiple selection

Most of the time when we need a SAP report, we need multiple selections. That means we need to select certain values, certain intervals or, we need to exclude certain values or certain intervals. Let’s take a look about what we may use. When we need to find report for certain value, in the selection box of the report we put that value into box 1 When we need to find report for certain interval, in the selection box of the report we put minimum value into box 1 and maximum value into…Read more …

SAP help and selection screen

Let’s talk a little bit about help. To access HELP for a field, just click that field and hit the yellow button with a question mark or just hit F1 key from keyboard. This will open Performance Assistant and let you know some information about that field.as for example, take a look at performance assistant for Material field, from MIGO Tcode.   Another very good trick it is “selection screen”.Basically, when we have a list of values for a certain field, a small “list” button will appear on the right side of the…Read more …

SAP Useful tricks for screen

Now, that we start to understand SAP screen and menu, let’s talk a little bit about some useful tricks. I start with my favorite. Add transaction code to the screen.Almost all SAP configurations don’t show, by default, transaction codes. Let’s take a look. As you may see, the Tcode is missing. To make it appear, let’s do some “magic trick”. Extra>Settings And now check “display technical name” Hit “Enter” or click on the green button, and now let’s take a look. We will see that Tcode appear for each stransaction   Now, the…Read more …

SAP Favorites

Now, that we start to understand SAP screen and menu, let’s talk a little bit about some useful tricks. First of all, none of you will use more than, let’s say, 40- 50 transactions and reports. And maybe 10 of them usually. So, we need to remember SAP transaction code (Tcode) for those witch we don’t use it on a daily base. Maybe we have an elephant memory, and memorize 50 TCodes it’s not a problem (even so, let’s try to imagine 20 of them in format S_ALR_87099918 and we have a big…Read more …

SAP Transaction & SAP Transaction codes

What it is a SAP Transaction?A SAP transaction it is a code, compose by letters and numbers, who run a SAP task or a SAP program.What it is a SAP task or a SAP program it is not very interesting for a SAP user, but a transaction it is very important. Basically, running a SAP transaction, a user made SAP system to do something. A SAP transaction have a code, compose by letters or by letters and numbers. For example, MIGO or MM01 are SAP transaction codes. By running this, you, as a…Read more …

SAP standard bar

Let’s discuss a little bit about SAP standard toolbar. It is called „SAP standard toolbar” because appear on any SAP screen you will see. Have following buttons. Enter button. Can be clickable or can be replace by hitting „Enter” key on the keyboard. Command field. Here you may enter manually SAP transaction codes. Also, last 10 used transactions can be view by clicking the „down” arrow. Close command field and open command field. If it is clicked, will close command field, SAP standard toolbar will look like You will see that “close command…Read more …

SAP main screen, SAP System menu and SAP Help menu

Last time we succeed to connect to the SAP. Now, let’s speak a little bit about what we see. Menu bar. This bar show available menu and it’s changing from screen to screen. But “System” menu and “Help” menu are the same and available to all SAP screen we navigate; Standard toolbar it is available to all screens we use. But not always all the buttons are available. Title bar. It is available to all screen we use, but suffer small changes, depending on the screen we are. But always here appear the…Read more …

SAP first experience

OK, so you should start to work in SAP. Somebody provided you with a computer, some settings, a user and a password. Normally, you should have at least an introduction training, but let’s review together the first steps. First step, look into your desktop, or application tree, for a icon which should be like this one This is, normally, the SAP GUI launch icon. What is SAP GUI? SAP it is not just a program or just an application. SAP it is a huge platform. Basically, you need to know that SAP has…Read more …