Archive for June, 2006

Batch Input vs CALL TRANSACTION

Friday, June 30th, 2006

SAP ABAP Interview QuestionsQuestion 9: What is the difference between Batch Input and CALL TRANSACTION?

Batch Input and CALL TRANSACTION are both data transfer methods. Batch Input usually are used to transfer large amount of data. For example you are implementing a new SAP project, and of course you will need some data transfer from legacy system to SAP system. If there is no standard batch input program, direct input program, you would need to write your own data transfer program and it is going to be batch input program. CALL TRANSACTION methods is real-time method, whenever you run the program CALL TRANSACTION can be triggered. CALL TRANSACTION is used especially for integration actions between two SAP systems or between different modules. Users sometimes wish to do something like that click a button or an item then SAP would inserts or changes data automatically. Here CALL TRANSACTION should be considered. You use CALL TRANSACTION and you do everything automatically, collect necessary data, call transaction and so do database update. If any error occurs, show the user them.

(more…)

Data Transfer Methods

Thursday, June 29th, 2006

SAP ABAP Interview QuestionsQuestion 8: What are data transfer methods?

Data is transferred from an external system into the SAP R/3 System. You use data transfer when you:

  • Transfer data from an external system into an R/3 System as it is installed.
  • Transfer data regularly from an external system into an R/3 System.

There are three basic methods for Data Transfer:

(more…)

Batch Input

Thursday, June 29th, 2006

SAP ABAP Interview QuestionsQuestion 7:What is Batch Input?

Do you need to transfer data into the R/3 System? So you can use Batch Input. Batch Input is one of primary ways in which data can be transferred into the R/3 System. Batch Input is used for bulk data transfers and not for near real-time data transfers.

Typical uses of Batch Input include the one-time import of data from legacy system into a newly installed R/3 System. Another typical use is for periodic (hourly, daily, …) transfers of data from external systems or legacy systems that are still in use into R/3, where all enterprise data is consolidated.

(more…)

Interactive Reports in ABAP

Thursday, June 29th, 2006

SAP ABAP Interview QuestionsQuestion 5: What is an interactive report?

Question 6: What is the difference of an interactive report compared with a classical type of report?

If you write ABAP programs, you mostly write report programs. The first type of reports programs are read-only classical report programs that show the data once. But then users say that “I want to run the report then I want to expand the result by clicking these items on result screen.” So it is time write interactive reports. Interactive means report results are clickable.

(more…)

Events in ABAP

Monday, June 26th, 2006

Question 4:SAP ABAP Interview Questions Series What are the events in ABAP?

ABAP/4 is a fourth-generation language (4GL) but it is an event-driven language. It has a few events. But don’t confuse about ABAP Objects and events of them. Event blocks are introduced by an event keyword. They end when the next block begins. The following block can be another event block, introduced by a different keyword, or another processing block that is valid in the context, such as a subroutine or dialog module. Event keywords have the same name as the events to which they react.

The sequence in which processing blocks occur in the program is irrelevant. The actual processing sequence is determined by the external events. However, to make your programs easier to understand, you should include the event blocks in your program in approximately the samer order in which they will be called the system. Subroutines should be placed at the end of the program.

(more…)

Open SQL vs Native SQL

Monday, June 26th, 2006

SAP ABAP Interview Questions SeriesQuestion 2: What is Open SQL vs Native SQL?

Question 3:What does an EXEC SQL statement do in ABAP? What is the disadvantage of using it?

If you write a business application, there is always a database on backend. So SAP R/3 uses a database too. It is a
special database? No. SAP uses standard databases like Oracle, IBM DB2, MS SQL Server, etc. If you have a database on backend, it is inevitable that you must use SQL. SAP uses SQL to select, insert and update data inside database. However, the problem is that if you use different databases, your code whatever it is whether ABAP or not, SQL can vary. In that situation although programmers tend to use Standard SQL which is valid for all databases, the problems sometimes occur to switch one database to different database. What I am trying to say is SAP had invented a new way to solve this problem: Open SQL

(more…)

The Structure of an ABAP Program

Saturday, June 24th, 2006

SAP ABAP Interview Questions SeriesQuestion 1: What is the typical structure of an ABAP program?

I saw the answer for this question like that Header, Body, and Footer. Is it really like that? I am not sure :(

There are basically two kind of ABAP programs that are Report Programs and Dialog (Module) Programs. Report Programs for, as you can guess, reports and they are naturally read-only program in general. When you write report programs you don’t have to worry about screens, SAP would create screens for you. But when you develop module programs you have to design screens with all details like text, input boxes, radio boxes, check boxes and everything. Even the flow of the program changes.So actually the structure of an ABAP program differs for each report and module programs. Sure you can combine report and module programs together in one program, since both are ABAP programs

(more…)

SAP ABAP Interview Questions Series

Thursday, June 22nd, 2006

SAP ABAP Interview Questions SeriesI am currently looking an SAP ABAP Developer consultancy position. It is not very easy to search a job and get it in USA. I say searching a job is like a full time job. USA is a country that has a very competitive market in all areas. If you look at positions on websites, you can see a lot of open positions. It seems it is a very good market. But when you approach these positions like looking description, requirements of the position and contacting the people, you will see that there are a lot of positions which are exactly the same position. It means many people who are recruiters look a consultant for the same position. There is one open position, but there are a lot of postings on job search websites for this position. It is very rare the company looks a consultant for itself. Sometimes even it is very hard to choose the recruiter for contacting. When you contact the recruiters, sometimes they don’t know any technical information. They usually don’t say the customer / company name. They are getting your resume than submitting to the customer, if the customer like your resume, next step is a technical interview on phone.

(more…)

Shai Agassi The NetWeaver Guy

Thursday, June 22nd, 2006

Shai Agassi The NetWeaver GuyIt is great. Shai Agassi is the NetWeaver Guy. I am not kidding that Shai Agassi, SAP Executive Board Member, is the NetWeaver Guy like superman.

The video starts like that: Shai Agassi’s Office 2:29 am. Shai speaks himself:

Man I have so much to do and so little time. I need to get world about SAP NetWeaver and up to me to convince entire organization how important this is. Henning is accounting on me, marketing and sales is accounting on me. There is so much writing on this. But how can I get it all done on time? Forgot some sake of superman, superman …

And then he is asleep, and a dream starts… Watch his dream!

(more…)

Game for SAP Folks

Wednesday, June 21st, 2006

SAP INFO - Soccer GameSAP Folks, it is time to play game. Even you can win a prize by playing the game. SAP INFO Magazine has a competition called SAP INFO Soccer Competition. Don’t wait start SAP INFO’s Genius’ the soccer game immediately and get a chance to win a prize.

The first 400 participants will each receive a SAP INFO tournament planner. At the close of the competition, closing date is July, 10, 2006, 3 participant will be drawn and each one will receive a high-quality iPod. Don’t miss it! After playing the game you fill out entry form and send online. That’s it!

Actually this is not the only game of SAP INFO. There are also several different games. My understanding is SAP INFO does this kind of competition frequently.

(more…)