Select Category 
 

SAP BDC Interview Questions Answers

SAP BDC Interview Question - 1 : -

Update types in Call transaction method. What is the difference ?

SAP BDC Interview Answer - 1 : -

At present with SAP we have only modes of updation
1.Synchronus Update.
2.Asynchronous Update.
There is no more Local Update.
 

SAP BDC Interview Question - 2 : -

Data conversion experience?

SAP BDC Interview Answer - 2 : -

DATA CONVERSIONS:
SAP HAS PROVIDED A TOOL NAMED LSMW WHICH CONVERTS THE LEGACY DATA INTO THE REQUIRED SAP FORMAT AND UPDATES THE DATABASE.
 

SAP BDC Interview Question - 3 : -

How to do back ground processing in BDC Session method ?

SAP BDC Interview Answer - 3 : -

goto sm35
select the option background process
 

SAP BDC Interview Question - 4 : -

Call transaction method, how to capture the errors ?

SAP BDC Interview Answer - 4 : -

IN CALL TRANSACTION TO CAPTURE THE ERRORS WE SHOULD PERFORM THE FOLLOWING.
FIRST ME MUST DECLARE AN INTERNAL TABLE WITH THE STRUCTURE OF BDCMSGCOLL TABLE.
THEN WHILE WRITING THE CALL TRANSACTION STATEMENT WE SHOULD PUT THE 'E' MODE FOR CAPTURING ALL THE ERRORS.
THEN FINALLY THE CAPTURED ERRORS MUST TO SENT TO THE INTERNAL TABLE WHICH WE DECLARED IN THE BEGINNING WITH BDCMSGCOLL BY USING THE FUNCTION MODULE "FORMAT_MESSAGE"
AND THUS THE ERROR MESSAGES WILL BE SENT TO THE INTERNAL TABLE WHICH WE DECLARED AT THE BEGINNING.
 

SAP BDC Interview Question - 5 : -

Have you set up a back ground job ? How to create a background job without a variant ?

SAP BDC Interview Answer - 5 : -

Yes, user can create background job scheduling in two ways.

1. By calling the executable program RSBDCSUB
2. Transaction Code SM37

 

SAP BDC Interview Question - 6 : -

In session method sy-subrc is not returned whereas in call transaction method sy-subrc is returned . what does it mean?

SAP BDC Interview Answer - 6 : -

While to transfer the data from the through if any errors occurs until the errors are the complete the data is not transfer to the SAP system.
the system compulsory shows the errors. that errors are stored into the error logs (Transaction is SM35).
so the session method should not return any value.
In call transaction method data is directly pass to the SAP system.
So its compulsory return the value.
Because of the call transaction is the function.
A function should return the value mandatory.

Recording Function
With recording, user can avoid manual search for fields and tables required in a program including screen numbers. SHDB is the transaction code.

BDC vs Direct Loads( have you used direct loads on SAP tables )
Direct loads is 5 times faster than uploading by normal BDC method. but some times while updating the database referential integrity is violated.

 

SAP BDC Interview Question - 7 : -

How to load data from MS Excel sheet to SAP by using BDC method ?

SAP BDC Interview Answer - 7 : -

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
SORT t_cells BY row col.
LOOP AT t_cells INTO wa_cells.
MOVE : wa_cells-col TO l_index.
ASSIGN COMPONENT l_index OF STRUCTURE itab TO <f_value>.
MOVE : wa_cells-value TO <f_value>.
AT END OF row.
APPEND itab
CLEAR itab.
ENDAT.
ENDLOOP.

 

SAP BDC Interview Question - 8 : -

What are the table controls in BDC ? What is the difference between bdc and lsmw ? What is the difference between bdc and rfc ?

SAP BDC Interview Answer - 8 : -

BDC - Batch data communication in which there are 2 processes
1. in bound
2. outbound
RFC - remote fucntion call(or) calling
 

SAP BDC Interview Question - 9 : -

How to read files and process BDCs automatically?

SAP BDC Interview Answer - 9 : -

To read file from Presentation server use Upload or GUI Upload or WS upload and to read file from Application server use Opend Dataset,Read dataset and Close dataset
 

SAP BDC Interview Question - 10 : -

If I want to execute a program only in background not in foreground is there any option for this?

SAP BDC Interview Answer - 10 : -

The sm37 transaction can be used for running a program in the background. Also in the session method while processing the session you can specify the processing type as background or foreground.
 

SAP BDC Interview Question - 11 : -

What kind of BDC programs are written ?

SAP BDC Interview Answer - 11 : -

There are five types of BDC methods available. They are 1.Batch input session 2.Call Transaction 3.Recording 4.Direct Input and 5.LSMW
 

SAP BDC Interview Question - 12 : -

Open datasets, Read datasets ( Reading and writing data to files)?

SAP BDC Interview Answer - 12 : -

Date Sets are nothing but files on Application Server,they can even be called as Sequential files.
Open Dataset
Is used to open required file on the application Server.
Read Dataset.
Is used to read the contents required file on the application Server.
 

SAP BDC Interview Question - 13 : -

What is the difference between call transaction and session method?

SAP BDC Interview Answer - 13 : -

Session method: The records are not added to the database until the session is processed. sy-subrc is not returned. Error logs are created for error records. Updation in database table is always Synchronous.

Call Transaction method: The records are immediately added to the database table. sy-subrc is returned to 0 if successful. Error logs are not created and hence the errors need to be handled explicitly. Updation in database table is either Synchronous or Asynchronous.

 

SAP BDC Interview Question - 14 : -

What is the difference between Upload and WS_Upload ?

SAP BDC Interview Answer - 14 : -

The diffrence between WS_Upload and Upload is when you use function Upload it prompts for a dailog box where in you need to key in the file location.Where as in case of WS_Upload you specify the file location in the function input parameters itself
 

SAP BDC Interview Question - 15 : -

SM35 transaction . How to automate BDC ?

SAP BDC Interview Answer - 15 : -

After execution of batch input program , the session created is placed in the session queqe which can be viewed using SM35 transaction executing / Releseing the session will start the transfer of the data from the session into the database tables./