BATCH PROCESSING

[Former Member]

Hi all,

can anyone give me interview questions on BATCH PROCESSING.

thanks

Ab

[Former Member]

Hi,

What is BDC programming?- Transferring of large/external/legacy data into SAP system using Batch Input programming. Batch input is a automatic procedure referred to as BDC(Batch Data Communications).The central component of the transfer is a queue file which receives the data vie a batch input programs and groups associated data into “sessions”.

What are the functional modules used in sequence in BDC?- These are the 3 functional modules which are used in a sequence to perform a data transfer successfully using BDC programming: BDC_OPEN_GROUP - Parameters like Name of the client, sessions and user name are specified in this functional modules. BDC_INSERT - It is used to insert the data for one transaction into a session. BDC_CLOSE_GROUP - This is used to close the batch input session.

What should be the approach for writing a BDC program?

ANS:-

STEP 1: CONVERTING THE LEGACY SYSTEM DATA TO A FLAT FILE to internal table CALLED “CONVERSION”.

STEP 2: TRANSFERING THE FLAT FILE INTO SAP SYSTEM CALLED “SAP DATA TRANSFER”.

STEP 3: DEPENDING UPON THE BDC TYPE i ) call transaction(Write the program explicitly)

ii) create sessions (sessions are created and processed. if success data will transfer).

What is a batch input session?

ANS:-

BATCH INPUT SESSION is an intermediate step between internal table and database table.

Data along with the action is stored in session ie data for screen fields, to which screen it is passed, program name behind it, and how next screen is processed.

. What is the alternative to batch input session?

ANS:-

Call transaction.

A situation: An ABAP program creates a batch input session.

We need to submit the program and the batch session in background. How to do it?

ANS :-

go to SM36 and create background job by giving

job name, job class and job steps (JOB SCHEDULING)

. What are the problems in processing batch input sessions?

How is batch input process different from processing online?

ANS:-

PROBLEMS:-

i) If the user forgets to opt for keep session then the session will be automatically removed from the session queue(log remains). However if session is processed we may delete it manually.

ii)if session processing fails data will not be transferred to SAP database table.

. What do you do when the system crashes in the middle of a BDC batch session?

ans:-

we will look into the error log file (SM35).

What do you do with errors in BDC batch sessions?

ANS:-

. Setting up a BDC program where you find information from?

ans:-

. What has to be done to the packed fields before submitting to a BDC session.

ans:-

fields converted into character type.

What is the structure of a BDC sessions.

ans:-

BDCDATA (standard structure).

What are the fields in a BDC_Tab Table.

ans:-

program,dynpro,dynbegin,fnam,fval.

We look into the list of incorrect session and process it again. To correct incorrect session we analyize the session to determine which screen and value produced the error.For small errors in data we correct them interactively otherwise

modify batch input program that has generated the session or many times even the datafile.

How do you set up background jobs in SAP? What are the steps? What are the event driven batch jobs?

ans:-

go to SM36 and create background job by giving job name,job class and job steps(JOB SCHEDULING)

Advantages & Disadvantages of different types of BDC’s?

Ans Transaction Method:

1) It is faster than session method.

2) While executing, it starts from starting.

Session Method:

1) It is slower than transaction method.

2) While executing, it does not start from starting.

How to write a BDC - how do u go about it?

Ans Steps for writing BDC

1) /nSE38

2) Declare Tables, Data (for ITAB) and Data (for BDCITAB)

3) Call function ‘Upload’.

4) Write code for the First Screen, Radio Button, Filename, Change Button, Second Screen, Utilities (Create Entries), Third Screen and Save.

5) Call transaction ‘SE11’ using BDCITAB mode ‘A’.

6) Save, Check Errors, Activate and Execute.

What are the function module in BDC?

Ans There are three function module in BDC:

1) BDC_OPEN_GROUP

2) BDC_INSERT

3) BDC_CLOSE_GROUP

