BDC

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 5

Difference between /N and /BEND ?

/BEND terminates the batch input processing and sets the


session to be failed. 
/N terminates the current batch input transaction.

SM35 transaction . How to automate BDC ? 


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./

Update types in Call transaction method. What is the


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

What are the table controls in BDC ? What is the


difference between bdc and lsmw ? What is the
difference between bdc and rfc ? 
BDC - Batch data communication in which there are 2
processes 
1. in bound 
2. outbound 
RFC - remote fucntion call(or) calling

Data conversion experience? 


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

Open datasets, Read datasets ( Reading and writing data


to files)? 
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.

How to do back ground processing in BDC Session


method ?

goto sm35 
select the option background process

Call transaction method, how to capture the errors ? 


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.

How to load data from MS Excel sheet to SAP by using


BDC method ? 
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.

What is the difference between call transaction and


session method? 
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.

SM35 transaction . How to automate BDC ? 


sm35 is used to play girls for better nightfalls.

What is the difference between Upload and


WS_Upload ? 
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

If I want to execute a program only in background not in


foreground is there any option for this? 
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.

What kind of BDC programs are written ?

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
How to read files and process BDCs automatically? 
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

In session method sy-subrc is not returned whereas in


call transaction method sy-subrc is returned . what does
it mean? 
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.

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


background job without a variant ? 
Yes, user can create background job scheduling in two
ways. 

1. By calling the executable program RSBDCSUB 


2. Transaction Code SM37

What is BDC- its use, and how to use it? 


It is Batch Data conversion used for transferring some data other than sap into
sap ... this is also a work of an ABAPer. 
      
What is "UTS" Or may be it is "UST", something called Unit test?

Use:  After developing any object we should write a test case proving that the
object is working properly or not.  This is done by the ABAPer. This is UNIT
TEST CASE.

In BDC how can we handle Table Controls?

When you do your recording you will have a tab for Next line or Insert. You have
to capture that in your recording. If your transaction code doesn't have that in the
recording then you have to set up a page down (=P+) and loop it based on the line
entries u c on teh screen. 

Suppose we are transfer data through BDC from leagacy to SAP and their is
some duplicate data in legacy system but we don't want this in SAP system .So
how can we check that this data is already exist? 

In BDC you would have all your legacy data in an internal table. Use Delete
Adjacent dulpicates syntax to delete duplicate entries.

Can we use two transaction code in one BDC like XK01 & XD01 if yes how?

Yes, we can do that by combining the two bdc program codes together.  Then you
perform the program routine accordingly.  However, it will make your BDC
program very long and complex.

How can we handle errors in Function Module?

Exceptions is used to handle errors.

Can we use Session method & Call transaction both in one BDC if yes please
give me example and scenerio where we use this?

You start your dataload using Call Transaction and if any errors occur push all
those errors in a session so that your dataload takes place uninterrupted and you
can processs ur errors later.

You might also like