Wednesday, January 30, 2013

SAP Sessions and Memories

There are different kind of SAP Sessions and Memories that you may use in your programming techniques. In every user or login in SAP, the system creates several so called EXTERNAL Session which contains and has an access in so called SAP Memory through get/set parameter (will discuss this vividly later). Inside the external session, there is another session called INTERNAL Session which composes of different running programs and an ABAP Memory. Each of these programs inside the internal session may access data in the ABAP Memory whereas, SAP Memory may access by the programs within the internal session of the external session. 

Sessions and program relationship:

Monday, January 28, 2013

Confused of SAP LUW and DB LUW?

First of all, let's define LUW ( Logical Unit of Work). LUW as it name implies, it is a series of processes or work in an SAP system which are logically related. For example, one of the processes requires to add the name and employee number in a separate table at the same time or in one instance. Therefore, it is critical to the process to save (commit work) both the name and the employee number at one instance or do nothing at all (roll back).

DB LUW (Database Logical Unit of Work) is simply a generic term being used in referring to database maintenance in logical way i.e commit and roll-back done synchronously or asynchronously.

SAP LUW (SAP Logical Unit of Work) comprises of more than one dialog steps and this is the way SAP handles its DB LUW. To ensure the consistency of database changes, commit and roll back command should be included in the program. There is a technique to ensure consistency of data update within SAP LUW by bundling.

Three type of bundling techniques being used in SAP LUW:

1. Bundling using Function Modules for Updates by using CALL FUNCTION... IN UPDATE TASK
2. Bundling Using Subroutines by using PERFORM ON COMMIT
3. Bundling Using Function Modules in Other R/3 Systems by using CALL FUNCTION... IN BACKGROUND TASK DESTINATION...

Monday, January 14, 2013

I got my ITIL Certificate!

ITIL Certification is based on the IT Best Practice on Service Management. Advantages of having this are:

based on ITIL Official Site
  • improved IT services
  • reduced costs
  • improved customer satisfaction through a more professional approach to service delivery
  • improved productivity
  • improved use of skills and experience
  • improved delivery of third party service.
An electronically signed certificate :

Sunday, January 13, 2013

Value and Check Table

Value and Check tables are both transparent tables and differs only on the context in where they are being used. An SAP table being used in a domain is called value table and it can be found in the value range tab as shown below:

In an ALV grid, if you want to create a drill down help popup window or F4 function, you may either choose Single Values (limited to 10 characters), Intervals, or Value table. In choosing Value table, you need first to create you transparent table, usually contains columns for the value you want to display in your ALV and the description of that particular value, and populate your records or entries as shown below:

Typically, in ALV F4 function, the popup window being shown will contain the Single values unless you made your transparent table as the check table of your ALV table as shown below:

So, the question is, how this value table becomes a check table. The answer is simply making the component or the field of the table above as foreign key by clicking the button that looks like a key:

Below is the window to make the table as check table and you may also add the columns in the F4 popup by making it as primary key.

In my case, MANDT, ACTION, and DESCR fields are the primary keys. Therefore, if the user clicks the drill down or F4 button, the below window should appear:

NOTE: Check table is used to validate the data being inputted - foreign key table level. Value table will contain the data for check table - domain level. Search help should contain the values of the table specified on the parameters. Therefore, if there are check table and search help, search help's table values will be shown and check table will be used as look up for the value being inputted in either selection screen or alv grid cell.

Until next time!

Have a great day!