ABAP BDC

[Former Member]

Hi,

What is call transaction and Session ?

Step by Step procedure for Call transaction and Session?

when ( which secenario ) we go for call transaction and when ( which secenario ) we go for Session method?

Thanks in advance?

[Former Member]

Hi,

BDC Document Links:

Go thur these

http://help.sap.com/saphelp_erp2005/helpdata/en/fa/097119543b11d1898e0000e8322d00/frameset.htm

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

http://www.sap-img.com/abap/learning-bdc-programming.htm

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

http://www.sap-img.com/abap/learning-bdc-programming.htm

http://www.sapdevelopment.co.uk/bdc/bdchome.htm

http://www.planetsap.com/bdc_main_page.htm

Table Control in BDC

HI,

Refer the link:

http://www.sap-img.com/abap/bdc-example-using-table-control-in-bdc.htm

The concept is easy: it has to indicate the index of the table control in the field name, so if you have to populate the first record of table control:

BDC-FIELDNAME = <FIELDNAME>(01).

If you fill the second row:

BDC-FIELDNAME = <FIELDNAME>(02).

and so....

Now the problem is usually on how many records you have to load, because u can fill only the rows of table control available in the screen, If you have more records than it can be displayed yuo have to simulate the command to go next page.

The number of recod can be displayed can depend on pc resolution and many program haven't command to go to next page (in this case it could be impossible create a BDC program9.

A way to create a bdc program resolution indipendent is to work on the first and second row.

- Place the first hit in the first row of bdc;

- Place the second insert in the second row of bdc;

- Place the last hit to the top of table control;

- Place the next hit in the second row;

- Place the last hit to the top of table control;

- Place the next hit in the second row;

- .... and so

For more info: Search in SDN with TABLE CONTROL IN BDC.

Will get a lot of related links.

Here is the Difference between both:

- The most important aspects of the Batch session interface are:

1) Asynchronous processing

2) Transfers data for multiple transactions

3)Synchronous database update

During processing, no transaction is started until the previous transaction

has been written to the database.

4) A batch input processing log is generated for each session

5) Sessions cannot be generated in parallel

The most important aspects of the CALL TRANSACTION USING interface are:

1) Synchronous processing

2) Transfers data for a single transaction

3) Synchronous and asynchronous database updating both possible

The program specifies which kind of updating is desired.

4) Separate LUW for the transaction : The system performs a database commit immediately before and after the CALL TRANSACTION USING statement.

5) No batch input processing log is generated

See the below article, which will show which is one is better

http://www.itcserver.com/blog/2006/06/30/batch-input-vs-call-transaction/

Reward points if this Helps.

Manish

[Former Member]

Hi

Check the below link

<u>http://www.sap-img.com/abap/difference-between-batch-input-and-call-transaction-in-bdc.htm</u>

Message was edited by:

Vasudha L

[Former Member]

Hi,

Go through this link.You have detailed info along with the example.

http://allaboutsap.blogspot.com/search/label/BDC

Reward if helpful.

Regards,

Harini.S

[Former Member]

HI,

BOTH CALL TX & SESSION R USED FOR DATA MIGRATION

BDC TYPES :

1) BATCH INPUT : TWO TYPES a)SESSION METHOD

b)CALL TX

2) DIREXT METHOD

SESSION METHOD : IT IS A TWO PHASE MODEL

AFTER EXECUTING REPORT , AGAIN WE HAVE TO GO TO SESSION OVERVIEW

STEPS : i) DEFINE AN INTERNAL TABLE

ii)UPLOAD FLAT FILE INTO INTERNAL TABLE

iii) LOOP AT INTERNAL TABLE WHICH WE UPOLOADED

PREPARE BDC TABLE ( THIS TABLE SOULD BE LIKE ""BDCDATA"")

ENDLOOP.

IV) EXECUTE REPORT

V) GO TO SESSIUON OVERVIEW IN SM35

VI) EXECUTE THE SESSION

PREPARING BDC TABLE USING ""SHDB"" RECORDING

_______

CALL TX :

________

ITS A ONE PHASE MODEL , ALSO CALLED AS ONLINE MODEL

STEPS : PREPARE A INTERNAL TABLE

UPLOAD A FLAT FILE TO INTERNAL TABLE

LOOP AT INTERNAL TABLE

CALL TX SYNTAX

ENDLOOP

EXECUTE

GENERALLY WE WILL GO TO SESSION METHOD IF CLIENT DONT SPECIFY ANYTHING

IF U WANT TO SEE OUTPUT ONLINE GO TO CALL TX