http://www.geekinterview.com/Interview-Questions/SAP-R-3/BDC

some of the interview que are:

In session method sy-subrc is not returned whereas in call transaction method sy-subrc is returned In session method sy-subrc is not returned whereas in call transaction method sy-subrc is returned . what does it mean?i dnt know Read Answers (9) | Asked by : priyaAnswer Question Subscribe

-

-

---

Have you set up a back ground job ? How to create a background job without a variant ?Latest Answer : For background job submission use tcode sm36, display sm37 (t.c se37 for function module). ...Read Answers (8)Answer Question Subscribe

-

-

---

Update types in Call transaction method. What is the difference ?Latest Answer : All synchronous update the sy-subrc is set to 0 only when the particular transaction is executed and also the changes have done to the database,But in asynchronous update the sy-subrc is set to 0 if  the transaction is executed without any fail, not ...Read Answers (6)Answer Question Subscribe

-

-

---

How to load data from MS Excel sheet to SAP by using BDC method ?Latest Answer : KCD_EXCEL_OLE_TO_INT_CONVERT even takes care of blank cells and is available in older versions of SAP* Add values to internal table ...Read Answers (5) | Asked by : pankaj.delmadeAnswer Question Subscribe

-

-

---

Call transaction method, how to capture the errors ?Answered by shyam on 2005-05-09 15:56:32: create a log file by using BDCMSGCOLL. Latest Answer : using bdcmsgcoll function module ...Read Answers (4)Answer Question Subscribe

-

-

---

What is the difference between Upload and WS_Upload ?Latest Answer : Hi,UPload : uploading file from presentation sever to internal table with use of dialog is possible in upload function & here file name & file type are asked at run time with prompt.Ws-Upload : uploading file from presentation server to internal table without ...Read Answers (4)Answer Question Subscribe

-

-

---

How to do back ground processing in BDC Session method ?Latest Answer : go to sm35 and create a variant for background processing. ...Read Answers (4) | Asked by : pankaj.delmadeAnswer Question Subscribe

-

-

---

What are the table controls in BDC ? what is the difference between bdc and lsmw ?what is the differenceWhat are the table controls in BDC ? what is the difference between bdc and lsmw ?what is the difference between bdc and rfc ?Read Answers (4) | Asked by : pavendhanAnswer Question Subscribe

-

-

---

What is the difference between call transaction and session method?Latest Answer : Call trasaction method trasfers non sap data into sap immediately after completion of BDC, whereas session method creates the session and transfers data when user seesions it. It tranfers data one by one whereas trasaction method transfers data all together. ...Read Answers (4) | Asked by : Raghu PagidiAnswer Question

Regards,

Satish

[Former Member]

Hi,

Batch Jobs: The data in the legacy system needs to be uploaded into sap to have all the data at one place.There are various ways in which a the data can be uploaded into the sap system. One which is used normally by the functional guys is LSMW and ECatt. They help fast data uploads. LSMW is mainly used for master data upload. The master data is uploaded directly into the production server. Only pieces of such master data would be there in test client for testing purpose. The configurations and developments are done in the development server and tested in quality and finally have them moved to production. Apart from LSMW, Bapi's and BDC's ( Session and Call transaction method ) are used to upload data into SAP. While uploading data the previous legacy data is converted into a flat file ( generally an excel or notepad file) which is read by sap and put into sap. The flat file is cleansed and purged to remove redundant data, and ensure data consistency.

http://sap-img.com/sap-data-migration.htm

BDC (Batch Data Communication) is a technology used for data transfer. it is meant for transferring data thru SAP transactions itself. when u use BDC for data transfer, the sequence of steps is the same as when u use standard sap transaction screens for data upload. the only difference is that u can use different options for foreground/background processing.

http://www.sapbrainsonline.com/TUTORIALS/TECHNICAL/BDC_tutorial.html

http://www.sap-img.com/bdc.htm

With regards,

Raj.